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