Go back to

ntityelationshipiagram

for MC's Distributors Ltd.

Explanation of the Entity Relationship Diagram

Each CUSTOMER places zero or more ORDER (S) ; each ORDER is placed by one CUSTOMER .

Each ORDER sells as one or more ORDERED ITEM (S) ; each ORDERED ITEM is contained in the ORDER .

Each ORDERED ITEM is sold as one or more STOCK (S) ; each ORDERED ITEM is contained in the STOCK .

Each STOCK is featured to have zero or more PROMOTION TITLE (S) ; each PROMOTION TITLE is featured to only one STOCK .

Each PROMOTION features one or more PROMOTION TITLE (S) ; each PROMOTION TITLE is referenced in one PROMOTION .

Each CUSTOMER may generate one or more INVOICE (S) ; each INVOICE is generated by one CUSOMTER .

Each INVOICE may contain one or more INVOICE LINE (S) ; each INVOICE LINE is contained in one invoice .

Each INVOICE LINE references one STOCK ; each STOCK may be referenced in one or more INVOICE LINE (S).

Each SALE contains one or more INVOICE LINE (S) ; each INVOICE LINE is contained in one SALE.

Each EMPLOYEE performs one or more SALE (S) ; each SALE is performed by only one EMPLOYEE .

Each SUPPLIER is involved in more than one STOCK (S) SUPPLIED ; each STOCK SUPPLIED involves one SUPPLIER .

Each STOCK SUPPLIED references more than one STOCK (S) ; each STOCK references to one STOCK SUPPLIED.