Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below are the business rules that define relationships between entities INVOICE, SALESREP, CUSTOMER, PRODUCT, LINE, VENDOR. 1 ) An INVOICE is written by a SALESREP.

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.
INVOICE entity: INV_NUM (PK), INV_SUBTOTAL, INV_TAX, INV_TOTAL
SALESREP entity: SLSREP_NUM (PK), SLSREP_LNAME, SLSREP_FNAME, SLSREP_INITIAL,
SLSREP_EMAIL
CUSTOMER entity: CUST_NUM (PK), CUST_LNAME, CUST_FNAME, CUST_AREACODE,
CUST_PHONE, CUST_EMAIL, CUST_ADDRESS, CUST_CITY, CUST_STATE, CUST_ZIP_CODE
INV_LINE entity: INV_LINE_NUM (PK), INV_LINE_PRICE, INV_LINE_QUANT, INV_LINE_TOTAL
VENDOR entity: VEND_CODE(PK), VEND_NAME, VEND_CONTACT, VEND_EMAIL
PRODUCT entity: PROD_CODE(PK), PROD_PRICE, PROD_DESCRIPTION, PROD_QOH
What are the primary keys and foreign keys for this?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions