Question Details

[solution] » Question 2 "Martial Arts R Us" (MARU) needs a database. MARU

Brief item decscription

Step-by-step solution file

Item details:

Question 2 "Martial Arts R Us" (MARU) needs a database. MARU
More:Question 2

 ?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 intermediatelevel 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 student will attend many different class meetings; and each class meeting 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 assigned 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 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 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.

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 considered 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.

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.


About this question:

This question was answered on: Feb 21, 2020

PRICE: $24 (18.37 KB)

Buy this answer for only: $24

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now