Common Order System

Customer

Order

Salesperson

Item

OrderItem

1

*

1

*

1

*

1

*

Customer(CustomerID, Name, Address, City, Phone)

Salesperson(EmployeeID, Name, Commission, DateHired)

Order(OrderID, OrderDate, CustomerID, EmployeeID)

OrderItem(OrderID, ItemID, Quantity)

Item(ItemID, Description, ListPrice)

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本