The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45
Question:
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 until 10 P.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 week, and the part-time instructors are paid either a set amount for an evening or a set amount for teaching a particular class.
In addition to the lessons, Jefferson sponsors two weekly social dances featuring recorded music. The admission charge is $5 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 students 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 students 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 their instructors.
Create high-level ER Model.
You only need to model entities, relationships, and their cardinality The ER you develop should be created with the idea that you are building an information system for the business in each case There are more entities in the narrative than necessary to build an info system. Part of your challenge, in addition to designing and using the proper notation, is to select only those entities necessary for your ER model Ignore all attributes Ignore all numerical data in each case
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins