Database Normalisation Quiz

What is the primary goal of normalisation in database design?

• To simplify queries

• To increase data redundancy

• To eliminate data anomalies

• To create more tables

What does 1NF stand for?

• First Normal Form

• First Notable Form

• First Normal Function

• First Non-Functional

Which of the following is NOT a goal of the normalisation process?

• Eliminating redundant data

• Reducing database size

• Ensuring data dependencies make sense

• Increasing data storage

What is a partial dependency?

• When a non-key attribute depends on the primary key

• When a primary key is made up of multiple attributes

• When an attribute is dependent on another non-key attribute

• When an attribute has no dependencies

Which normal form must a relation be in to qualify for 2NF?

• 1NF

• 3NF

• BCNF

• 4NF

What is the main characteristic of 3NF?

• No repeating groups

• No partial dependencies

• No transitive dependencies

• All attributes are dependent on the primary key

What happens to attributes that are partially dependent on a composite primary key?

• They are kept in the same relation

• They are removed to a new relation

• They are ignored

• They are merged with the primary key

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

• CustNo determines CustName

• OrderNo determines ProductNo

• CustName determines TelNo

• ProductNo determines UnitPrice

What is the purpose of functional dependency in normalisation?

• To create more tables

• To describe relationships between attributes

• To eliminate all data

• To increase redundancy

Which normal form is considered the strongest?

• Unnormalized DB

• 1NF

• 2NF

• 3NF