Java Reference
In-Depth Information
Table 9-1: Customer Table
Customer_Numb
er
First_Nam
e
M
I
Last_Nam
e
Street
City
Stat
e
Zip
Main
York
7
102
Sonny
A
Corleone
123
Walnut
Newark
NJ
1234
6
103
Francis
X
Corleone
17
Main
New
York
NY
1000
5
104
Vito
G
Corleone
23 Oak
St
Newark
NJ
1234
5
105
Tom
B
Hagen
37
Chestn
ut
Newark
NJ
1234
5
106
Kay
K
Adams
109
Maple
Newark
NJ
1234
5
107
Francis
F
Coppola
123
Sunset
Hollywoo
d
CA
2345
6
108
Mario
S
Puzo
124
Vine
Hollywoo
d
CA
2345
6
Table 9-2: Inventory Table
Item_Number
Name
Description
Qty
Cost
1001
Corn Flakes
Cereal
130
1.95
1002
Rice Krispies
Cereal
97
1.87
1003
Shredded Wheat
Cereal
103
2.05
1004
Oatmeal
Cereal
15
0.98
1005
Chocolate Chip
Cookies
217
1.26
1006
Fig Bar
Cookies
162
1.57
1007
Sugar Cookies
Cookies
276
1.03
1008
Cola
Soda
144
0.61
1009
Lemon Soda
Soda
96
0.57
1010
Orange Soda
Soda
84
0.71
In addition to the Customers table and the Inventory table you need a table that lists the orders by
order number, using one record per order, and containing the customer number of the customer
