6
QuizMultiple Choice

Introduction

Question 6 • Introduction to Information Technology - EL3701

Which field would best function as a primary key for a table that tracks orders?

Answer
A
OrderDate
B
CustomerType
C
OrderID
D
CustomerID

Explanation

A primary key must uniquely identify each row in the table. OrderID is assigned to identify a specific order, while dates or customer categories may repeat, and one customer can place multiple orders. Therefore, OrderID is the best primary key.

AI-written and checked against the verified answer.

Previous
Next