I’m working on a Computer Science case study and need support to help me learn.

CPIS 340: Database Management SystemsAssignment 1 –

You are hired to design a database for a fitness center. As the fitness center is expanding withmore than one branch, they want to create a database to keep track of its customers, facilities andemployees. Each branch has a unique id and address (building number, street, district, and city).A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility mustbelong to only one branch, and the information for a facility is name and fees. In addition, eachfitness branch offers different classes (such as Yoga, Pilates, Zumba, etc.). All classes should beled by at most one trainer, who is an employee.Employees must work at one and only one branch. Each employee has an id, name, address(building number, street, district, and city) and can have multiple phone numbers. An employeecan only be an admin, managing the facility or working as a clerk, or a trainer. An employeecannot be a trainer and an admin because the trainer id compensated an hourly wage while anadmin staff paid a monthly salary. Trainers can train individual customers at different timesessions.A customer must register at one branch. Each customer has a membership number, name (storedas first name and last name), email, and only one phone number. A customer can join more thanone class or uses any number of facilities. A customer may also decide to be trained by at mostone personal trainer.Given the above description:1. Draw an ERD for the database, identifying the following:a.All the entities, attributes and relationshipsb.Primary key and (discriminator in weak entity, if any). Don’t forget eachentity has to have PK.c.Participation and cardinality constraints. (Explain your choices for twoconstraints- i.e. identify the words the guided your decision)d.Specialization and completeness constraints (if there is an ISA relationship).2. Write a schema for two entities and two relationships of your choice. Remember,sometimes a relationship is better not be represented in a separate schema; if this isthe case with your chosen relationship explain what you will do.Please use a tool to draw the ERD. There are many tools out there; some students suggested:https://erdplus.com/This assignment worth 10% of your overall grade.