Answer Posted / hr@tgksolutions.com
Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What view means?
What is pivot query?
Is pl sql a programming language?
How to run sql functions in pl/sql?
How do you clear the screen in sql?
How do I view a procedure in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
how do you control the max size of a heap table? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
Do we need to create index on primary key?
How does left join work in sql?
What are the different schemas objects that can be created using pl/sql?
Which are sql * plus commands?
Mention what are different methods to trace the pl/sql code?
How do you create a unique index?