Question: prepare a conceptual model ( ERD ) that reflects the data and relationships of the following organization: The Culinary Arts Academy ( CAA ) is

prepare a conceptual model (ERD) that reflects the data and relationships of the following organization:
The Culinary Arts Academy (CAA) is a renowned cooking school that needs a database to better manage
information about the cooking classes they offer. They maintain records of students seeking to enroll in cooking
classes. For each student, they capture a unique identifier, the students name (first and last), address (street,
city, state, zip), phone number, and how they prefer to receive notifications (email or phone).
CAA also keeps detailed information about each of its instructors, including their name (first and last), address
(street, city, state, zip), and any special skills they may have (pastry making, gourmet cooking, nutritional
meals, etc.). An instructor may have multiple special skills. Each instructor also has a unique instructor number.
CAA wants to track that new instructors receive mentoring before they start teaching. All instructors must be
mentored by an experienced instructor before they can be considered for teaching classes. The more
experienced instructors mentor the new instructors. An experienced instructor may mentor many new
instructors, although not all experienced instructors are required to mentor new instructors.
When a student books a cooking class, the class ID, date, time, type of cooking class (beginner, intermediate, or
advanced), and any special requests (gluten-free, vegan, etc.) are recorded. For each class booked, at least one
instructor must be assigned to teach. Once the class is completed, the outcome (satisfactory, additional lessons
recommended, follow-up class scheduled, etc.) is noted.
Occasionally, a cooking class may require health and safety interventions due to an unexpected incident (e.g.,
burns or cuts). The academy keeps track of the name and certification number for each health officer as well as
a description of the officers specialty. If a health officer is needed during a class, the officers certification
number, and the time the officer was called in are recorded. Sometimes, more than one health officer may be
called in if multiple incidents occur. The academy also tracks whether the health officer recommended that the
student be taken to a medical facility (Yes/No)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!