Please please help, Im completely lost!!!!

a Assignment Steps 1. Using a drawing tool of your choice, create an entity relationship diagram that depicts the relationships between the various entities provided in Microsoft Excel for the mythical ABC Fitness Company. Include facility locations, classes, class schedules and instructor. Refer to Section 6.1 in Laudon and Laudon for guidance and examples. Also, see Slides 9-12 from the February 16,2022 class. The ER-Assistant available on Apporto is one option. Some other options are Microsoft Visio and a tool within Microsoft Access. 2. Extend the entity relationship diagram to include members and class registrations of members by course. 3. Create the database in Microsoft Access represented by the entity relationship diagram developed in Step #1. Populate the database with the sample data provided in Microsoft Excel. Make any adjustments in the database design (additional fields, splitting of columns into multiple fields, etc.) that seem appropriate. 4. Create a report/query that provides the course list for the three Charlotte locations. The report/query needs to include the class name and the instructor's name. Optional/Bonus Step 5. Create a report/query for the Charlotte University location which show classes with available space. State Zip Location ID Location Name 1 Charlotte University 2 Concord 3 Matthews 4 Raleigh 5 Chapel Hill 6 Durham Address 8514 University City Blvd 6270 Bayfield Parkway 9915 e Independence Blvd 1141 Falls River Ave #100 257 S Elliot Road 3103 Shannon Road City Charlotte Concord Matthews Raleigh Chapel Hill Durham NC NC NC NC NC 28213 28027 28106 27614 27514 27707 NC Class Code 100 Body Combat 101 Zumba 102 Ride 103 Slver Sneakers 104 Power Yoga 105 Pilates 106 No Limits Cardio Location Session 60 60 Class Code Season 1 100 Spring21 1 101 Spring21 1 102 Spring21 1 103 Spring21 1 104 Spring21 1 104 Spring21 1 105 Spring21 1 106 Spring21 1 106 Spring21 1 100 Spring21 1 101 Spring21 1 102 Spring21 1 103 Spring21 1 104 Spring21 1 104 Spring21 1 105 Spring21 1 106 Spring21 1 106 Spring21 2 100 Spring21 2 101 Spring21 2 102 Spring21 2 103 Spring21 2 104 Spring21 2 104 Spring21 2 105 Spring21 2 106 Spring21 2 106 Spring21 3 100 Spring21 3 101 Spring21 3 102 Spring21 3 103 Spring21 3 104 Spring21 3 3 104 Spring21 3 105 Spring21 3 106 Spring21 3 106 Spring21 Days Offered 1 M, W 1, Th 1 M, W 1 I, Th. 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th 1 M, W 1, Th 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th 1 M, W 1, Th 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th. 1 MW 1 I, Th. 1 M, W 2 M, W 1 F 1 F 2 F Start Time Duration 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 Instructor Class Capacity Confirmed Registrations 1001 15 12 60 1002 15 14 60 1001 15 12 60 1002 15 15 60 1003 15 15 1003 15 12 90 1001 15 12 90 1002 15 10 90 1002 15 12 60 1001 15 10 60 1002 15 12 60 1001 15 12 60 1002 15 15 60 1003 15 15 60 1003 15 15 90 1001 15 15 90 1002 12 12 90 1002 12 12 60 1003 12 8 60 1003 12 9 60 1004 12 12 60 1004 12 11 60 1005 12 12 60 1005 12 12 90 1006 12 12 90 1004 12 12 90 1006 12 11 60 1006 15 15 60 1006 15 15 60 1007 15 15 60 1007 15 12 60 1007 15 8 60 1007 15 12 1007 15 10 90 1008 15 12 90 1008 15 15 1:00 1:00 3:00 5:00 10:00 10:00 1:00 90 a Assignment Steps 1. Using a drawing tool of your choice, create an entity relationship diagram that depicts the relationships between the various entities provided in Microsoft Excel for the mythical ABC Fitness Company. Include facility locations, classes, class schedules and instructor. Refer to Section 6.1 in Laudon and Laudon for guidance and examples. Also, see Slides 9-12 from the February 16,2022 class. The ER-Assistant available on Apporto is one option. Some other options are Microsoft Visio and a tool within Microsoft Access. 2. Extend the entity relationship diagram to include members and class registrations of members by course. 3. Create the database in Microsoft Access represented by the entity relationship diagram developed in Step #1. Populate the database with the sample data provided in Microsoft Excel. Make any adjustments in the database design (additional fields, splitting of columns into multiple fields, etc.) that seem appropriate. 4. Create a report/query that provides the course list for the three Charlotte locations. The report/query needs to include the class name and the instructor's name. Optional/Bonus Step 5. Create a report/query for the Charlotte University location which show classes with available space. State Zip Location ID Location Name 1 Charlotte University 2 Concord 3 Matthews 4 Raleigh 5 Chapel Hill 6 Durham Address 8514 University City Blvd 6270 Bayfield Parkway 9915 e Independence Blvd 1141 Falls River Ave #100 257 S Elliot Road 3103 Shannon Road City Charlotte Concord Matthews Raleigh Chapel Hill Durham NC NC NC NC NC 28213 28027 28106 27614 27514 27707 NC Class Code 100 Body Combat 101 Zumba 102 Ride 103 Slver Sneakers 104 Power Yoga 105 Pilates 106 No Limits Cardio Location Session 60 60 Class Code Season 1 100 Spring21 1 101 Spring21 1 102 Spring21 1 103 Spring21 1 104 Spring21 1 104 Spring21 1 105 Spring21 1 106 Spring21 1 106 Spring21 1 100 Spring21 1 101 Spring21 1 102 Spring21 1 103 Spring21 1 104 Spring21 1 104 Spring21 1 105 Spring21 1 106 Spring21 1 106 Spring21 2 100 Spring21 2 101 Spring21 2 102 Spring21 2 103 Spring21 2 104 Spring21 2 104 Spring21 2 105 Spring21 2 106 Spring21 2 106 Spring21 3 100 Spring21 3 101 Spring21 3 102 Spring21 3 103 Spring21 3 104 Spring21 3 3 104 Spring21 3 105 Spring21 3 106 Spring21 3 106 Spring21 Days Offered 1 M, W 1, Th 1 M, W 1 I, Th. 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th 1 M, W 1, Th 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th 1 M, W 1, Th 1 M, W 2 M, W 1 F 1 F 2 F 1 M, W 1 I, Th. 1 MW 1 I, Th. 1 M, W 2 M, W 1 F 1 F 2 F Start Time Duration 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 1:00 1:00 3:00 5:00 10:00 10:00 1:00 10:00 10:00 Instructor Class Capacity Confirmed Registrations 1001 15 12 60 1002 15 14 60 1001 15 12 60 1002 15 15 60 1003 15 15 1003 15 12 90 1001 15 12 90 1002 15 10 90 1002 15 12 60 1001 15 10 60 1002 15 12 60 1001 15 12 60 1002 15 15 60 1003 15 15 60 1003 15 15 90 1001 15 15 90 1002 12 12 90 1002 12 12 60 1003 12 8 60 1003 12 9 60 1004 12 12 60 1004 12 11 60 1005 12 12 60 1005 12 12 90 1006 12 12 90 1004 12 12 90 1006 12 11 60 1006 15 15 60 1006 15 15 60 1007 15 15 60 1007 15 12 60 1007 15 8 60 1007 15 12 1007 15 10 90 1008 15 12 90 1008 15 15 1:00 1:00 3:00 5:00 10:00 10:00 1:00 90