Year 12 Database Design Quiz

What is the main purpose of database normalisation?

• To increase data redundancy

• To reduce data redundancy and improve data integrity

• To make databases larger

• To decrease database performance

Which normal form eliminates repeating groups in a database table?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

In an Entity-Relationship Diagram (ERD), what does a diamond shape represent?

• Entity

• Attribute

• Relationship

• Primary Key

What is a primary key in a database?

• A field that can have duplicate values

• A field that uniquely identifies each record in a table

• A field that is always left empty

• A field that stores foreign data

Which of the following is an example of a foreign key?

• A unique identifier for a table

• A field in a table that is a primary key in another table

• A field that contains only numeric data

• A field that is always null

What is data redundancy?

• The process of normalising data

• The unnecessary duplication of data in a database

• The use of primary keys

• The use of foreign keys

Which SQL command is used to retrieve data from a database?

• INSERT

• DELETE

• SELECT

• UPDATE

What is an anomaly in the context of databases?

• A perfectly normal database operation

• A problem that arises from data redundancy

• A type of SQL query

• A database management system

Which of the following is a Database Management System (DBMS)?

• Microsoft Word

• MySQL

• Adobe Photoshop

• Google Chrome

What does the SQL command `UPDATE` do?

• It deletes records from a table

• It retrieves data from a table

• It modifies existing records in a table

• It creates a new table