Explain different types of Normalization.
Answer Posted / hr@tgksolutions.com
• 1NF (First Normal Form) – Eliminates duplicate columns, ensures atomicity.
• 2NF (Second Normal Form) – Removes partial dependencies.
• 3NF (Third Normal Form) – Removes transitive dependencies.
• BCNF (Boyce-Codd Normal Form) – Ensures every determinant is a candidate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a ddl statement?
What is difference between index and primary key?
What is policy management?
What is the datatype of rowid?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What security features are available for stored procedure?
How to write a query with a left outer join in ms sql server?
What are different types of table joins?
What is a db view?
What is the return type of executeupdate ()?
How to optimize stored procedure optimization?
last function used in MS Access to convert sql what function will use in sql
How do I change my passwords (database, LDAP, and so on) without causing an outage?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What does normalization do to data?