What are the Normalization Rules?
- 2 Answers
- 4968 Views
- I also Faced
- E-Mail Answers
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 is difference between jdbc and odbc?
What is the return type of execute, executequery and executeupdate?
What are the higher level apis under development on top of jdbc currently?
How can I get or redirect the log used by DriverManager and JDBC drivers?
How can we retrieve data from the resultset?
What is PreparedStatement?
How can you use preparedstatement in jdbc?
How does a file store compare with a jdbc store?
What is the use of jdbc?
Difference between servlet and applet method?
What packages are used by jdbc?
What is the exception thrown by JDBC ?
Core Java 
