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 does the method Class.forName returns?

4 Answers   Siemens, TCS,


r u used any design patterns in your project?

3 Answers   Wipro,


Is jdbc faster than odbc?

0 Answers  


Explain about the Try Block?

0 Answers  


What are the steps involved in establishing a connection using jdbc in java?

0 Answers  






What type of driver called is pure Java driver?

3 Answers   Vertex,


What is jdbc databasemetadata interface?

0 Answers  


What is transaction processing in jdbc?

0 Answers  


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

0 Answers  


What type of driver you use in real-time projects?

3 Answers  


What will happen when ResultSet is not closed?

1 Answers   CTS,


What are static and dynamic queries?

1 Answers  


Categories