$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 EntityRelationship 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. Each fitness class is attended by

many members.

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 $($as many as you think$)$ attributes of each relation. Show Primary Key

attributes as bold and underlined. You can show Foreign Key attributes in italics i need actual drawings