Lab 4
- Computer Science Department
 Objective
Given the following business rules, create an ERD to express the following scenario.
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 can include many detail lines (PRODUCT), each of which describes one product bought by the customer.
For this lab, you will need to create the ERD diagram with attributes appropriate for each table/entity. Just to let you know, you will need to create additional tables to resolve the relationships.
Use Lucid Charts (or Miro, Visio) to complete your ERD and upload a screenshot of your resulting diagram.
It is your choice to determine some attributes that would likely be found in the tables. Be sure to use good naming conventions on your tables and attributes.
Â
 Requirements
Requirement | Notes |
|---|---|
Entities/attributes defined. | Consider using a good naming convention. |
Relationships are defined and resolved. | Diagram indicates primary and foreign keys appropriately |
Design | The diagram is well-designed and understandable |
Â
Â