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 is meant by connection pooling?

4 Answers  


What are different parts of a url?

0 Answers  


What are the differences between stored procedure and functions?

0 Answers  


what are design patterns?

3 Answers   CFC, TCS, Wipro,


How can I determine where a given table is referenced via foreign keys?

0 Answers  


What is drivermanager in java?

0 Answers  


What is use of connection pooling?

0 Answers  


What are the jdbc api components?

0 Answers  


What is jdbc resultsetmetadata interface?

0 Answers  


State the different connection methods used for creating different types of sql.

0 Answers  


How vendor Naming registry supports JNDI?

0 Answers  


Is uri the same as url?

0 Answers  


Categories