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
Can we have foreign key reference to a non primary key column ?
What are the steps involved in establishing a connection using jdbc in java?
List the common jdbc exceptions ?
What is the difference between jdbc and odbc?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Explain the locking system in jdbc?
Why jdbc is used in java?
What is addbatch jdbc?
How java can be connected to a database?
What are the steps required to execute a query in jdbc?
What are the conditions applies to varchar variable, when using in procedures?
Explain jdbc savepoint?
How to connect multiple database in jdbc?
What do you mean by database connection pooling?
What is JDBC ResultSet?