Question: Create an ERD based on the Crow s Foot notation using the business rules below. Indicate strong and weak relationships on the ERD as well

Create an ERD based on the Crows Foot notation using the business rules below.
Indicate strong and weak relationships on the ERD as well as mandatory or
optional nature of a particular connectivity. Include action verbs connecting the
entities as well as any number of attributes that you believe will allow the model to
be successfully implemented (e.g., codes, names, addresses, phones, descriptions,
prices, etc). Indicate corresponding primary and foreign keys within the entities.
Please submit the final ERD in .pdf format by exporting it from Lucidchart.
Each sales representative may write many invoices, but each invoice is written by a
single sales representative (assume that there are sales representatives who have not
written any invoices yet).
Each sales representative must have only one manager who is also a sales
representative. A manager manages many sales representatives (assume that the
manager must have at least one subordinate to be a manager).
An invoice is written for a single customer. However, each customer may generate
many invoices (assume that customers are in the database even if they have not
generated any invoices yet).
An invoice contains many detailed lines, each of which describes one product bought
by the customer (note that you cannot have an invoice with no lines).
The product information for the invoice lines is stored in the product entity. Each
product can be found in many lines, but each line must have only one product
(assume that there are products, which have not been sold yet).
A product is supplied by many vendors and each vendor may supply many products
(assume that the system keeps all vendors including those who have not supplied
anything yet).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!