P4_4Chapter4RelationalDatabase.accdb
| CustomerID |
CustomerName |
Street |
City |
State |
| 151 |
Vivian Rodgers |
204 NoContent Street |
Phoenix |
AZ |
| 152 |
Lola Doyle |
504 Gateway Place |
Mesa |
AZ |
| 153 |
Rodney Wern |
500 Serverr Place |
Chandler |
AZ |
| 154 |
John Clark |
200 OK Ave |
Snowflake |
AZ |
| 155 |
Shona Ojeda |
404 NoFound Lane |
Winslow |
AZ |
| ItemID |
Description |
Color |
VendorID |
QuantityOnHand |
ListPrice |
| 1036 |
Refrigerator |
White |
30023 |
12 |
1199.0 |
| 1038 |
Refrigerator |
Black |
30023 |
7 |
1299.0 |
| 1039 |
Refrigerator |
Stainless |
30023 |
5 |
1499.0 |
| 2061 |
Range |
White |
30011 |
6 |
799.0 |
| 2063 |
Range |
Stainless |
30011 |
5 |
999.0 |
| 3541 |
Washer |
White |
30008 |
15 |
499.0 |
| 3544 |
Washer |
Black |
30008 |
10 |
699.0 |
| 3785 |
Dryer |
White |
30019 |
12 |
399.0 |
| 3787 |
Dryer |
Black |
30019 |
8 |
499.0 |
| SalesInvoiceID |
SaleDate |
SalesPerson |
CustomerID |
| 11101 |
2021-10-15 |
C. Sanchez |
151 |
| 11102 |
2021-10-15 |
B. Green |
152 |
| 11103 |
2021-10-28 |
B. Green |
151 |
| 11104 |
2021-10-31 |
C. Sanchez |
153 |
| 11105 |
2021-11-14 |
C. Sanchez |
152 |
| SalesInvoiceID |
ItemID |
Quantity |
SoldPrice |
| 11101 |
1039 |
2 |
1450 |
| 11101 |
2063 |
1 |
950 |
| 11102 |
1036 |
1 |
1199 |
| 11102 |
2061 |
1 |
799 |
| 11102 |
3541 |
2 |
499 |
| 11103 |
1038 |
2 |
1201 |
| 11104 |
1039 |
1 |
1499 |
| 11105 |
2063 |
1 |
999 |
| 11105 |
3544 |
2 |
650 |
| 11105 |
3787 |
2 |
450 |