Normalization of Data Quiz

Emily is managing a database for an online store. What is the primary purpose of the OrderDetails table?

• To store customer addresses

• To link orders with products

• To calculate total prices

• To record order dates

Answer explanation

The primary purpose of the OrderDetails table is to link orders with products. It contains information about which products are included in each order, making it essential for managing order fulfillment.

Arjun is organizing his customer database. Which of the following fields is NOT part of the Customers table after normalisation?

• CustomerID

• CustomerName

• CustomerAddress

• OrderDate

Answer explanation

After normalization, the Customers table should only include fields directly related to the customer. 'OrderDate' pertains to orders, not customers, making it the field that is NOT part of the Customers table.

In a database management class, Lily is learning about data normalization. What is the main benefit of normalising data as described in Scenario 1?

• Increased data redundancy

• Simplified data structure

• Enhanced data security

• Faster data processing

Answer explanation

The main benefit of normalizing data is a simplified data structure. This process reduces redundancy and organizes data efficiently, making it easier to manage and maintain.

In the unnormalised data of a retail store, which field represents the date of the order?

• OrderID

• OrderDate

• ProductID

• Quantity

Answer explanation

The field 'OrderDate' specifically indicates the date when the order was placed, making it the correct choice. 'OrderID' identifies the order, 'ProductID' refers to the item, and 'Quantity' indicates the amount ordered.

Chloe is managing a database of customers. Which field is used to uniquely identify a customer in the Customers table?

• CustomerName

• CustomerAddress

• CustomerID

• OrderID

Answer explanation

The CustomerID field is used to uniquely identify each customer in the Customers table. Unlike CustomerName or CustomerAddress, which can be duplicated, CustomerID ensures each entry is distinct.

Sophia is managing a database for her company. What is the primary key in the Employees table?

• EmployeeName

• DepartmentID

• EmployeeID

• DepartmentManager

Answer explanation

The primary key uniquely identifies each record in a table. In the Employees table, EmployeeID is the best choice as it is unique for each employee, while EmployeeName and DepartmentID may not be unique.

What is the relationship between 'OrderID' and 'ProductID' in the 'OrderDetails' table?

• One-to-one

• Many-to-many

• One-to-many

• Many-to-one

Answer explanation

In the 'OrderDetails' table, each 'OrderID' can relate to multiple 'ProductID's, and each 'ProductID' can appear in multiple 'OrderID's. This creates a many-to-many relationship between 'OrderID' and 'ProductID'.

Chloe is organizing her bookshelf. Which field is NOT part of the 'Books' table?

• BookID

• AuthorName

• Price

• BookTitle

Answer explanation

The 'Books' table typically includes fields like BookID, Price, and BookTitle. AuthorName is not a standard field in this context, making it the correct answer.

Florence is organizing a database for her business. Which table includes the fields SupplierID and SupplierName?

• Products

• SupplierProducts

• Suppliers

• Unnormalised Data

Answer explanation

The table 'Suppliers' includes fields related to suppliers, such as SupplierID and SupplierName. The other options do not specifically contain these fields, making 'Suppliers' the correct choice.

Ella is working on a project about Scenario 5. What is the main focus of Scenario 5?

• Customer data management

• Supplier and product data management

• Employee data management

• Financial data management

Answer explanation

Scenario 5 primarily focuses on managing supplier and product data, which is essential for ensuring efficient supply chain operations and product availability.