NEW
Font size
WorksheetsNormalisation
Total questions: 10
Worksheet time: 5mins
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
