3. What is the primary key of this table? How can we designate it? Field Name Da
ID: 3594695 • Letter: 3
Question
3. What is the primary key of this table? How can we designate it?
Field Name
Data Type
Field Size
Req’d
Allow Zero Length
Index
Description
Order_ID
Number
Long Integer
Decimal Places: Auto
Default Value: 0
Yes
Yes (duplicates allowed)
Order Identifier
Product_ID
Number
Long Integer
Decimal Places: Auto
Default Value: 0
Yes
Yes
(duplicates allowed)
Product ordered
Quantity
Number
Long Integer
Decimal Places: Auto
Default Value: 0
No
No
Number ordered on this order
Field Name
Data Type
Field Size
Req’d
Allow Zero Length
Index
Description
Order_ID
Number
Long Integer
Decimal Places: Auto
Default Value: 0
Yes
Yes (duplicates allowed)
Order Identifier
Product_ID
Number
Long Integer
Decimal Places: Auto
Default Value: 0
Yes
Yes
(duplicates allowed)
Product ordered
Quantity
Number
Long Integer
Decimal Places: Auto
Default Value: 0
No
No
Number ordered on this order
Explanation / Answer
Answer: Order_ID should be the primary key because Order_ID should be unique and not null value for each order that customer make. So in this case, Order_ID should a primary key.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.