Question: Create an ERD based on the Crow s Foot model, using the following requirements: ( 2 7 pts ) Below are the business rules that

Create an ERD based on the Crows Foot model, using the following requirements: (27
pts)
Below are the business rules that define relationships between entities INVOICE, SALESREP,
CUSTOMER, PRODUCT, LINE, VENDOR.
1) An INVOICE is written by a SALESREP.
Each sales representative (SALESREP) can write many invoices, but each invoice is
written by a single sales representative (SALESREP).
2) Each INVOICE is written for a single CUSTOMER. However, each CUSTOMER can have
many invoices.
3) An INVOICE can include many detail lines (LINE). Each invoice line item can only
contain one and only one INVOICE
4) Each PRODUCT can include many detail lines (LINE). Each invoice line item can
only contain one and only one PRODUCT
5) A VENDOR may supply zero or more products, but a PRODUCT may be supplied by one
and only one VENDOR.
6) The product information is stored in a PRODUCT entity.
7) The products vendor information is found in a VENDOR entity

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 Databases Questions!