Database Expert Needed

Customer Table Inventory Table Orders Table

Database

Mail Order Database

M

Invoice

M

M

1

orders

has

Inventory

Customer

Invoice Table

inv_number�

cust_id�

inv_date�

inv_status�

�

1�

1237�

1/10/2011�

Open�

�

2�

1439�

3/2/2011�

Paid in Full�

�

3�

1509�

12/12/2010�

Paid in Full�

�

4�

1987�

5/8/2010�

Paid in Full�

�

5�

2908�

1/10/2011�

Open�

�

6�

3451�

1/2/2011�

Paid in Full�

�

7�

6745�

8/12/2010�

Open�

�

8�

8967�

6/1/2011�

Paid in Full�

�

9�

9780�

1/10/2010�

Open�

�

10�

1237�

12/2/2010�

Paid in Full�

�

11�

1987�

3/7/2011�

Open�

�

12�

1439�

4/3/2011�

Paid in Full�

�

13�

1509�

3/1/2010�

Open�

�

14�

1987�

5/4/2011�

Paid in Full�

�

15�

3451�

3/2/2010�

Open�

�

inv_number�

item_number�

�

1�

A098678�

�

1�

A554361�

�

2�

A986512�

�

3�

B986797�

�

4�

A776543�

�

4�

A986513�

�

4�

B999887�

�

5�

B986796�

�

5�

B999887�

�

5�

B999888�

�

6�

A098678�

�

6�

A776543�

�

7�

A458730�

�

7�

B986797�

�

8�

A986512�

�

8�

B986797�

�

8�

B999887�

�

9�

A098678�

�

10�

A098678�

�

10�

B986797�

�

11�

A986513�

�

11�

B986543�

�

12�

A098678�

�

12�

A564348�

�

13�

A776543�

�

13�

B895743�

�

14�

A098678�

�

14�

A564348�

�

15�

B573257�

�

15�

B956321�

�

item_number�

item_name�

item_price�

�

A098678�

Sasaki Bowel�

$125.00�

�

A458730�

Noritake Blue Vase�

$49.99�

�

A554361�

Royal Doulton tea set�

$500.00�

�

A564348�

Mikasa glass set�

$569.00�

�

A776543�

Noritake glass set�

$345.00�

�

A985441�

Mikasa Clock�

$225.00�

�

A986512�

Sasaki Picture Frame 8"�

$20.00�

�

A986513�

Sasaki Picture Frame 10"�

$25.00�

�

A987654�

Royal Doulton Apple�

$29.00�

�

A998776�

Silk House Plant�

$50.00�

�

B124245�

Garden tools�

$45.00�

�

B345987�

Grandfather Clock�

$1,399.99�

�

B573257�

China flower pot set�

$99.99�

�

B895743�

Garden Bench�

$269.99�

�

B956321�

Spring door wreath�

$35.00�

�

B986543�

Dried Roses in vase�

$89.00�

�

B986796�

Silk house plant 4"�

$30.00�

�

B986797�

Silk house plant 6"�

$40.00�

�

B999887�

8" chrome shelf Unit�

$350.00�

�

B999888�

6" chrome shelf Unit�

$299.00�

�

cust_id�

clname�

cfname�

street�

city�

state�

zip�

�

1237�

Smith�

Greg�

101 Third Street�

Uniontown�

PA�

15401-0000�

�

1439�

Atkins�

John�

14 Jenkins Avenue�

Morgantown�

WV�

14092-0000�

�

1509�

Brown�

Grodon�

519 Hilling Drive�

Cleveland�

OH�

14356-0000�

�

1987�

Ashcroft�

Andrew�

75 Piller Drive�

Pittsburgh�

PA�

15231-0000�

�

2908�

Redding�

Chris�

98 Victory Lane�

Brownsville�

PA�

15423-0000�

�

3451�

Jones�

Thomas�

65 Main Street�

Boston�

MA�

15601-0000�

�

5521�

Murray�

Geroge�

1255 West 42nd �

New York�

NY�

14896-0000�

�

6745�

Green�

Julia�

15 Belmount Circle�

Chicago�

IL�

28676-0000�

�

8967�

Johnson�

Kevin�

55 Murray Avenue�

Pittsburgh�

PA�

15211-0000�

�

9780�

Livengston�

Mary�

1 Trimont Lane�

Pittsburgh�

PA�

15235-0000�

�