Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Normalization Rules?
- 2 Answers
- 5826 Views
- I also Faced
- E-Mail Answers
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 temp tables ?
Explain the importance of drivermanager.
How to get a whole row of data at once?
Explain the life cycle of jdbc.
What is JDBC RowSet? What are different types of RowSet?
What is execute(), executeUpdate() and executeQuery() methods?
What is the difference between ExecuteUpdate and ExecuteQuery?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
What are different types of ResultSet?
How do I know which jdbc driver to use?
What are jdbc?
Core Java 
