Normalisation

1.Which of the following is TRUE about normalisation?

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

• Increases 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?

• 1st

• 2nd

• 3rd

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

• Composite primary key

• Single primary key

• Multiple foreign keys

Which of the following is NOT necessarily an attribute of a table in 2nd 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 1st 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 2NF: purchase (customerID, storeID, storeLocation)?

• Yes

• No

9.This table is in what form?

OrderDetails (OrderID, OrderDate, CustomerID, CustomerName, CustomerAddress)

• 1NF

• 2NF

• 3NF

10.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

• 2NF

• 3NF