Unit 2 Relational Databases 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 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.

• a composite primary key

• a single primary key

• a multiple foreign keys

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

• A.No partial dependencies

• A.No non-key dependencies

• A.No repeated attributes

• A.No grouped attributes

What type of entity relationships always require a link table?

• A.One-to-one

• A.One-to-many

• A.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

• 2NF

• 3NF