You have been asked to design a database for a company that operates a gym in Canterbury. The database will store information about members, staff, day passes purchased, and scheduled classes. The gym employs fitness trainers who give classes, and some administrative staff with various job roles, e.g., manager, receptionist, etc. The data stored for each member of staff will include a unique staff number, their forename and surname, date of birth, gender, contact phone number and address, their starting date, and their leaving date. For trainers, their area of speciality will be recorded, while other members of staff will have their role recorded. Members may register at the gym as a monthly contract member or a pay per use member. Each member has a unique member number, and their forename, surname, date of birth, address, contact phone number, and summary details of medical conditions will also be recorded. For monthly contract members, the start date, price paid monthly, day of the month the payment is taken, and end date of the contract is recorded. No extra information is required for pay per use members. Pay per use members purchase day passes to use the gym and must purchase at least one when they register. For a day pass, the start date, number of days the pass is valid for, and the price paid for the day pass are recorded. The gym offers fitness classes every day with the possibility of a class being run more than once on a day. Each class is given by a single trainer, admin staff do not give classes. The maximum number of spaces and the level the class is for, i.e., beginner, intermediate, advanced, is also recorded. After members register with the gym, they can book scheduled classes. 1. [25 marks] Design a conceptual data model for the given scenario. a) Construct an ER diagram in UML. The diagram should show all entities, attributes of each entity, relationships between the entities with appropriate multiplicity constraints, and the coverage properties for any hierarchical relationships you have identified. b) State any assumptions necessary to resolve ambiguities in the scenario. Pay special attention to cardinalities and participation constraints.