Question: Please fill out the table below with the attributes on the bottom of the page and mark with a * each primary key Table name

Please fill out the table below with the attributes on the bottom of the page and mark with a "*" each primary key

Table name

attributes

1.Warehouse,location table table-

*Warehouse area number, product quantity on hand at warehouse area

2.Inventory Table

*Product code, Product standard selling price, product unit measurement,

3. Cash

Events:

Table name

attributes

4.Order

*order number, Order date

5.Sale/

Shipment

*sale number, actual selling price of product code

6.Cash Receipts

Agents

Table name

attributes

7.Customer Table

Customer number

8.Employee

employee code ID

Relationship Table Many to Many relationships

Table name

attributes

9.Warehouse-inventory

*Warehouse area number, *Product code,

10.Inventory -order

11.inventory-sale

12.order-employee

13.sale-employee

*Primary Key

Please use only the following attributes:

Actual quantity of product code sold order selling price of product code

Actual order quantity of product code date of cash receipt

Warehouse description Employee social security number sales date

Product name product description

Remittance number cash account number

Cash receipt amount cash account name

Product standard selling price product standard cost

Customer name customer street

Date order needed Employee last name

Customer check number Customer fax

Customer telephone Employee first name

Customer Account Receivable Balance

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!