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

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

What is a job?

3 Answers  

---

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

---

What is the ‘fillfactor’?

0 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

Explain the stored procedure?

0 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

what's the maximum size of a row? : Sql server database administration

0 Answers  

---

What is indexed view?

0 Answers  

---

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---