Answer / abhijeet chatterji

Normlization is the process with which we can reduce the
redundancy.

Answer / arun anoop m

Normalisation is to remove the redundancy.
Splitting into smaller oes without effect any data.

Answer / murtaza

normalization supports Atomicity which is one of d most impt
property in dbms.atomicity means there should be always one
record in a row.by this we can reduce the redundancy and
maintain consistency. as with this rule we go on normalizing
the tables depending upon the data dependency.
there r mainly 5 level of normalization
1.1NF(SUPPORTS ATOMICITY PROPERTY)
2.2NF(REDUCE REDUNDANCY)
3.3NF(FURTHER NORMALIZE D TABLES ACCORDING TO DATA DEPENDENCY)
4.BOYCE-CODD NF(SUPPORTS TRIVIAL DEPENDENCY)
5.5NF

Answer / shilpa

in normalization process ,the redundancy is reduce.there r
3 types of normalization

What are the requirements for sql server 2016?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

What is difference between count (*) and count column?

0 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

How do I find the query plan in sql server?

0 Answers  

---

Explain the usage of floor function in sql server.

0 Answers  

---

How many types of cursor type are there?

0 Answers  

---