Explain the concept of normalization.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / glibwaresoftsolutions
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 |
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 |
How many sql commands are there?
what are date and time data types in mysql? : Sql dba
How do you modify a table in sql?
write a query to delete similar records in particular fields(columns) in different tables
What is the maximum number of triggers, you can apply on a single table?
Why we use triggers in mysql?
What are all the different types of indexes?
Which operator is used in query for pattern matching?
What are aggregate functions in sql?
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
Is left join and outer join same?
How do you create a unique index?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)