easy access assignment need help review requirement

ERD Assignments

1.     Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. For each rule below, You may create one ER diagram (total 5 separate ER diagrams).  

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. The INVOICE table has the following fields: invoice_id, invoice_date, and inv_amount. the Salesrep table consists of salesrep_id, salesrep_last_name, salesrep_first_name, and salesrep_email.

b. The INVOICE is writtEsen for a single CUSTOMER. However, each customer can have many invoices. the CUSTOMER table consists of the following attributes: cust_id, cust_lasdt_name, cust_first_name, cust_email and cust_zip_code.

c. An INVOICE can include many detail lines (INV_LINE), which describe the products bought by the customer. The INV_LINE table consists of INV_LINE_NUM,  INV_LINE_PRICE,  INV_LINE_QUANTUTY, AND INV_LINE_TOTAL. 

d. The product information is stored in a PRODUCT table, which consists of PRODUCT_CODE, PRODUCT_DESCRIPTION, PRODUCT_PRICE, and PRODUCT_QUANTITY.

e. The product’s vendor information is found in a VENDOR table, which consists of VENDOR_ID, VENDOR_NAME, VENDOR_PHONE, and VENDOR_EMAIL.  VENDOR supplies PRODUCT. 

 

Grading criteria:

1. identify primary key (PK) and foreign keys (FKs) 
2. identify strong relations and weak relations among entities and use proper lines, either dashed or solid lines. 
3. write all appropriate connectivities and cardinalities in the ERD.

Deliverables: ERD

ERD can be drawn using Microsoft Visio. If you have this software and know how to use it, you may use Visio. If not, manually draw the ERD and scan it as a JPG or PDF file. Upload the scanned ERD to the dropbox.