Database Quiz 2 Normalisation

What entity relationship between car and passenger?
Each driver can drive many different cars.
Each car is driven by many different drivers.

• one-to-one

• one-to-many

• many-to-many

Which of the following is the best statement about normalisation?

• It is the process of dividing larger tables into smaller interlinked tables.

• Reduces data redundancy.

• It is the process of dividing larger tables into smaller independent tables.

• It is the process of removing duplicate entries in a table.

Which normal form must not contain any repeating attributes &
at an atomic level (no single column contains more than one value) ?

• 1NF

• 2NF

• 3NF

• all of above

What entity relationship between car and passenger?
Each car has one owner, and each owner has one car
(this example assumes that nobody owns multiple cars).

• one-to-one

• one-to-many

• many-to-many

In which normal form shall we remove non-key attributes that depend on part but not all of the primary key?

• 1NF

• 2NF

• 3NF

It is possible to combine attributes to form what is called a _______ key

_____ are characteristics or other information about entities

In which stage of normalisation are the grouped attributes converted to individual attributes?

• First

• Second

• Third

A table in 1NF and with ……………….. is automatically in second Normal Form.

• composite primary key

• single primary key

• multiple foreign keys

In which normal form shall we remove non-key dependencies?

• 1NF

• 2NF

• 3NF