Swing Jazz Club ERD Problem
Swing Jazz Club ERD Problem
Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a
You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality.
Swing Jazz Club
The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson. Group lessons are limited to 12 customers. Private lessons are offered during the day and group lessons at night. Swing Jazz employs two types of instructors, F/T instructors (salary) and P/T instructors (hourly). Both types of instructors may teach both private and group lessons. In addition to the lessons, Swing Jazz sponsors three weekly dances of which instructors must attend one of the three. The instructors are paid a flat rate of $40 dollars for dance attendance. Customers must pay $8 to attend a dance. Swing Jazz does not track which customers attend a dance.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
