| Customer |
| CustomerID |
FName |
LName |
Street |
City |
State |
Zip |
| 1 |
Buck |
Woody |
123 3rd Ave. |
Tampa |
FL |
12345 |
| Product |
| ProductID |
Type |
Description |
|
|
|
|
| 1 |
Shoes |
Sneakers |
|
|
|
|
| 2 |
Shirt |
Polo |
|
|
|
|
| 3 |
Hat |
Baseball |
|
|
|
|
| Store |
| StoreID |
Location |
Manager |
|
|
|
|
| 1 |
Tampa |
Marjorie Kay |
|
|
|
|
| Sale |
| SaleID |
CustomerID |
Date |
|
|
|
|
| 1 |
1 |
07/04/2004 |
|
|
|
|
| SaleProduct |
| SaleID |
ProductID |
|
|
|
|
|
| 1 |
1 |
|
|
|
|
|
| 1 |
2 |
|
|
|
|
|
|
|