In analyzing the following diagram, what is wrong with one of the relationships?

Question

In analyzing the following diagram, what is wrong with one of the relationships?

a.The line between ORDER and ORDER_ITEM needs to be one to one or many. CUSTOMMER CustomerID: VARCHAR [PK ] FirstName: VARCHAR LastName: VARCHAR Address: WARCHAR : VARCHAR tate: VARCHAR Zip: VARCHAR Phone: VARCHAR ORDER ORDER ITEM rderID: VARCHAR [PK] rderItemID: VARCHAR [PK ] rderDate: WARCHAR CustomerID: VARCHAR [FK ] EmployeeID: VARCHAR [FK] ItemID: VARCHAR [FK] OrderID: VARCHAR [FK ] EMPLOYEE EmployeeID: VARCHAR [PK ] uantity: ARCHAR rice: VARCHAR irstName: VARCHAR LastName: VARCHAR Address: VARCHAR : VARCHAR ITEM ItemID: VARCHAR [ PK] tate: VARCHAR Zip: VARCHAR : VARCHAR cription: VARCHAR leSaleCost: VARCHAR : VARCHAR SSN: VARCHAR ireDate: VARCHAR TermDate: VARCHAR RetailCost: VARCHAR

Explanation / Answer

Answer: b relationship is wrong

a. The line between ORDER and ORDER_ITEM needs to be one to one or many.This relationship is correct because one order can contain one or many order items. So many order item ids can contain same order id.

b. The line between ORDER and ORDER_ITEM needs to be zero to one or many. This relationship is not correct because every order item id in order_item table must be associated with at least one order id. so this relationship can't be zero to one or many.

c. The line between EMPLOYEE and ORDER should be one to one or many. This relationship is correct because many orders can be associated with one employee.

d. The line between CUSTOMER and ORDER should be one to one or many. This relationship is correct because one customer can have many orders.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.