Design of relational databases Quiz

Which of the following is TRUE about normalization?

• 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 normalization are the grouped attributes converted to individual attributes?

• Pre-normalization

• First

• Second

• Third

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

• composite primary key

• single primary key

• multiple foreign keys

• A Primary key AND a Foreign Key

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

• No partial dependencies

• No non-key dependencies

• No repeated attributes

• grouped attributes

What type of entity relationships always require a link table?

• One-to-One

• One-to-Many

• Many-to-Many

• Many -to -One- 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 normalization?

• Join many smaller tables

• Reduce data redundancy while merging smaller tables

• Creating a larger table with all entities

• None of the above

2NF

A relation must be in the first normal form and the relation must not contain any partial dependency.

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

• Yes

• No

3NF

Non key attributes (fields) are not dependent on another non key attribute (transitive dependency)

This table is in what form?

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

• Un-Normalised

• 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)

• UnNormalised

• 1NF

• 2NF

• 3NF