Which business rules can be associated with the attached ER diagram? (Multi-sele

Question

Which business rules can be associated with the attached ER diagram? (Multi-select)

Question 3 options:

The product information is stored in a PRODUCT entity.

The INVOICE is written for a single CUSTOMER. Each customer can have only one invoice.

An INVOICE is written by a SALESREP.

The product’s vendor information is found in a VENDOR entity.

The product information is stored in a PRODUCT entity.

The INVOICE is written for a single CUSTOMER. Each customer can have only one invoice.

An INVOICE is written by a SALESREP.

The product’s vendor information is found in a VENDOR entity.

CUSTOMER PK CUST NUM CUST LNAME CUST FNAME CUST AREACODE CUST PHONE CUST_E-MAIL CUST SHIP ADDRESS CUST SHIP CITY CUST SHIP STATE CUST ZIP CODE genetates SALESREP INVOICE VENDOR PK INV NUM PK VEND CODE write SLSREP LNAMEIF SLSREP FNAME SLSREPINITIAL SLSREPEMAIL VEND NAME VEND CONTACT VEND EMAIL FK1 CUST NUM FK2 SLSREP NUM INV DATE INV SUBTOTAL INV TAX INV TOTAL - - supplies contains INV_LINE PRODUCT PK,FK1 INV NUM PK INE is written in 4I FK1 VEND coDE PROD CODE INV LINE PRICE INV LINE QUANT INV_LINE TOTAL FK2 PROD DESCRIPTION PROD PRICE PROD QOH

Explanation / Answer

Answer)

The product information is stored in a PRODUCT entity.

An INVOICE is written by a SALESREP.

The product’s vendor information is found in a VENDOR entity

Note :- The second statement is wrong because the relationship between customer and invoice is one to many, And one customer can have many invoices

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.