Normalisation Quiz

Which of the following is TRUE 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.

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.

Which of the following is NOT necessarily an attribute of a table in second Normal Form?

• No partial dependencies

• No non-key dependencies

• No repeated attributes

• No grouped attributes

What type of entity relationships always require a link table?

• One-to-one

• One-to-many

• Many-to-many

Which of the following is NOT necessarily an attribute of a table in first Normal Form?

• No partial dependencies

• No non-key dependencies

• No repeated attributes

• Both A and B

Which of the following is the main motive of normalisation?

• Join many smaller tables

• Reduce data redundancy while merging smaller tables

• Creating a larger table with all entities

• None of the above

Is this table in second Normal Form: purchase (customerID, storeID, storeLocation)?

• Yes

• No

This table is in what form? OrderDetails (OrderID, OrderDate, CustomerID, CustomerName, CustomerAddress)

• 1NF only

• 2NF

• 3NF

This table, given to teachers, manages the locations and timings of sessions of teachers in a school. This table is in what form? sessionDetails (teacherID, courseID, sessionLocation, sessionTimings)

• 1NF only

• 2NF

• 3NF