Answer Posted / nashiinformaticssolutions
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
Is primary key always clustered index?
Is inner join faster than left join?
Does group by remove duplicates?
what is bcp? When does it used? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how many tables will create when we create table, what are they? : Sql dba
What is the current version of postgresql?
what are aggregate and scalar functions? : Sql dba
what is schema? : Sql dba
What is the current version of sql?
How do I remove duplicates in two columns?
Can delete statement be rollbacked?
Do we need to rebuild index after truncate?
Can we use distinct and group by together?
