ITM Assignment

rakan2019
hotelspring181.accdb
Home>Information Systems homework help>ITM Assignment
hotelNo guestNo dateFrom dateTo roomNo ratebooked
1 1 2/28/15 3/1/15 101 90
1 2 3/5/15 3/7/15 206 100
1 2 3/10/15 3/15/15 206 100
1 2 3/4/16 3/6/16 206 120
1 2 3/9/16 3/14/16 206 110
1 5 2/1/15 2/2/15 200 110
1 6 2/4/15 2/6/15 500 100
1 7 2/3/15 2/8/15 206 85
1 7 4/1/15 4/4/15 212 160
1 8 2/1/15 2/7/15 200 175
1 9 2/1/15 2/6/15 101 75
2 3 3/22/16 3/25/16 410 200
2 4 2/6/15 2/10/15 411 180
2 8 4/1/16 4/4/16 200 160
2 8 4/15/16 4/18/16 200 150
2 9 2/5/15 2/6/15 412 175
3 1 3/13/16 3/15/16 212 80
3 3 1/31/14 2/4/14 308 100
3 3 3/26/16 3/31/16 210 130
3 4 3/11/16 3/15/16 214 160
3 7 2/3/15 2/4/15 212 90
3 7 2/5/15 2/8/15 308 135
4 9 4/15/16 4/18/16 321 190
4 10 3/12/14 3/13/14 312 220
4 10 2/22/15 2/24/15 312 200
5 2 5/18/15 5/23/15 219 115
5 11 5/11/14 5/12/14 308 140
5 13 5/12/14 5/13/14 421 130
6 9 8/3/16 8/4/16 401 72
6 10 8/9/14 8/10/14 222 84
6 10 9/8/15 9/15/15 401 100
6 11 5/31/14 6/4/14 222 91
6 12 7/3/16 7/5/16 222 88
guestNo guestFirst guestStreet guestCity guestState guestPhone guestEmail guestLast
1 Robert 123 main Boise ID 2085641456 rcroft@yahoo.com Croft
2 Howard 234 main Tulsa OK 4057441144 hsmith@gmail.com Smith
3 Mike 345 main Hays KS 7856245511 mrose@yahoo.com Rose
4 Matt 234 main Monroe LA 3185978417 matt4432@yahoo.com Smith
5 Jennifer 2526 Chatham Way Stillwater OK 4057775413 brattonj@outlook.com Bratton
6 Bryan 35 West Liberty Meridian ID 2085553262 bryanhedrick@gmail.com Hedrick
7 Raj 145 E. Highland Fargo ND 2105557487 rajrama@outlook.com Ramanathan
8 Marie 35 N. Perkins Road Kansas City KS 9137325541 marie23james@outlook.com James
9 Tony 2545 Brighton Lane Shreveport LA 3182674419 tony.chang@centurylink.com Chang
10 John 345 Apple St Boise ID 2086624517 john.jones@cableone.net Jones
11 Jason 1123 15th Street Stillwater OK 4052385959 jasonwokstate@suddenlink.net Williamson
12 Martin 3478 Trenton St. Ruston LA 3182339084 martinj@gmail.com Johnson
13 Susan 1211 West Oak Oklahoma City OK 4053321167 susanellis@outlook.com Ellis
hotelNo hotelName hotelCity hotelPhone
1 Holiday Inn Tulsa 4057415555
2 Hampton Inn Stillwater 4058749963
3 Atherton Stillwater 4053654412
4 Marriott-OKC Oklahoma City 4057748514
5 Marriott-Tulsa Tulsa 4057145562
6 Hyatt Oklahoma City 4057325412
roomNo hotelNo type standardprice
101 1 single 90
123 6 double 125
200 1 double 120
200 2 double 160
206 1 double 120
210 3 double 150
210 6 single 100
212 1 family 160
212 3 single 100
212 4 single 200
214 3 double 160
219 5 single 130
222 6 single 100
308 3 single 100
308 5 double 160
312 4 single 200
315 4 double 225
321 4 single 190
333 1 single 95
401 6 single 100
410 2 family 175
411 2 family 180
412 2 family 175
421 5 single 130
500 1 single 100
521 5 single 130
999 1 family 160