Databases and Normalisation

An entity is represented by what in a database?

• Table

• Row

• Column

• Cell

A record is represented by what in a database?

• Table

• Row

• Column

• Cell

An attribute is represented by what in a database?

• Table

• Row

• Column

• Cell

Which of these are required for a relational database to meet 1st normal form?

• Data must be atomic

• No repeating groups of data

• No repeating attributes

• Sets of data must have a unique identifier

• Must meet 2nd normal form

Which of these are required for a relational database to meet 2nd normal form?

• Must meet 1st normal form

• All the non-key attributes must depend on the whole primary key

• All the non-key attributes must not depend on another non-key attribute

• Must meet 3rd normal form

Which of these are required for a relational database to meet 3rd normal form?

• Must meet 2nd normal form

• All the non-key attributes must depend on another non-key attribute

• All the non-key attributes must not depend on another non-key attribute

• Must meet 4th normal form

What is the purpose of normalisation?

• Eliminate redundant data

• Reduce data inconsistencies

• Produce redundant data

• Increase data inconsistencies

Which type of relationship does the ERD represent?

• One-to-many

• Many-to-many

• One-to-one

Which type of relationship does the ERD represent?

• One-to-many

• Many-to-many

• One-to-one

In a RDBMS such as MS Access, which type of relationship is required to create relationships between entities?

• One-to-many

• Many-to-many

• One-to-one