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 is the process of indexing?

0 Answers  

---

Explain system rowset functions?

0 Answers  

---

Define self join?

0 Answers  

---

What are sql servers used for?

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

How to create an identity column?

0 Answers  

---

mention different types of relationships in the dbms?

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---