Use the ERD in Figure 1 to answer these questions. 1. How many 1-to-1 relationsh
ID: 3767566 • Letter: U
Question
Use the ERD in Figure 1 to answer these questions.
1. How many 1-to-1 relationships are in the ERD?_____
2. How many 1-to-M relationships are in the ERD?_____
3. How many M-to-M relationships are in the ERD?_____
4. How many weak entities are in the ERD?_____
5. How many tables will you have when you convert the ERD to relational tables?______
6. Where do you place the foreign key to capture the “applied_to” relationship between Coupon and Sales Order?Explain why.
7. Describe one business policy (think assumption!) this business has that is captured in their ERD.
MULTIPLE CHOICE QUESTIONS
8. What is the primary key for the SO_Line_Item table? (Be sure and turn off spellchecking in Word so you can see the underlines in the choices below!)
a. SO_Line_Item_ID
b. SOrder_ID, Product_ID
c. SOrder_ID , Product_ID
d. SOrder_ID
e. Product_ID
f. The SO_Line_Item table does not have a primary key.
9. The owner of the business comes to you with the ERD and explains, “ I need to be able to track the number of each product that I sell, so I can track the best- and worst-selling products.”Then she asks, “To track this, which of that ERD entities do I need to place a ‘quantity’ attribute on?”
a. Coupon
b. Customer
c. Sales Order
d. SO_Line_Item
e. Products
f. PO_Line_Item
g. Purchase Order
h.Vendor
10. Later the business owner comes back to you and says, “Okay, next problem. I want to run a perpetual inventory system. I’m always re-ordering products from my vendors and most of my products are seasonal so the price fluctuates. For example, if I order a specific scarf in December the vendor may charge me $2.75 per scarf. However, if I order it in July, the vendor may charge me $5.25 per scarf. I need to be able to track the price I paid for a particular product on a given purchase order, so I can accurately calculate my cost of goods sold. So, to which of the ERD entities should I add the attribute ‘UnitCost?’”
a. Coupon
b. Customer
c. Sales Order
d. SO_Line_Item
e. Products
f. PO_Line_Item
g. Purchase Order
h. Vendor
11. What table would you look in to find the number of products on a specific sales order?
a. Sales Order
b. SO_Line_Item
c. Products
d. Either A or C
e. Any of above three tables will contain the needed information
f. None of them, this database is not designed to answer this question
12. Which of the following is NOT true about the primary key(s) in the PO_Line_Item relational table?
a. There are two primary keys
b. It is a composite primary key
c. The primary key includes POrder_ID and Product_ID
d. All of the above are true
13. What ERD entity constitutes the “border” between the revenue cycle information and the expenditure cycle information?
a. Coupon
b. Customer
c. Sales Order
d. SO_Line_Item
e. Products
f. PO_Line_Item
g. Purchase Order
h. Vendor
g. This ERD does not distinguish between revenue and expenditure cycle information.
14. What primary key from the ERD will functionally determine the list price of a product? List price is defined as the price we list the product for in the catalog.
a. SOrder_ID
b. SOrder_ID, Product_ID
c. Product_ID
d. POrder_ID, Product_ID
e. POrder_ID
15. You need to be able to identify the customer (i.e., Cust_ID) associated with every sales order.What primary key in the ERD will functionally determine the Cust_ID?
a.Cust_ID
b. SOrder_ID
c. Cust_ID, SOrder_ID
d. POrder_ID, Product_ID
e. POrder_ID
16. What’s the primary key for the Coupon entity?
a. SOrder_ID
b. SOrder_ID, Cust_ID
c. Cust_ID
d. Any of the above
e. None of the above
Explanation / Answer
1.[2]
2.[3]
3.[0]
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.