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 type of driver you use in real-time projects?
What causes the "No suitable driver" error?
Why is odbc needed?
Describe odbc?
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
What is JDBC and ODBC and what are the differences between them?
11 Answers Idbi Bank, Infosys, Infoview, TCS,
Where is jdbc url mysql?
give me a java code snippet to connect Microsoft excel through.... I am trying alot... plz help me.
what is the meaning of following code snippets Class c=class.forName(driverClassName); Driver d=(driver)c.newInstance();
What is Connection Pooling ??? How we set up a particular connection within connection pooling ????
Where is mysql jdbc driver located?
What are different types of ResultSet?