NEW
Font size
WorksheetsUnderstanding Database Normalisation Concepts
Total questions: 10
Worksheet time: 5mins
Which of the following is a key principle of database design?
Ensuring data redundancy
Ensuring data integrity
Maximising data duplication
Minimising data access
In an Entity-Relationship Model, what does an entity represent?
A unique attribute
A real-world object or concept
A database table
A relationship between tables
Which normal form eliminates partial dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Which of the following is a technique used in database normalisation?
Data encryption
Data denormalisation
Data partitioning
Data decomposition
What is the requirement for a table to be in First Normal Form (1NF)?
No repeating groups or arrays
No partial dependencies
No transitive dependencies
No foreign keys
Which of the following is true for a table in Second Normal Form (2NF)?
It has no repeating groups
It has no partial dependencies
It has no transitive dependencies
It has no foreign keys
What is a relational database?
A database that stores data in a hierarchical format
A database that stores data in a network format
A database that stores data in tables with relationships
A database that stores data in a flat file
Which normal form ensures that there are no transitive dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
What is the purpose of database normalisation?
To maximize data duplication
To improve data integrity
To increase data redundancy
To decrease data retrieval speed
What is a primary key in a relational database?
A key that is used to link two tables
A unique identifier for each record in a table
A field that allows duplicate values
A key that is used to encrypt data
