Using the notes below and the chart below: Develop a relational schea (textual representation) consisting of 3NF relations. In your relational schema, make sure to show entity integrity and referential integrity 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 to teach 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 requirements c) 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. d) All instructors are also students, but clearly, not all students are instructors. In addtion to the normal student information, for each instructor, the date that thex 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 class has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be assigned to any class f) A class is offered for a specific level at a specific time, day of the week, and lacation. For example, one class taught on Mondays at 5:00 pm in Room#1 is an intermedateleve class. Another class taught on Mondays at 6:00 pm in Room #1 is a beginner-level class. A third class taught on Tuesdays at 5:00 pm in Room #2 is an advanced level class g) Students may attend any class of the appropriate level during each week so there 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 cass meeting is normally. attended by manystudents, 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 assigned instructor may show up to help. Therefore, a given class meeting may have several instructors (a head instructor and man assistant instructors), but it will always have at least the one instructor that is assigned to that class. For each class meeting, the date that the class was taught and the instructors' roles (head instructor or assistant instructor) need to be recorded. For example, Mr. Jones is assigned to teach the Monday, 5:00 pm, intermediate dass in Room #1. During one particular meeting of REQUIREMENT PK Req Desc FK1 Rank Num includes . RANK ATTAIN eams PK, FK1 Rank Num Rank Name Rank Belt Stu FName Stu LName Stu DOB Stu Join Date . completes Stu Is Inst Attain Date MEETING ATTENDANCE PK, FK1 Meet Num PK, FK2 Stu Num has Meet Date Att Role FK1 Class ID Stu Is Inst generates CLASS INSTRUCTOR ts assigned PK ClassID _ _ _0 Class weekday Class Time Class Location Class Level PK, FK1 Stu Num Inst Hire Date Inst Status FK Stu Num