What are the Normalization Rules?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the utilities of the callablestatement?

706


What is JDBC Batch Processing and what are it’s benefits?

689


What is connection data?

651


How can you make a connection?

702


How do I receive a ResultSet from a stored procedure?

699


What are 4 drivers available in JDBC? At what situation are four of the drivers used?

679


How can we store and retrieve images from the database?

698


What are the three basic components of the odbc architecture?

652


Compare jdbc and odbc and how is jdbc required in this context.

689


Explain the main method?

758


How can I write to the log used by DriverManager and JDBC drivers?

726


What is jdbc odbc?

728


What is a jdbc url?

613


Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

767


What is metadata in programming?

732