Database Management
Ama85
order2016.accdb| CID | Name | Address | City | State | Zip | Category |
|---|---|---|---|---|---|---|
| 1 | Celine Dion | 143 Canada Way | Boston | MA | 62302 | FLO |
| 2 | Warren Hill | 324 East 7th | Boston | MA | 62301 | GOV |
| 3 | Leon Redbone | 2934 Simon Dr. | Springfield | IL | 12364 | FLO |
| 4 | Stephen C. Chapman | 12 Oakwood Suite 234 | Boston | MA | 62310 | GOV |
| 5 | Marvin Matthews | 234 Sandy Ln # 128 | Springfield | IL | 12354 | WALK |
| 6 | Jim Brickman | 787 Sureway | Boston | MA | 62320 | WALK |
| 7 | Ray Boltz | 333 Ziptree | Boston | MA | 62301 | WALK |
| 8 | Charlie Peacock | 23 Paris Ln | Ft. Worth | TX | 76132 | FLO |
| EID | Name | Address | City | State | Zip | Phone | Specialty | ManagerID |
|---|---|---|---|---|---|---|---|---|
| 1 | Kaethe Oswald | PO Box 23239 | Boston | MA | 62345 | 5555552390 | I | |
| 2 | Joan Switcher | PO Box 30202 | Springfield | IL | 12334 | 5555552111 | J | |
| 3 | Katie Hayes | PO Box 390, Boston, MA, 23923 | Boston | MA | 62344 | 5555552310 | K | |
| 4 | Smitty Clark | PO Box 302, Springfield, IL, 23940 | Springfield | IL | 12344 | 5555552321 | L | |
| 10 | John Samual | PO Box 1243, Boston, MA 75234 | Boston | MA | 62388 | 5555551223 | A | 1 |
| 11 | Susan Smith | PO Box 434, Boston, MA 12345 | Springfield | IL | 12355 | 5555552354 | B | 1 |
| 12 | Carla Jones | PO Box 11, Springfield, IL, 12323 | Springfield | IL | 12345 | 5555551231 | C | 2 |
| 13 | Kevin Alexander | PO Box 10340, Springfield, IL, 12433 | Springfield | IL | 12344 | 5555559993 | D | 2 |
| 14 | Samantha Technick | PO Box 123, Boston, MA, 23423 | Boston | MA | 62311 | 5555551303 | E | 3 |
| 15 | Louise King | PO Box 2340, Boston, MA, 20304 | Boston | MA | 62321 | 5555559394 | F | 3 |
| 16 | Joe Chicken | PO Box 239403, Boston, MA, 23203 | Boston | MA | 62332 | 5555552930 | G | 4 |
| 17 | Diana Gonzales | PO Box 4930293, Boston, TX 73849 | Boston | MA | 62312 | 5555552233 | H | 4 |
| ItemID | Description | ListPrice | Cost | QuantityOnHand | Category |
|---|---|---|---|---|---|
| 1223 | Dog Food | 1.75 | 1.25 | 3 | DOG |
| 1224 | Dog Brush | 3.75 | 2.75 | 20 | DOG |
| 1225 | Dog Toothbrush | 4.1 | 3.5 | 2 | DOG |
| 1300 | Cat Food | 1.5 | 0.5 | 2 | CAT |
| 1302 | Cat Toy | 3.75 | 2.75 | 25 | CAT |
| 1502 | Spade | 4.5 | 3.75 | 15 | GAR |
| 1504 | Rake | 5.99 | 4.8 | 10 | GAR |
| 3445 | Hammer | 3.0 | 2.5 | 23 | TOOL |
| 3446 | Hammer | 4.25 | 3.75 | 15 | TOOL |
| 8766 | Wrench | 4.75 | 4.1 | 18 | TOOL |
| 8776 | Wrench | 5.5 | 4.75 | 12 | TOOL |
| 9765 | Archway | 275.0 | 216.0 | 2 | FLO |
| Category | Description | StoreLocation | Season | ManagerID |
|---|---|---|---|---|
| CAT | Cat Item | 123 | SPRING | 1 |
| DOG | Dog Item | 342 | SPRING | 2 |
| FLO | Florist Supplies | 234 | SPRING | 3 |
| GAR | Garden Items | 351 | SUMMER | 4 |
| TOOL | Tools | 351 | SUMMER | 4 |
| OrderID | OrderDate | CID | EID |
|---|---|---|---|
| 12200 | 1/15/16 | 8 | 10 |
| 12305 | 2/14/16 | 6 | 12 |
| 12306 | 2/23/15 | 7 | 16 |
| 12456 | 3/1/16 | 1 | 12 |
| 12457 | 3/7/15 | 1 | 17 |
| 12458 | 3/12/16 | 8 | 12 |
| 12459 | 6/2/15 | 2 | 11 |
| 12470 | 6/12/15 | 6 | 13 |
| 12471 | 6/17/14 | 5 | 13 |
| 12472 | 6/20/14 | 4 | 17 |
| 12480 | 6/28/14 | 3 | 11 |
| 12500 | 7/15/14 | 1 | 14 |
| 12501 | 7/15/14 | 4 | 15 |
| 12502 | 11/15/14 | 6 | 17 |
| 12503 | 11/23/15 | 5 | 11 |
| 12504 | 12/3/15 | 3 | 10 |
| 12602 | 12/30/14 | 1 | 15 |
| 12948 | 12/30/14 | 3 | 16 |
| OrderID | ItemID | Quantity | SalePrice |
|---|---|---|---|
| 12200 | 1223 | 11 | 1.75 |
| 12305 | 1224 | 1 | 3.75 |
| 12306 | 1504 | 2 | 6.0 |
| 12456 | 1300 | 1 | 1.0 |
| 12457 | 8776 | 1 | 5.0 |
| 12458 | 1223 | 2 | 2.0 |
| 12459 | 1300 | 2 | 1.0 |
| 12470 | 1224 | 2 | 3.75 |
| 12470 | 1225 | 1 | 4.1 |
| 12471 | 1224 | 1 | 3.5 |
| 12500 | 1224 | 2 | 4.0 |
| 12500 | 8776 | 3 | 5.0 |
| 12501 | 1223 | 3 | 2.0 |
| 12502 | 1224 | 2 | 2.0 |
| 12502 | 3445 | 1 | 2.8 |
| 12503 | 1300 | 1 | 1.0 |
| 12504 | 8776 | 1 | 5.0 |
| 12602 | 9765 | 1 | 270.0 |
| 12948 | 1223 | 10 | 1.75 |
| 12948 | 1224 | 1 | 3.5 |
