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

Can we have foreign key reference to a non primary key column ?

514


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

499


List the common jdbc exceptions ?

547


What is the difference between jdbc and odbc?

508


How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

570






Explain the locking system in jdbc?

518


Why jdbc is used in java?

460


What is addbatch jdbc?

513


How java can be connected to a database?

544


What are the steps required to execute a query in jdbc?

510


What are the conditions applies to varchar variable, when using in procedures?

1594


Explain jdbc savepoint?

544


How to connect multiple database in jdbc?

471


What do you mean by database connection pooling?

496


What is JDBC ResultSet?

576