Using the notes below and the chart below a. Develop a relational scheria (textual representation) consisting of 3NF relations. In your relational schema, make sure to show entity integrity and referential int egrity constraints properly b List all (partial, full, and transitive) functional dependencies for this relational schema Comment in 1-2 sentences on why this relational schema is in the third normal form. 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 oftered who is assigned toteach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance Given below are the reuirements: c) Students aregiven 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. d) All instructors are also stucents, but clearly, not all students are instructors. In addition to the normal student information, for each instructor, the date that ther start working as an instructor must be recorded, along with their instructor status (compensated or volunteer) e) An instructor may be.assigned toteach any number of classes, but each dass has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be asasned to any class f) 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 #l is an intermedatelevel class. Another class taught on Mondays at 6:00pm in Room #1 is a beginner-level class. A third dass taught on Tuesdays at 5:00 pm in Room #2 is an advancedievel dass. g) Stucdlents may attend any class of the appropriate level during each week sothere is no expectation that any particular student will attend any particular class session. Therefore, the actual attendance of students at each individual class meeting must be tracked h) A student will attend many different class meetings; and each dlassmeeting is normally attended by many students, Some class meetings may have no students show up for that meeting. New students may not have attended any class meetings yet. ) At any given meeting of a class, instructors other than the assgned instructor may show up to help. Therefore, a given class meeting may have several instructors (a head instructor and many assistant instructors), but it will always have at least the one instructor that is assignedto that class. For each class meeting, the date that the class was taught and the instructors' roles (head instructor or assistant instruct or) need to be recorded For example, Mr. Jones is assigned to teach the Monday, 5:00 pm, intermediate class in Room #1. Dunng one particular meeting of that class, Mr. Jones was present as the head instructor and Ms. Chen came to help as an assistant instructor. j Each student holds a rank in the martial arts. The rank name, belt color, and rank requirements are stored. Each rank will have numerous rank requirements. Each requirement is. sonsidered a requirement just for the rank at which the requirement is introduced. Every requirement is associated with a particular rank. All ranks except white belt have at least one requirement. kiAgiven rank max be held by.many students, While it is customary to think of a student as having a single rank, it is necessary to track each stuclent's progress through the ranks. Therefore, every rank that a stucent attains is.kept in the system. New students joining the school are.automatically. given a white belt rank. The date that a student is awarded each rank should be kept in the system. All ranks have at least one student that has achieved that rank at some time. REQUIREMENT PK Req Desc FK1 Rank Num includes RANK ATTAIN PK, FK1 Rank Num PK, FK2Su Num PK Rank Num Rank Name eams Rank Belt Stu FName Stu LName Stu DOB Stu Join Date completes Attain Date MEETING has Meet Date Att Role FK1 Class ID Stu Is Inst generates CLASS PK ClassID INSTRUCTOR is assigned Class Weekday Class Time Class Location Class Level Inst Hire Date Inst Status FK Stu Num