What are the Normalization Rules?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the exceptions in jdbc?
What is meant by dao?
How do I find jdbc version?
Name the new features added in jdbc 4.0.
What is createstatement method in java?
What is jdbc odbc in java?
Why “no suitable driver” error occurs?
What is jdbc drivers in java?
What is the JDBC?
How many packages are available in jdbc api?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
What are the standard isolation levels defined by JDBC?