Normalized Order Management Database
ilujpssu_mis3101_order_mgmt.xls
Sheet1
ORDER MANAGEMENT | ||
Entity-Relationship | ||
ITEM: | ||
Customer Header | ||
· customer number | ||
· buyer name | ||
· bill-to address | ||
· buyer phone | ||
· buyer email | ||
· credit rating | ||
Customer Shipping | ||
· location number | ||
· receiver name | ||
· receiver phone | ||
· receiver email | ||
· ship-to address | ||
Order Header | ||
· order number | ||
· order date | ||
· shipment method | ||
Order Detail | ||
· item number | ||
· part number | ||
· unit price | ||
· total quantity | ||
Delivery Schedule | ||
· delivery number | ||
· location number | ||
· quantity | ||
· due date | ||
Part | ||
· part number | ||
· standard price | ||
Customer-Part Relationship | ||
· customer number | ||
· part number | ||
· special price |