Computer Info systems

inwoodchck
a03Hotel22.accdb
Home>Computer Science homework help>Computer Info systems
ChargeDetailsID Purchase RoomChargeID
1 13
2 10
3 12
4 11
5 6
6 1
7 3
8 4
9 5
10 8
11 9
12 7
13 2
14 14
15 17
16 15
17 16
18 20
19 22
20 23
21 21
22 18
23 19
GuestID GuestLastName GuestFirstName GuestMI Gender Address City State ZipCode Phone
1 Wenner Susan E F 982 Red Rose Avenue Las Vegas NV 89044 (702) 555-6627
2 Ellis Iona T M 5059 Eleifend Road Lebanon OK 83587 (391) 555-7647
3 Mcconnell Kiona C F 5884 Sed Avenue Fontana CA 65735 (560) 555-2542
4 Foley Elaine U F 2958 Euismod Street Louisville WA 95007 (764) 555-7221
5 Mccall Kyra N F 7191 Odio Avenue Portland MI 97794 (745) 555-3525
6 Kirk Aidan P M 8975 E Street Jeannette DC 78621 (698) 555-9020
7 English Lois L F 8937 Tempor Street Valdosta PA 26645 (531) 555-6230
8 Rojas Colorado A M 8778 Seed Street Wahoo RI 56929 (295) 555-9673
9 Kidd Graiden L M 5547 Mattis Road Lake Charles IN 11891 (450) 555-5080
10 Brock Sheila Q F 8712 Mauris Street Bethany NY 01731 (959) 555-3798
11 Adams Kirk V M 4262 Accumsan Road Stockton WI 08761 (889) 555-8964
12 Finch Adrian C M 8201 Taciti Avenue Cary MN 88785 (873) 555-3753
13 Mcmahon Farrah E F 577 Amet Avenue Stillwater CT 69418 (305) 555-9987
14 Cochran Cassandra K F 8563 Vivamus Road Hutchinson SD 68371 (175) 555-1017
15 Hays Aileen P F 3819 Nonummy Avenue Mark's Point NE 55793 (352) 555-5197
16 Myers Tate S M 300 Scelerisque Street East St. Louis KY 17166 (723) 555-2815
17 Cote Paula N F 3218 Phasellus Road Brockton CA 21169 (330) 555-1346
18 Wong Marshall J M 9574 Sodales Street The Dalles LA 96405 (717) 555-6195
19 Woodward Adrian V M 665 Cras Avenue Concord CA 80273 (670) 555-7930
20 Bridges Hall L M 2971 Ornare Street Citrus Heights OH 07110 (113) 555-6694
21 Elliott Martin H M 3169 Natoque Avenue Shreveport IA 15785 (857) 555-1967
22 Sharp Emi G M 1783 Semper Avenue Fernley AK 33569 (616) 555-0546
23 Gould Malcolm K M 7817 Elementum Road Commerce AK 62769 (104) 555-8666
24 Bennett Maryam R M 9058 Dolor Street Marquette MT 83597 (214) 555-8618
25 YourName YourName 2662 Paige Circle Pittsburgh PA 15237 (412) 555-1669
PmtID GuestID ReservationID PmtAmount PmtDate PmtMethod AuthNumber
1 24 5 ¤ 1,229.00 1/2/18 22597
2 17 6 ¤ 168.30 1/1/18
3 18 7 ¤ 483.23 1/3/18 877456
4 20 8 ¤ 346.50 1/1/18
5 12 10 ¤ 31.19 2/15/18
6 22 11 ¤ 395.80 2/14/18 01123
7 19 12 ¤ 391.31 2/28/18 08556
8 13 14 ¤ 137.62 4/2/18 22113
9 1 16 ¤ 807.49 4/10/18 88945
10 25 17 ¤ 1,682.71 7/6/18 612876
ReservationID GuestID RSVPDate CheckInDate NightsStay NumberOfGuests Crib Handicapped RoomType RoomRate DiscountType
1 14 8/16/20 6/21/21 3 2 false false ¤ 289.00 AAA
2 21 4/3/20 11/9/21 2 3 true false ¤ 376.00 None
3 6 6/12/20 12/1/21 3 4 false false ¤ 492.00 Military
4 23 8/29/20 12/20/21 6 2 false false ¤ 289.00 None
5 24 1/1/20 12/29/21 3 2 false false ¤ 289.00 None
6 17 2/25/20 12/30/21 1 2 false false ¤ 269.00 None
7 18 3/13/20 12/28/21 5 2 false false ¤ 269.00 AAA
8 20 2/27/20 12/29/21 2 2 false false ¤ 289.00 None
9 24 10/12/19 1/13/21 3 3 true false ¤ 349.00 None
10 12 3/8/20 2/11/21 3 2 false false ¤ 289.00 None
11 22 6/14/20 2/12/21 1 2 false false ¤ 289.00 None
12 19 1/11/20 2/24/21 3 2 false false ¤ 289.00 AARP
13 5 9/10/20 3/17/21 2 4 false false ¤ 1,175.00 None
14 13 4/8/20 3/31/21 1 2 false false ¤ 289.00 None
15 22 9/30/19 4/1/21 2 3 false false ¤ 349.00 None
16 1 11/2/19 4/7/21 2 2 false true ¤ 289.00 AARP
17 25 2/17/20 7/2/21 3 2 false false ¤ 1,175.00 None
18 19 5/8/20 3/4/21 3 2 false false ¤ 289.00 AAA
19 20 4/23/20 1/26/21 3 2 false false ¤ 289.00 AAA
20 7 6/16/20 4/7/21 2 3 true false ¤ 376.00 None
21 4 9/10/19 5/11/21 3 4 false false ¤ 492.00 Military
22 9 9/25/20 5/27/21 6 2 false false ¤ 289.00 None
23 6 10/8/20 5/27/21 3 2 false false ¤ 289.00 None
24 17 6/15/20 6/14/21 1 2 false false ¤ 269.00 None
25 3 7/24/20 6/29/21 5 2 false false ¤ 269.00 AAA
26 11 3/12/20 6/30/21 2 2 false false ¤ 289.00 None
27 15 9/30/20 7/2/21 3 3 true false ¤ 349.00 None
28 12 12/16/19 8/8/21 3 2 false false ¤ 289.00 None
29 23 6/25/20 8/6/21 1 2 false false ¤ 289.00 None
30 18 4/11/20 8/17/21 3 2 false false ¤ 289.00 AARP
31 1 9/28/19 9/2/21 2 4 false false ¤ 1,175.00 None
32 25 9/21/19 9/3/21 1 2 false false ¤ 289.00 None
33 14 10/9/20 9/3/21 2 3 false false ¤ 349.00 None
34 11 10/7/20 10/2/21 2 2 false true ¤ 289.00 AARP
35 22 3/13/20 11/19/21 5 5 false false ¤ 1,175.00 None
36 14 9/24/20 7/25/21 3 2 false false ¤ 289.00 AAA
37 21 11/27/20 1/9/21 2 3 true false ¤ 376.00 None
38 6 8/28/20 11/1/21 3 4 false false ¤ 492.00 Military
39 23 4/9/20 2/13/21 6 2 false false ¤ 289.00 None
40 24 8/31/19 2/19/21 3 2 false false ¤ 289.00 None
41 17 4/4/20 1/31/21 1 2 false false ¤ 269.00 None
42 18 8/31/19 10/23/21 5 2 false false ¤ 269.00 AAA
43 20 2/13/20 11/29/21 2 2 false false ¤ 289.00 None
44 24 12/10/20 4/13/21 3 3 true false ¤ 349.00 None
45 12 5/24/20 6/11/21 3 2 false false ¤ 289.00 None
46 22 8/20/20 6/12/21 1 2 false false ¤ 289.00 None
47 19 5/16/20 7/24/21 3 2 false false ¤ 289.00 AARP
48 5 2/22/20 8/17/21 2 4 false false ¤ 1,175.00 None
49 13 11/24/20 8/31/21 1 2 false false ¤ 289.00 None
50 22 2/1/20 10/1/21 2 3 false false ¤ 349.00 None
RoomChargeID GuestID ReservationID ChargeCategory ChargeAmount
1 13 14 Terra Cotta Brew ¤ 137.62
2 22 11 Red Bluff Golf Club ¤ 175.00
3 17 6 Indigo5 ¤ 168.30
4 18 7 Room Service ¤ 58.23
5 18 7 Turquoise Oasis Spa ¤ 425.00
6 12 10 Room Service ¤ 31.19
7 22 11 Painted Treasures ¤ 126.50
8 19 12 Painted Treasures ¤ 82.20
9 19 12 Silver Moon Lounge ¤ 309.11
10 1 16 Red Bluff Golf Club ¤ 250.00
11 1 16 Turquoise Oasis Spa ¤ 325.00
12 1 16 Room Service ¤ 45.75
13 1 16 Painted Treasures ¤ 186.74
14 22 11 Silver Moon Lounge ¤ 94.30
15 24 5 Red Bluff Golf Club ¤ 200.00
16 24 5 Turquoise Oasis Spa ¤ 1,029.00
17 20 8 Turquoise Oasis Spa ¤ 346.50
18 25 17 Silver Moon Lounge ¤ 89.90
19 25 17 Turquoise Oasis Spa ¤ 228.50
20 25 17 Indigo5 ¤ 297.78
21 25 17 Room Service ¤ 71.20
22 25 17 Painted Treasures ¤ 323.23
23 25 17 Red Bluff Golf Club ¤ 672.10