please help me answer this question, I promise to upvote on the right answer

01 J14-rroject 1 Due 3/12 Cunho Cum Art ER 2 c 2200 Core SUS 1003 10 RE Bere . 1 2 3 20 Me 14 - > ne Business Rules: Each reservation belongs to a specific customer customers may or may not have any reservations Each customer is a specific type, some customer types may not have any customers Each reservation is booked by a specific agents each agent may or may not have booked any reservations Eacht works for a specific department, each department has at least one agent emploveel Exchreservation is for one or more rooms, all with the same rate type within the came reservation but rates types may vary from reservation to reservation some rooms may not have any reservations Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (INF) - 20 points: Decompose the composite attributes into simple attributes Convert the table above to INF (eliminate repeating groups of data and select an appropriate PK) Show the table structure format table name with and all dependent attributes in parentheses). d. Create a dependency diagram for the table above 2. SECOND NORMAL FORM (NF) - 20 points: Show the table structure format for each table in D. Create the dependency diagrams for the resulting tables 3. THIRD NORMAL FORM (NF) - 25 points Convert to INE and show the table structure format for each table h. Create the dependency diagrams for the resulting tables 4. ENTITY-RELATIONSHIP MODEL - 35 points: . Create a relational schema showing at NF tables entities the attributes, and the connectivity of the relationships. Each entity should be depicted as a rectangle with the name and the top and the attributes listed under the name. This may be done in Access, b. Using Chen notation, create an ERD showing all of the tables above. You must show the entities relationships, connectivity participation, and cardinality it is not necessary to show the attributes on the ERDI. This assignment is due by 11:59 PM on the due date. Microsoft Visie or other diagramming software is recommended to create the required diagrams. Please upload your assignment as a single document. This may be done by putting all diagrams into a single Word, Excel or PDF File Nu Check In Check Out Cust ID Cust Name Cust Phone Cust Type Cust Desc Loyalty ID Agent ID Agent Name Agent Type Agent Desc Guest Count m 100 1 9/5/2020 9/7/2020 85 Wesley Tanner (817)555-11 93 Corporate 323 20 Megan Smith FD Front Desk 2 100 2 9/1/2020 9/10/2020 100 Breanna Rhodes (214)555-91 91 1 Individual 129 5 Janice May T Telephone 4 100 3 9/9/2020 9/11/2020 15 Jeff Miner 1 Individual 14 John King RC Online Res Center 3 100 4 9/12/2020 9/14/2020 77 Kim Jackson (817)555-49 11 Corporate 210 28 Ray Schultz T Telephone 4 Mary 100 5 9/15/2020 Megan 9/18/2020 (817)555-23 34 119 1 Individual 118 20 FD Front Desk Vaughn Smith 100 6 9/24/2020 9/26/2020 97 Chris Mancha (469)555-34 40 Individual 153 14 John King RC Online Res Center 2 100 7 9/20/2020 9/25/2020 100 Breanna Rhodes (214)555-91 91 Individual 129 20 Megan Smith FD Front Desk Wesley 100 8 10/1/2020 10/3/2020 85 (817)555-11 93 C Corporate 323 5 Janice May T Tanner Telephone 3 Renee 100 9 10/1/2020 10/4/2020 28 (214)555-92 85 Individual 135 14 John King RC Online Res Center 2 Walker 101 0 10/1/2020 10/9/2020 Shelby 23 Individual 28 Ray Schultz T Telephone 4 Day 100 9 10/1/2020 10/4/2020 28 Renee Walker (214)555-92 85 1 Individual 135 14 John King RC Online Res Center 2 101 0 10/1/2020 10/9/2020 23 Shelby Day Individual 28 Ray Schultz T Telephone 4 Business Rules: Each reservation belongs to a specific customer; customers may or may not have any reservations. Each customer is a specific type; some customer types may not have any customers. Each reservation is booked by a specific agent; each agent may or may not have booked any reservations. Each agent works for a specific department; each department has at least one agent (employee). Each reservation is for one or more rooms, all with the same rate type within the same reservation, but rates ty reservation-to-reservation; some rooms may not have any reservations. a. Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (1NF) - 20 points: Decompose the composite attributes into simple attributes. b. Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK). C. Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above. 2. SECOND NORMAL FORM (2NF) - 20 points: a. Show the table structure format for each table in 2NF. 01 J14-rroject 1 Due 3/12 Cunho Cum Art ER 2 c 2200 Core SUS 1003 10 RE Bere . 1 2 3 20 Me 14 - > ne Business Rules: Each reservation belongs to a specific customer customers may or may not have any reservations Each customer is a specific type, some customer types may not have any customers Each reservation is booked by a specific agents each agent may or may not have booked any reservations Eacht works for a specific department, each department has at least one agent emploveel Exchreservation is for one or more rooms, all with the same rate type within the came reservation but rates types may vary from reservation to reservation some rooms may not have any reservations Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (INF) - 20 points: Decompose the composite attributes into simple attributes Convert the table above to INF (eliminate repeating groups of data and select an appropriate PK) Show the table structure format table name with and all dependent attributes in parentheses). d. Create a dependency diagram for the table above 2. SECOND NORMAL FORM (NF) - 20 points: Show the table structure format for each table in D. Create the dependency diagrams for the resulting tables 3. THIRD NORMAL FORM (NF) - 25 points Convert to INE and show the table structure format for each table h. Create the dependency diagrams for the resulting tables 4. ENTITY-RELATIONSHIP MODEL - 35 points: . Create a relational schema showing at NF tables entities the attributes, and the connectivity of the relationships. Each entity should be depicted as a rectangle with the name and the top and the attributes listed under the name. This may be done in Access, b. Using Chen notation, create an ERD showing all of the tables above. You must show the entities relationships, connectivity participation, and cardinality it is not necessary to show the attributes on the ERDI. This assignment is due by 11:59 PM on the due date. Microsoft Visie or other diagramming software is recommended to create the required diagrams. Please upload your assignment as a single document. This may be done by putting all diagrams into a single Word, Excel or PDF File Nu Check In Check Out Cust ID Cust Name Cust Phone Cust Type Cust Desc Loyalty ID Agent ID Agent Name Agent Type Agent Desc Guest Count m 100 1 9/5/2020 9/7/2020 85 Wesley Tanner (817)555-11 93 Corporate 323 20 Megan Smith FD Front Desk 2 100 2 9/1/2020 9/10/2020 100 Breanna Rhodes (214)555-91 91 1 Individual 129 5 Janice May T Telephone 4 100 3 9/9/2020 9/11/2020 15 Jeff Miner 1 Individual 14 John King RC Online Res Center 3 100 4 9/12/2020 9/14/2020 77 Kim Jackson (817)555-49 11 Corporate 210 28 Ray Schultz T Telephone 4 Mary 100 5 9/15/2020 Megan 9/18/2020 (817)555-23 34 119 1 Individual 118 20 FD Front Desk Vaughn Smith 100 6 9/24/2020 9/26/2020 97 Chris Mancha (469)555-34 40 Individual 153 14 John King RC Online Res Center 2 100 7 9/20/2020 9/25/2020 100 Breanna Rhodes (214)555-91 91 Individual 129 20 Megan Smith FD Front Desk Wesley 100 8 10/1/2020 10/3/2020 85 (817)555-11 93 C Corporate 323 5 Janice May T Tanner Telephone 3 Renee 100 9 10/1/2020 10/4/2020 28 (214)555-92 85 Individual 135 14 John King RC Online Res Center 2 Walker 101 0 10/1/2020 10/9/2020 Shelby 23 Individual 28 Ray Schultz T Telephone 4 Day 100 9 10/1/2020 10/4/2020 28 Renee Walker (214)555-92 85 1 Individual 135 14 John King RC Online Res Center 2 101 0 10/1/2020 10/9/2020 23 Shelby Day Individual 28 Ray Schultz T Telephone 4 Business Rules: Each reservation belongs to a specific customer; customers may or may not have any reservations. Each customer is a specific type; some customer types may not have any customers. Each reservation is booked by a specific agent; each agent may or may not have booked any reservations. Each agent works for a specific department; each department has at least one agent (employee). Each reservation is for one or more rooms, all with the same rate type within the same reservation, but rates ty reservation-to-reservation; some rooms may not have any reservations. a. Based on the information provided above, complete the following: 1. FIRST NORMAL FORM (1NF) - 20 points: Decompose the composite attributes into simple attributes. b. Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK). C. Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above. 2. SECOND NORMAL FORM (2NF) - 20 points: a. Show the table structure format for each table in 2NF