orderNo=orderNo1:n
Customer
customerNocustomerNamecustomerStreetcustomerCitycustomerStatecustomerZipCodecustomerTelNocustomerFaxNomaritalStatuscreditRating
Employee
employeeNotitlefirstNamemiddleNamelastNameaddressworkTelExthomeTelNoempEmailAddresssocialSecurityNumberpositionsexsalarydateStarted
sMethodNo=sMethodNo1:n
PaymentMethod
pMethodNopaymentMethod
employeeNo=employeeNo1:n
Shipment
shipmentNoquantityshipmentDatecompleteStatusorderNoproductNoemployeeNosMethodNo
ShipmentMethod
sMethodNoshipmentMethod
Invoice
invoiceNodateRalseddatePaidcreditCardNoholdersNameexpiryDateorderNopMethodNo
OrderDetail
orderNoproductNoquantityOrdered
Order
orderNoorderDatebillingStreetbillingCitybillingStatebillingZipCodepromisedDatestatuscustomerNoemployeeNo
pMethodNo=pMethodNo1:n
orderNo = orderNo1:1
productNo=productNo1:n
customerNo=customerNo1:n
Product
productNoProductNameserialNounitPricequantityOnHandreorderLevelrecorderQuantityreorderLeadTime