Lyles 4) Draw an ERD that satisfies the following business rules (note composite entities, weak entities, strong and weak relationships, and cardinalities). a. An INVOICE is written by a SALESREP....

Information system course


Extracted text: Lyles 4) Draw an ERD that satisfies the following business rules (note composite entities, weak entities, strong and weak relationships, and cardinalities). a. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. b. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. c. An INVOICE may include many detail lines (LINE) which describe the PRODUCTS bought by the customer. d. An invoice LINE references one PRODUCT, and a PRODUCT may be referenced in one or more invoice LINES. States) Focus