Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions