Homework assignment 1 Due first week of Nov. in class. This assignment is to check the solution against the business rules, modified the solution as needed to conform. Point out discrepancy without modification is also acceptable, however more exhaustive search will be needed to make up for lack of solution. Submit the modified ER Diagram in hand drawn paper form with the modified portion in color. Please write a few lines justify the changes that you made. I.e. Class level is not indicated in the diagram. Instructors need to be recorded in meeting.
“Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. It is necessary to keep track of all the different classes that are being 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. Create a complete Crow’s Foot ERD for these requirements: * Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they joined the school. * All instructors are also students, but clearly, not all students are instructors. In addition to the normal student information, for each instructor, the date that they start working as an instructor must be recorded, along with their instructor status (compensated or volunteer). * An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be assigned to any class. * A class is offered for a specific level at a specific time, day of the week, and location. For example, one class taught on Mondays at 5:00 pm in Room #1 is an intermediate-level class. Another class taught on Mondays at 6:00 pm in Room #1 is a