Database

Math Guruu
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