Based on the information provided above, please complete the following:

FIRST NORMAL FORM (1NF)

Decompose the composite attributes into simple attributes.

Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK).

Show the table structure format (table name with PK and all dependent attributes in parentheses).

Create a dependency diagram for the table above.

Loyalty Agent Agent Agent Room Room Check In Check Out ID Cust Name Cust PhoneT 001 018 01885 Wesley Tanner Smith FD Front Desk 4 K 2 Double Beds C 2 Double BedsS 2 Double BedsW 2 Double Beds C 225 D 1002 2/1/2018 2/3/2018 100 Breanna Rhodes (214)555-9191 Individual 2/1/2018 2/3/2018100 Breanna Rhodes (214555-9191 129 5 Janice May T 305 Standard $149 Front Desk 409D 320 D Smith FD Front Desk 302 K 003 4 John 018 018 018 018 Jeff Miner Weekend 018 77 Kim Jackson Schultz T $110 Standard 5139 W Weekend $119 Weekend $119 Standard $139 Individual 118 20 018 97 Chris Mancha 555-3440 Front Desk 501 KS 502 Ks 1007 2/20/2018 2/25/2018 100 Breanna Rhodes (214)555-9191Individual 12920 Smith FD Front Desk 302 K King Bed 1008 018 3 01885 Wesley Tanner 2 Double BedsW Weekend W Weekend $99 W Weekend $129 Weekend $129 1009 018 018 28 Renee Walker (214)555-9285 Individual 13514 John KingRC Res Center5KS 018 018 Schultz T 225 2 Double Beds