Conceptual Data Modeling

Create a data model (ERD) based on the following business rules. You must:

Identify all of the main entities.

Identify all of the relations and connectivities.

Identify PK and FK

Identify the type of participation optionality, existence dependency and relationship strength in all the relationships.

Resolve the many to many relationships using the associative entities.

Identify subordinate relationships (super type vs. sub type).

You must use Lucidchart to draw the ERD (and then copy and paste your complete diagram).

Salisbury Dancing studio wants you to develop a database to keep track of their activities, which include individual private lessons with one person or as group classes, which are scheduled over an 8-week period, with a start-date, an end-date. Activities are categorized into one of dance styles that include Ballroom, Line Dancing, Tango, Belly dancing, Jazz, Tap, Contemporary, and Swing. Each dance style has an ID and a description. Each scheduled dance activity has one or more instructors assigned to teach it. Instructors have dance specialties, and the usual contact information (name, address, phone, email). Likewise, they want to store the usual contact information for customers. Finally, they want to be able to schedule an activity with one or more customers and with one or more instructors. If a class has no participants, it is cancelled.

Hint: An Instructor may be specialized in many dancing styles; and a style can be the specialty of many instructors. There are also many to many relationships between Customer and Activity and between Instructor and Activity. Therefore, you may need several associative entities.