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
Get step-by-step solutions from verified subject matter experts
