DBMS ASSIGNMENT-1 (CSE--A)

                     

                                                      ASSIGNMENT-1

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 can 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. Create an Entity Relational Diagram, using the above requirements.

             LAST DATE FOR SUBMISSION -- 29 DECEMBER 2011