PPT Slide
Create an E-R model and define its table structures for the following requirements.
- An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.
- The INVOICE is written for a single CUSTOMER. However, each customer may have many invoices.
- An INVOICE may include many detail lines (LINE) which describe the products bought by the customer.
- The product information is stored in a PRODUCT entity.
- The product's vendor information is found in a VENDOR entity.
E-R Modeling & Transformation Exercise