Please fill out the table below with the attributes on the bottom of the page an
ID: 3852326 • Letter: P
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
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
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
Explanation / Answer
Solution :-
1.Warehouse,location table table-
*Warehouse area number, product quantity on hand at warehouse area,Warehouse description
2.Inventory Table
*Product code, Product standard selling price, product unit measurement,
3)Cash - *cash account number ,cash account name
4.Order
*order number, Order date,Actual order quantity of product code
5.Sale/
Shipment
*sale number, actual selling price of product code, sales date
6).Cash Receipts - *Remittance number , cash account number , Cash receipt amount , date of cash receipt
7.Customer Table
*Customer number,Customer name ,customer street,Customer check number , Customer fax,Customer telephone
8.Employee
*employee code ID,Employee first name,Employee social security number
9.Warehouse-inventory
*Warehouse area number, *Product code,
10.Inventory -order
*Product code,order number
11.inventory-sale
*Product code, sale number,
12.order-employee
*order number , employee code ID
13.sale-employee *sale number, employee code ID
1.Warehouse,location table table-
*Warehouse area number, product quantity on hand at warehouse area,Warehouse description
2.Inventory Table
*Product code, Product standard selling price, product unit measurement,