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 |
Why jdbc is used in java?
Why do we need jdbc driver?
What is jdbc in dbms?
RowSetInternal caller and returns void. What can I do in the readData method?
What is encrypted connection?
What are the types of jdbc drivers that exist?
What does the jdbc connection interface?
How can you create jdbc statements?
What is ojvm used for?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is the syntax of URL to get connection?
What are JDBC Best Practices?