Reference no: EM13756965
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.