Instructions:

ITSS $4380$ Fall $2024-$ Assignment $1$

This is an INDIVIDUAL ASSIGNMENT. Use Crow$$s Foot Notation as we use in class. I suggest you use draw.io$.$ Export your diagram as PDF and submit on E$-$Learning before the Due Date and Time. EMAIL or TEAMS messages outside of special circumstances will NOT be accepted as a valid submission.

Part $1$

$1.$ Please draw the E$-$R Diagram using Crow$$s Foot Notation for the following scenario. List any assumptions about each business rule if you need to make any. DO NOT PUT ATTRIBUTES in this part.

$2.$ Make sure you put mandatory and optional cardinality constraints clearly.

A high$-$end Fitness Company $($Super Bowl Fit$)$ is looking to revamp its Information System architecture and will invest in a new RDBMS Cluster on a Public Cloud Environment. You are consulting them to create the Entity$-$Relationship Diagram for this database.

Super Bowl Fit offers Group Fitness Classes, Personal Training Sessions, and several membership packages. Each member can have one membership package. Super Bowl Fit has several branches. A customer of the company is called a member. Members purchase memberships at a branch. Each home branch has many members. Each member can train in any branch but he$/$she has only one branch as $$Home Branch$.$

Each Branch has many trainers. Each trainer is assigned to one branch only. Each trainer can train many clients, and each member can train with more than one trainer. When the trainer and the member agree on a schedule, it has a session name describing what they train for, such as leg training, chest training, general training etc. Session names are standard so it is similar to a Product. Each session in the schedule is for one training type only and it is custom for every member. In other words, each scheduled session is for one member and one trainer.

Each member purchases a membership package at a branch. Super Bowl Fit wants to keep track of the history of membership purchases at each branch. Each membership package can be purchased by many members. Super Bowl Fit wants to track the payments the customers made for their membership packages, each member makes many payments, and each payment is for one membership package. Each payment is also made by one member.

Each branch offers many group fitness classes. Each group fitness class is offered at one branch. In other words, no same group fitness class is offered by more than one branch. Super Bowl Fit wants to track the attendance for each fitness class session. Each member signs up for the fitness class they plan to attend. If they don$$t attend for some reason, they don$$t need to cancel, but it is advised to cancel to be able to track the attendance. Each fitness class can accommodate many members, but it has a capacity and a set schedule. Each schedule is for one session of the class. For example Tuesday September $10,2024.$ Each member can attend different fitness class sessions at different days and times.

Part $2$

Draw the Logical Database Diagram for the scenario as we did in Lecture $3.$ Show Referential Integrity Constraints $($via arrows$).$ Please put in all necessary attributes of each relation. Show Primary Key attributes as bold and underlined. You can show Foreign Key attributes in italics.