“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each...

“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. The database must keep track of all the classes that are offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance.

1.Create a complete Crow’s Foot ERD for these requirements:

2.Create a relational diagram for the data model.

3.Draw the dependency diagram showing partial and transitive dependency(if any).

4. Normalize the tables to 3NF.

5. Show the dependency diagram after normalization.

6. Use SQL to create all tables in Access. Do not forget FK,PK

7. Create relationships.