Understanding Database Normalisation Concepts

What is the primary goal of database normalisation?

• To increase data redundancy

• To reduce data redundancy and improve data integrity

• To make databases larger

• To decrease database performance

Which of the following is a requirement for a table to be in First Normal Form (1NF)?

• All columns must be dependent on the primary key

• All entries in a column must be of the same data type

• There must be no transitive dependencies

• The table must have a composite key

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

• It requires that all non-key attributes are fully functionally dependent on the primary key

• It eliminates all duplicate columns from the table

• It requires that all tables have a single primary key

• It ensures that all data is stored in a single table

Which of the following is true for a table in Third Normal Form (3NF)?

• It must be in 1NF and 2NF, and all attributes must be directly dependent on the primary key

• It must have no repeating groups

• It must have a composite key

• It must have no partial dependencies

What does an Entity Relationship Diagram (ERD) primarily represent?

• The physical layout of a database

• The relationships between entities in a database

• The user interface of a database application

• The performance metrics of a database

Which of the following is an example of a functional dependency?

• A table with no primary key

• A relationship where one attribute uniquely determines another attribute

• A table with multiple foreign keys

• A column that contains only unique values

In an ERD, what does a diamond shape typically represent?

• An entity

• An attribute

• A relationship

• A primary key

Which of the following is NOT a benefit of normalising a database?

• Improved data integrity

• Reduced data redundancy

• Increased complexity of queries

• Easier maintenance

What is the main purpose of identifying functional dependencies in a database?

• To determine the size of the database

• To identify relationships between tables

• To ensure data consistency and eliminate redundancy

• To create user interfaces

Which of the following is a violation of Third Normal Form (3NF)?

• A table with a composite key

• A table with transitive dependencies

• A table with a single primary key

• A table with no foreign keys