What are the Normalization Rules?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the steps involved in establishing a connection using jdbc in java?
What are the different types of classes in the api component?
Does jpa use jdbc?
How many locking systems are there in jdbc?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
How can I determine where a given table is referenced via foreign keys?
How can I manage special characters when I execute an insert query?
How transactions are performed using JDBC ?
What is JDBC ResultSet?
What are statements in JAVA ?
How java can be connected to a database?