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
Can we rollback after truncate?
What is sql keyword?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Why do we use joins in sql?
Can we insert in view in sql?
Can we delete column in sql?
Explain what is a view?
Why do we need sharding?
What is a constraint? Tell me about its various levels.
What is the use of function "module procedure" in pl/sql?
How many functions are there in sql?
What is rtm in testing?
Which join is default?
How to convert comma separated string to array in pl/sql?
What are actual parameters and formal parameters?
