Homework Assignment: ER Diagram for Martial Arts University
- Due Feb 7, 2022 by 11:59pm
- Points 150
- Submitting a file upload
- File Types pdf
- Available Jan 31, 2022 at 12am - Feb 18, 2022 at 11:59pm
“Martial Arts R Us” (MARU) needs a small database. MARU is a martial arts school with hundreds of students. It is necessary to keep track of some of the different information that is gathered in the database. For instance, all the different classes that are being offered, who is assigned to teach each class, and attendance of which students attend each class. Also, it is important to track the progress of each student as they advance to different levels in the school. . Create a complete Chen Notation 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, email, and the date they joined the school.
- For each instructor, their name, date of birth, phone number, 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, may not be officially assigned to any class.
- A class is offered for a specific level of the student. Classes are held 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 beginner-level class. A third class taught on Tuesdays at 5:00 pm in Room #2 is an advanced-level class.
- 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. A specific Class can have many Sessions/Meetings. A specific Session/Meeting can only be associated with a single Class.
- A student will attend many different class Sessions/Meetings, Each class Session/ Meeting is normally attended by many students. It is possible that some Sessions/ Meetings for a specific class may have no students show up for that Session/Meeting. New students may not have attended any class meetings yet.
- At any given Session/Meeting of a class, instructors other than the assigned instructor may show up to help. Therefore, a given class Meeting/Session may have several instructors (a head instructor and many assistant instructors), but it will always have at least one instructor that is officially assigned to that class. For each Class Session/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 class in Room #1. During one particular meeting of that class, Mr. Jones was present as the head instructor and Ms. Chen came to help as an assistant instructor. A class session/meeting can be taught by many instructors. A class meeting/session can have 0 or more students attend.
- Each student holds a Rank in the martial arts. Each Rank has a rank name, belt color, and rank requirements. Rank information must be stored. Each rank may have many rank requirements. Each requirement is considered a requirement just for the rank that it is associated with. A rank requirement is associated with only one rank. Every requirement is associated with a particular rank. All ranks except the white belt have at least one requirement.
- A given rank may 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 student’s progress through the ranks. Therefore, every rank that a student 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.
- For this assignment, students have the option of creating the ER Diagramming model in either Chen Modeling Notation or Crowfeet Modeling notation
- All ER Diagrams must be submitted in a PDF.