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 does the method Class.forName returns?
r u used any design patterns in your project?
Is jdbc faster than odbc?
Explain about the Try Block?
What are the steps involved in establishing a connection using jdbc in java?
What type of driver called is pure Java driver?
What is jdbc databasemetadata interface?
What is transaction processing in jdbc?
State the different connection methods used for creating different types of sql.
What type of driver you use in real-time projects?
What will happen when ResultSet is not closed?
What are static and dynamic queries?