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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started