**You have to zoom in to see Image**
This Question is from my Information Systems class (database management systems)
Please help create a dependency diagram for the table below in 1st normal form. ResNum and RoomNum are the Primary Keys. Please provide arrows for Partial dependency and Transitive Dependency.
RESERVATIONDETAIL (ResNum, RoomNum, CheckIn, CheckOut, CustID, CustFName, CustLName, CustPhone, CustType, CustDesc, LoyaltyID, AgentID, AgentFName, AgentLName, AgentType, AgentDesc, GuestCount, RoomType, RoomDesc, RateType, RateDesc, RateAmt
Res Num Check In Check Out Cust ID Cust F Name Cust L Name Cust Phone Cust Type Cust Desc Loyalty ID Agent ID Agent F Name Agent L Name Agent Type Agent Desc Guest Count Room Num Room Type Room Desc Rate Type Rate Desc Rate Amt 1001 9/5/2020 9/7/2020 85 Wesleyl Tanner (817)555-119 C Corporate 323 20 Megan Smith FD Front Desk 2 224 K King Bed Corporate $120 1001 9/5/2020 9/8/2020 85 Wesley Tanner (817)555-1194C Corporate 323 201 Megan Smith FD Front Desk 2 225 D 2 Double Beds C Corporate $125 1002 9/1/2020 9/10/2020 100 Breanna Rhodes (214)555-91911 Individual 129 5 Janice May T Telephone 4 305 D 2 Double Beds Standard $149 1003 9/9/2020 9/11/2020 15 Jeff Miner 1 Individual 14 John King RC Online Res Cel 3 409 D 2 Double Beds w Weekend $99 1004 9/12/2020 9/14/2020 77 Kim Jackson Corporate 210 28 Rayl Schultz T Telephone 4 320D 2 Double Beds C Corporate $110 1004 9/12/2020 9/14/2020 77 Kim Jackson Corporate 210 28 Ray Schultz Telephone 4 409 D 2 Double Beds C $105 (817)555-4911 (817)555-4911 (817)555-4911c (817)555-23341 Corporate Corporate 1004 9/12/2020 9/14/2020 77 Kim Jackson Corporate 210 28 Rayl Schultz T Telephone 4 321 K C $112 King Bed King Bed 1005 9/15/2020 9/18/20201 119 Mary Vaughn Individual 118 20 Megan Smith FD Front Desk 1 302 K S Standard $139 1006 9/24/2020 97 Chris Mancha (469)555-3441 Individual 153 14 John King RC Online Res Ce 2 501 KS King Suite W Weekend $119 9/26/2020 9/26/2020 1006 9/24/2020 97 Chris Mancha Individual 153 14 John King RC Online Res Ce 2 502 KS King Suite w Weekend $119 (469)555-34441 (214)555-91911 1007 9/20/2020 9/25/2020 100 Breanna Rhodes Individual 129 20 Megan Smith FD Front Desk 2 302 K King Bed S Standard $139 1008 10/1/2020 10/3/2020 85 Wesleyl Tanner (817)555-1198 Corporate 323 5 Janice May IT Telephone 3 320D 2 Double Beds w Weekend $89 1008 10/1/2020 85 Wesley Tanner (817)555-119 C Corporate 323 5 Janice May Telephone 3 321 K King Bed W Weekend $99 10/3/2020 10/4/2020 1009 10/1/2020 28 Renee Walker Individual 135 14 John King RC Online Res Cel 502 KS King Suite w Weekend $129 (214)555-92891 (214)555-92891 1009 10/1/2020 10/4/2020 28 Renee Walker Individual 135 14 John King RC Online Res Cel 2 409 D 2 Double Bed W Weekend $129 1010 10/1/2020 10/9/2020 23 Shelby Day Individual 28 Ray Schultz T Telephone 4 225 D 2 Double Beds w Weekend $109 Res Num Room Num Check In Check Out Cust ID Cust F Name Cust L Name Cust Phone Cust Type Cust Desc Loyalty ID Agent ID Agent F Name Agent L Name Agent Type Agent Desc Guest Count Room Type Room Desc Rate Type Rate Desc Rate Amt
