Understanding Database Normalisation Concepts

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