Database Normalization Seatwork

What is Database Normalization?

• A systematic process of organizing a database schema

• A method to increase data redundancy

• A way to create duplicate data

• A technique to avoid data integrity

What is the goal of the normalization process?

• Organize data efficiently

• Increase data redundancy

• Create more anomalies

• Store data in multiple places

What is an Insertion Anomaly?

• Inability to add new data without also adding related data

• Accidental loss of data when deleting a record

• The need to update multiple records to change a single piece of information

• A method to increase data redundancy

What does the term 'data integrity' refer to in databases?

• The ability to store data in multiple formats

• The redundancy of data across tables

• The process of normalizing data

• The accuracy and consistency of data over its lifecycle

What is the First Normal Form (1NF)?

• All rows must be unique

• No partial dependencies

• No transitive dependency

• All fields must be determined by the Primary Key

What is a characteristic of the Second Normal Form (2NF)?

• No partial dependencies

• All rows must be unique

• No transitive dependency

• All fields must be determined by the Composite Key

What is a requirement for the Third Normal Form (3NF)?

• No transitive dependency

• All rows must be unique

• No partial dependencies

• All fields must be determined by the Primary Key

What does Boyce-Codd Normal Form (BCNF) aim to do?

• Remove anomalies that 3NF doesn't catch

• Increase data redundancy

• Create more anomalies

• Ensure all fields are determined by the Composite Key

What is the purpose of normalization in database design?

• To ensure proposed entities meet the required normal form

• To create duplicate data

• To increase data anomalies

• To avoid data integrity

What is denormalization?

• Creation of normalized relations

• A method to increase data redundancy

• A technique to avoid data integrity

• A way to create duplicate data