Data Model Diagram (and Description)


Description:
Customer(1) - User(0..n)
- Each row in Customer may be referred to by 0 or more Users
- Each Customer may have any number of User logins

Customer(1) - Order(0..n)
- Each row in Customer will be referred to by 0 or more Orders
- Each Customer may have 0 or more Orders

Order(1) - LineItem(1..n)
- Each row in Order will be referred to by 1 or more LineItem
- Each Order has one or more LineItems

Order(1) - Shipping(0..n)
- Each row in Order will be referred to by 0 or more Shipping
- Each Order can have any number of Shipping rows

LineItem(1) - Product(1)
- Each row in LineItem will refer to 1 Product
- There is one Product for each LineItem

Product(1) - ServiceDescription(1)
- Each row in Product will correspond to 1 ServiceDescription or nothing

Order(1) - Invoice(0..n)
- Each row in Order will be referred to by 0 or more Invoice
- Each Order can have any number of Invoices

Invoice(1) - Payment(0..n)
- Each row in Invoice will refer be reffered to by 0 or more Payment
- Each Invoice can have any number of Payments