EQUIPMENT |
ID EquipmentNumber Description AcquisitionDate PurchaseCost |
EQUIPMENT |
|
HOTEL-BILL |
ID InvoiceNumber ArrivalDate CustomerName TotalDue DailyCharge ID ChargeDate |
HOTEL-BILL |
| ||
DAILY-CHARGE |
|
Object2 Can Contain | Object1 Can Contain | ||
---|---|---|---|
One | Many | ||
One | 1:1 | 1:N | |
Many | M:1 | M:N |
|
|
MEMBER |
| ||
LOCKER |
|
|
|
EQUIPMENT |
| ||
REPAIR |
|
|
|
BOOK |
| ||
AUTHOR |
| ||
BOOK-AUTHOR-INT |
|
|
|
|
|
SALES-ORDER |
| ||
CUSTOMER |
| ||
SALESPERSON |
| ||
LINE-ITEM |
| ||
ITEM |
|
|
| ||||
|
AIRPLANE |
| ||
PILOT |
| ||
FLIGHT |
|
|
|
PERSON |
| ||
STUDENT |
| ||
PROFESSOR |
|
PERSON1 |
| ||
PERSON2 |
|
|
|
PRODUCT |
| ||
RELEASE |
|
SUBSCRIPTION |
ID SubNumber StartDate EndDate AmtDue Name Address City State Zip PayCode |
SUBSCRIPTION |
|
|
|
CUSTOMER |
|
SUBSCRIPTION |
|
CEREAL-PRODUCT |
ID Name ServingSize NumberServings Nutrient ID NutrientName CerealOnlyAmount WithMilkAmt USDARecDailyAllow ID VitaminName CerealOnlyPercent WithMilkPercent Ingredient VitaminIron |