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
How can you save or place your msg in a table?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Which are the different types of indexes in sql?
What is rank function in sql?
What are hotfixes and patches?
What is nvarchar in sql?
how to select unique records from a table? : Sql dba
What is user defined functions?
How does stored procedure reduce network traffic?
what is the difference between join and union? : Sql dba
What is sql*loader and what is it used for? : aql loader
Why indexing is needed?
How many columns should be in an index?
What is an implicit commit?
What is pl sql in oracle?