Using the Entities and Attributes from the business below, show the entity types, attributes and relationships resulting from your model in the form…

. Use Each sentence pairs to identify your relationships cardinality.

The business I chose to discuss is an Aquatic Camp. This camp holds courses to educate children and provide a fun environment for them. They offer one day courses which can be either private or group lessons (course type). For each course, there is one instructor assigned based on his/her experience. Students should register at least 24 hours before the begging of the course and the registration fee is nonrefundable after 24 hours prior to the beginning of the course. 

To keep the track of courses, instructors and course attendees (students) and their relationships, I built a simple relational database like MySQL with the following “Entities” and “Attributes”:

Entities Attributes

student              student_id, first_name, last_name, address, phone

instructor          Instructor_id, first_name, last_name, experience, address, phone

course                 course_id, instructor_id, date, time, duration, type, capacity, registered, price, status 

                            course_registration student_id, course_id, attended