Question

please help with the entities and relationship

Database Design The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45 per hour per student (or couple) for a private lesson and $6 per hour per student for a group lesson. Private lessons are offered throughout the day, from noon untl 10 .M, six days a week. Group lessons are offered in the evenings. Jefferson employs two types of instructor: full-time salaried instructors and part-time instructors. The full-time Instructors are paid a fixed amount per weelk, and the part-time Instructors are pald elther a set amount for an evening or a set amount for teaching a particular class. In addition to the lessons, Jefferson sponsors two weekly socal dances featur- ing recorded music. The admission charge is S5 per person. The Friday night dance is the more popular and averages around 80 people; the Sunday night dance attracts about 30 attendees. The purpose of the dances is to give the stu- dents a place in which to practice their skills. No food or drinks are served Jefferson would like to develop an information system to keep track of stu- dents and the classes they have taken. Jefferson's managers would also like to know how many and which types of lessons each teacher has taught and to be able to compute the average cost per lesson for each of thelr instructors.

Answer 1

Jafferson Dance club ER Diagram

Relation 'Student' and 'Classes' connected by relationship 'Joins' via M:N relation.

Relation 'Classes' have an attribure manely 'Type', which can be 'private', 'group' or the 'weekly dance'. Class has a rate based on its type.

Relation 'instructor' is further classified as 'salaried' and 'part-time' relations. Both these sub relation contains all the attributes of relation 'instructor' plus additional attributes.

Name ID Student Joins Type (Private Group, Weekly) Name Classes Time Rate ID Taught Name Instructor ID ISA Hourly Rate Salary Salaried Part-time

Kindly Upvote if Helpful :)
HOPE THIS MAY HELP YOU----------------------

------------------------------THANK YOU---------------------------