Which of the following statements about the relational model is FALSE?

A table named "Orders" has the following attributes:

(OrderID, CustomerID, CustomerName, ProductID, ProductName, Quantity, OrderDate)

Note: The underlined columns/attributes are PKs.

Which of the following dependencies, if identified, would indicate a partial dependency?

Consider the following relation:

Sales (SaleID, ProductID, ProductName, SaleDate, Quantity, UnitPrice, TotalPrice).

Note: The underlined columns/attributes are PKs.

Which of the following dependencies exist in this relation? (Select all that apply)

You are designing a database for a library system with the following requirements:

• Each Book has a unique ISBN, Title, and Author.

• Members can borrow multiple Books, but each Borrow Transaction must record the Date Borrowed, Due Date, and Return Date.

Which of the following is the best approach to design this schema in 3NF?

Consider the following relation: Project (ProjectID, ProjectName, ManagerID, ManagerName, DepartmentID, DepartmentName). The following dependencies exist:

• ProjectID → ProjectName, ManagerID, DepartmentID

• ManagerID → ManagerName

• DepartmentID → DepartmentName

Note: The underlined column/attribute is PK. 

What is the minimum number of tables required to normalize this relation to 3NF?

A table called "Employee" has the following attributes: (EmployeeID, DepartmentID, DepartmentName, EmployeeName). The following dependencies exist:

• EmployeeID → EmployeeName, DepartmentID
• DepartmentID → DepartmentName

The relation Order (OrderID, ProductID, Quantity, ProductName) has the following dependencies:

• OrderID, ProductID → Quantity
• ProductID → ProductName

Note: the underlined columns are PKs.

Which of the following statements is correct?

When normalizing a relation to 3NF, which of the following steps is NOT required?

Which of the following is NOT a valid method to convert an ER model to a relational schema?

What is the primary purpose of normalization?