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 setautocommit do?
Explain the two tier and three tier architecture of jdbc.
how can we get the metaData (columnNames) from a table which has no Records..
What is jdbc odbc bridge?
Can the JDBC-ODBC Bridge be used with applets?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
How do I receive a ResultSet from a stored procedure?
What types of DataSource objects are specified in the Optional Package?
What are the flow statements of jdbc?
What is a Connection?
What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question is when that precompiled statement will be execute or comiple?................
What do you mean by two phase commits?