What are the Normalization Rules?

Answers were Sorted based on User's Feedback



What are the Normalization Rules?..

Answer / p.thirugnanam

Noramlization means decomposing the tables and define well
structure to reduce the data reduntancy.

Normalization classified three types.
First Normalization form : It eliminate multiple values
atttributes.

Second Normalization form : It eliminate the partial
dependency.

Third Normalization form : It elimiate the functional
dependency.

Partial dependency means non-key value depends on one
primary key value.

functional dependency means two non-key values.

Is This Answer Correct ?    3 Yes 0 No

What are the Normalization Rules?..

Answer / pavan

Normalization is the process of decomposing a larger table
into smaller tables inorderto free from the enamalies
reguarding insertion, deletion and alter.

Normal forms are: 1NF(Normal Form), 2NF, 3NF, BCNF, 4NF and
5NF.

The rules: No data loss.
Dependency preserving.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More JDBC Interview Questions

What are the exceptions in jdbc?

0 Answers  


What is meant by dao?

0 Answers  


How do I find jdbc version?

0 Answers  


Name the new features added in jdbc 4.0.

0 Answers  


What is createstatement method in java?

0 Answers  






What is jdbc odbc in java?

0 Answers  


Why “no suitable driver” error occurs?

0 Answers  


What is jdbc drivers in java?

0 Answers  


What is the JDBC?

0 Answers  


How many packages are available in jdbc api?

0 Answers  


Give a way to check that all result sets have bin accessed and update counts are generated by execute method.

0 Answers  


What are the standard isolation levels defined by JDBC?

0 Answers  


Categories