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
What is duration in sql profiler trace?
What are the key differences between SQL and PL SQL?
What are all the common sql functions?
What is primary key in db?
How do you write a complex sql query?
What are sql*plus environment variables?
What is scalar data type in pl sql?
What is cursor and why it is required?
What is before and after trigger?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the sql commands?
Are stored procedures faster than queries?
Is mariadb a nosql database?
What is basic structure of pl sql?
What does partition by mean in sql?