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 is meant by connection pooling?
What are different parts of a url?
What are the differences between stored procedure and functions?
what are design patterns?
How can I determine where a given table is referenced via foreign keys?
What is drivermanager in java?
What is use of connection pooling?
What are the jdbc api components?
What is jdbc resultsetmetadata interface?
State the different connection methods used for creating different types of sql.
How vendor Naming registry supports JNDI?
Is uri the same as url?