Database Design & Development Normalisation 1

What is the main goal of the First Normal Form (1NF) in database normalisation?

• To eliminate repetitive groups of data

• To ensure referential integrity

• To reduce data redundancy

• To establish foreign keys

Which form of normalisation is achieved when transitive dependencies are removed?

• First Normal Form

• Second Normal Form

• Third Normal Form

• Boyce-Codd Normal Form

What is a partial dependency in the context of normalisation?

• A dependency on a non-primary key

• A dependency involving a candidate key

• A dependency on part of a composite key

• A dependency on a foreign key

In which normal form is a table if it contains no transitive dependencies but still has partial dependencies?

• 1NF

• 2NF

• 3NF

• 4NF

Which of the following is a characteristic of a table in Second Normal Form (2NF)?

• It has no transitive dependencies

• It has no partial dependencies

• It has no duplicated data

• It has a primary key

When is a table considered to be in Third Normal Form (3NF)?

• When it is in 2NF and all non-key attributes are mutually independent

• When it is in 2NF and there are no transitive dependencies

• When it is in 1NF and all attributes are atomic

• When it is in 4NF and has no multivalued dependencies

What does the term "functional dependency" imply in the context of normalisation?

• An attribute uniquely determines another attribute

• A table is in 2NF

• There are no repeating groups

• All attributes are atomic

In database design, what is the primary key's role in normalisation?

• To create foreign keys

• To uniquely identify each record

• To eliminate data redundancy

• To establish relationships between tables

What is the minimum normal form required to ensure that a database table is free from update anomalies?

• 1NF

• 2NF

• 3NF

• BCNF

Which of the following is a characteristic of a table in First Normal Form (1NF)?

• It has no partial dependencies

• It has no transitive dependencies

• It contains only atomic values

• It has no multivalued dependencies