Question 24
Database ManagementUse Figure 4 to answer questions 23 and 24.
Which of the following lists contains the primary keys in Figure 4?
- A.Customers, Orders and Products.
- B.customerId, OrderId, ProductId.
- C.CustomerId, FirstName, LastName and DateCreated.
- D.Customers, CustomerId, FirstName, LastName and DateCreated.
Show the answer and explanation
Answer: B (customerId, OrderId, ProductId.)
Explanation
Each table's primary key is its ID field: CustomerId, OrderId and ProductId.