information system
INSY 3304 - Project 1
|
Res Num |
Check In |
Check Out |
Cust ID |
Cust Name |
Cust Phone |
Cust Type |
Cust Desc |
Loyalty ID |
Agent ID |
Agent Name |
Agent Type |
Agent Desc |
# of Guests |
Room Num |
Room Type |
Room Desc |
Rate Type |
Rate Desc |
Rate Amt |
|
1001 |
9/5/2019 |
9/7/2019 |
85 |
Wesley Tanner |
(817)555-1193 |
C |
Corporate |
323 |
20 |
Megan Smith |
FD |
Front Desk |
2 |
224 |
K |
King Bed |
C |
Corporate |
$120 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
225 |
D |
2 Double Beds |
C |
Corporate |
$125 |
|
1002 |
9/1/2019 |
9/10/2019 |
100 |
Breanna Rhodes |
(214)555-9191 |
I |
Individual |
129 |
5 |
Janice May |
T |
Telephone |
4 |
305 |
D |
2 Double Beds |
S |
Standard |
$149 |
|
1003 |
9/9/2019 |
9/11/2019 |
15 |
Jeff Miner |
|
I |
Individual |
|
14 |
John King |
RC |
Res Center |
3 |
409 |
D |
2 Double Beds |
W |
Weekend |
$99 |
|
1004 |
9/29/2019 |
9/210/2019 |
77 |
Kim Jackson |
(817)555-4911 |
C |
Corporate |
210 |
28 |
Ray Schultz |
T |
Telephone |
4 |
320 |
D |
2 Double Beds |
C |
Corporate |
$110 |
|
1005 |
9/15/2019 |
9/18/2019 |
119 |
Mary Vaughn |
(817)555-2334 |
I |
Individual |
118 |
20 |
Megan Smith |
FD |
Front Desk |
1 |
302 |
K |
King Bed |
S |
Standard |
$139 |
|
1006 |
9/24/2019 |
9/26/2019 |
97 |
Chris Mancha |
(469)555-3440 |
I |
Individual |
153 |
14 |
John King |
RC |
Res Center |
2 |
501 |
KS |
King Suite |
W |
Weekend |
$119 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
502 |
KS |
King Suite |
W |
Weekend |
$119 |
|
1007 |
9/20/2019 |
9/25/2019 |
100 |
Breanna Rhodes |
(214)555-9191 |
I |
Individual |
129 |
20 |
Megan Smith |
FD |
Front Desk |
2 |
302 |
K |
King Bed |
S |
Standard |
$139 |
|
1008 |
10/210/2019 |
10/3/2019 |
85 |
Wesley Tanner |
(817)555-1193 |
C |
Corporate |
323 |
5 |
Janice May |
T |
Telephone |
3 |
320 |
D |
2 Double Beds |
W |
Weekend |
$89 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
321 |
K |
King Bed |
W |
Weekend |
$99 |
|
1009 |
10/1/2019 |
10/4/2019 |
28 |
Renee Walker |
(214)555-9285 |
I |
Individual |
135 |
14 |
John King |
RC |
Res Center |
2 |
502 |
KS |
King Suite |
W |
Weekend |
$129 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
409 |
D |
2 Double Beds |
S |
Standard |
$129 |
|
1010 |
10/1/2019 |
10/9/2019 |
23 |
Shelby Day |
|
I |
Individual |
|
28 |
Ray Schultz |
T |
Telephone |
4 |
225 |
D |
2 Double Beds |
W |
Weekend |
$109 |