Use the ERD in Figure 1 to answer these questions. Underline your answers. These
ID: 3767576 • Letter: U
Question
Use the ERD in Figure 1 to answer these questions.
Underline your answers. These questions may have multiple answers. Underline them all for full credit.
1. If you convert this ERD to a set of relational tables, which table(s) will NOT have a foreign key in them?(Choose all that apply.)
a. Coupon
b. Customer
c. Sales Order
d. SO_Line_Item
e. Products
f. PO_Line_Item
g. Purchase Order
h. Vendor
2. Which of the following attributes could POrder_ID potentially functionally determine? (Select all that apply.)
a. QtyOnHand
b. OrderDate
c. OrderAmount
d. Address
e. ListPrice
f. ExtendedPrice
3. What is/are the foreign key(s) in the SO_Line_Item relational table?(Choose all that apply.)
a. SOrder_ID
b. Product_ID
c. SOrder_ID, Product_ID
d. SO_Line_Item_ID
e. None of these are a foreign key
Explanation / Answer
1. If you convert this ERD to a set of relational tables, which table(s) will NOT have a foreign key in them?(Choose all that apply.)
a. Coupon
b. Customer
c. Sales Order
d. SO_Line_Item
e. Products
f. PO_Line_Item
g. Purchase Order
h. Vendor
2. Which of the following attributes could POrder_ID potentially functionally determine? (Select all that apply.)
a. QtyOnHand
b. OrderDate
c. OrderAmount
d. Address
e. ListPrice
f. ExtendedPrice
3. What is/are the foreign key(s) in the SO_Line_Item relational table?(Choose all that apply.)
a. SOrder_ID
b. Product_ID
c. SOrder_ID, Product_ID
d. SO_Line_Item_ID
e. None of these are a foreign key
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.