Database Project

profileDigigtalcobra96
Thisishowitshouldlooklike-Example-.xlsx
Home>Information Systems homework help>Database Project

Sheet1

PROJECT 1 EXAMPLE
Parts 1a and 1b
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 Jance May T Telephone 3 320 D 2 Double Beds W Weekend $89
1008 9/24/20 9/26/20 97 Chris Mancha (469)555-3440 I Individual 153 14 John King RC Online Res Center 2 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
Part 1c
RESDETAIL (ResNum, RoomNum, CkIn, CkOut, CustID, CustFName, CustLName, CustPh, CustDesc, LoyaltyID, AgentID, AgentFName, AgentLName, AgentType, AgentDesc, GuestCount, RoomDesc,
RateType, RateDesc, RateAmt )
Part 1d
Part 2a
ROOM (RoomNum, RoomType, RoomDesc)
RESERVATION (ResNum, CheckIn, CheckOut, CustID, CustFName, CustLName, CustPhone, CustType, CustTypeDesc, LoyaltyID, AgentID, AgentFName, AgentLName, AgentyType, AgentDesc, GuestCount, RateType, RateDesc)
RESDETAIL (ResNum, RoomNum, RateAmt)
Part 2b
Part 3a
RESDETAIL (ResNum, RoomNum, RateAmt) RESERVATION (ResNum, CheckIn, CheckOut, CustID, AgentID, GuestCount, RateType)
CUSTOMER (CustID, CustFName, CustLName, CustPhone, CustType, LoyaltyID) CUSTTYPE (CustType, CustTypeDesc)
AGENT (AgentID, AgentFName, AgentLName, AgentType) AGENTTYPE (AgentType, AgentDesc)
ROOM (RoomNum, RoomType) ROOMTYPE (RoomType, RoomDesc) RATETYPE (RateType, RateDesc)
Part 3b
Part 4a
Part 4b

Sheet2

ResNum Check In Check Out Cust ID Agent ID Guest Count Rate Type Rate Type Rate Desc RATETYPE Agent Type Agent Desc AGENTTYPE Cust Type CustType Desc CUSTTYPE Agent ID Agent FName Agent LName Agent Type AGENT Cust ID Cust FName Cust LName Cust Phone Cust Type CUSTOMER RESERVATION ResNum RoomNum Rate Amt RESDETAIL RoomNum Room Type ROOM Room Type Room Desc ROOMTYPE Loyalty ID

ResNumCheckInCheckOutCustIDAgentIDGuestCountRateTypeRateTypeRateDescRATETYPEAgentTypeAgentDescAGENTTYPECustTypeCustTypeDescCUSTTYPEAgentIDAgentFNameAgentLNameAgentTypeAGENTCustIDCustFNameCustLNameCustPhoneCustTypeCUSTOMERRESERVATIONResNumRoomNumRateAmtRESDETAILRoomNumRoomTypeROOMRoomTypeRoomDescROOMTYPELoyaltyID