programming

profileRd15
3304_Proj1Example_fl2022.xlsx
Home>Computer Science homework help>programming

Sheet1

1a & 1b.
RESDETAIL
Res Num Check In Check Out Cust ID CustFName CustLName Cust Phone Cust Type Cust Desc Loyalty ID Agent ID AgentFName AgentLName Agent Type Agent Desc Guest Count Room Num Room Type Room Desc Rate Type Rate Desc Rate Amt
1001 9/5/20 9/7/20 85 Wesley Tanner (817)555-1193 C Corporate 323 20 Megan Smith FD Front Desk 2 224 K King Bed C Corporate $120
1001 9/5/20 9/7/20 85 Wesley Tanner (817)555-1193 C Corporate 323 20 Megan Smith FD Front Desk 2 225 D 2 Double Beds C Corporate $125
1002 9/1/20 9/10/20 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/20 9/11/20 15 Jeff Miner I Individual 14 John King RC Online Res Center 3 409 D 2 Double Beds W Weekend $99
1004 9/12/20 9/14/20 77 Kim Jackson (817)555-4911 C Corporate 210 28 Ray Schultz T Telephone 4 320 D 2 Double Beds C Corporate $110
1004 9/12/20 9/14/20 77 Kim Jackson (817)555-4911 C Corporate 210 28 Ray Schultz T Telephone 4 409 D 2 Double Beds C Corporate $105
1004 9/12/20 9/14/20 77 Kim Jackson (817)555-4911 C Corporate 210 28 Ray Schultz T Telephone 4 321 K King Bed C Corporate $112
1005 9/15/20 9/18/20 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/20 9/26/20 97 Chris Mancha (469)555-3440 I Individual 153 14 John King RC Online Res Center 2 501 KS King Suite W Weekend $119
1006 9/24/20 9/26/20 97 Chris Mancha (469)555-3440 I Individual 153 14 John King RC Online Res Center 2 502 KS King Suite W Weekend $119
1007 9/20/20 9/25/20 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/1/20 10/3/20 85 Wesley Tanner (817)555-1193 C Corporate 323 5 Janice May T Telephone 3 320 D 2 Double Beds W Weekend $89
1008 10/1/20 10/3/20 85 Wesley Tanner (817)555-1193 C Corporate 323 5 Janice May T Telephone 3 321 K King Bed W Weekend $99
1009 10/1/20 10/4/20 28 Renee Walker (214)555-9285 I Individual 135 14 John King RC Online Res Center 2 502 KS King Suite W Weekend $129
1009 10/1/20 10/4/20 28 Renee Walker (214)555-9285 I Individual 135 14 John King RC Online Res Center 2 409 D 2 Double Beds W Weekend $129
1010 10/1/20 10/9/20 23 Shelby Day I Individual 28 Ray Schultz T Telephone 4 225 D 2 Double Beds W Weekend $109
1c. RESDETAIL (ResNum, RoomNum, CheckIn, CheckOut, CustID, CustFName, CustLName, CustPh, CustType, LoyaltyID, AgentID, AgentFName, AgentLName, AgentDesc,
GuestCt, RoomType, RoomDesc, RateType, RateDesc, RateAmt)
1d. Dependency Diagram for 1NF
2a. Table Structure Format for 2NF
RESDETAIL (ResNum, RoomNum, RateAmt)
ROOM (RoomNum, RoomType, RoomDesc)
RESERVATION (ResNum, CheckIn, CheckOut, CustID, CustFName, CustLName, CustPh, CustType, LoyaltyID, AgentID, AgentFName, AgentLName, AgentDesc, GuestCt, RateType, RateDesc)
2b. Dependency Diagrams
3a. Table Structure Format for 3NF
RESDETAIL (ResNum, RoomNum, RateAmt)
ROOM (RoomNum, RoomType)
ROOMTYPE (RoomType, RoomDesc)
RESERVATION (ResNum, CheckIn, CheckOut, CustID, AgentID, GuestCt, RateType)
CUSTOMER (CustID, CustFName, CustLName, CustPh, LoyaltyID)
CUSTTYPE (CustType, CustTypeDesc)
AGENT (AgentID, AgentFName, AgentLName, AgentType)
AGENTTYPE (AgentType, AgentDesc)
RATETYPE (RateType, RateDesc)
3b. Dependency Diagrams for 3NF
4. Relational Schema
4b. ERD

Sheet2

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png