Type or paste question here

Question 1: Suppose you have the following scenario: 5 marks Riyadh Municipality would like to create a special database for collecting data on all animal shelters in the city. Each shelter has a name, an address, a phone number, and a set of days on which it is open. Each shelter is managed by one employee and it employs twenty workers at most. An employee has a social security number, a name, an address, a phone number, and a pay rate. An employee works at least for one shelter for some regular set of days each week. A volunteer has a social security number, a name, an address, a phone number, and a number of volunteering hours. A volunteer works at one shelter at least for some regular set of days each week. A person affiliated with a shelter is either an employee or a volunteer, but not both. A pet is housed at one shelter. Each pet has a number that's unique to its shelter, a name, a birth date, and an age. A pet can be a dog, a cat, or other. For the cats the color is stored and for the dogs the species is stored. Each shelter is supervised by two veterinary doctors at least. Each doctor has a social security number, name, address, phone number and a pay rate. Each pet must be seen by a doctor for one day each week and for each visit the visit date and the pet health condition must be registered. By using any modeling tool: Design an EER (Enhanced Entity-Relationship) diagram for the shelters database based on the above data specification Identify the relationship structural constraints: cardinality ratio and participation constraint. o Note that if the scenario didn't clarify some relationships, attributes or unique keys you think they should exist, make a clear assumption and include them in your diagram Consider the following assumptions according to the scenario, state clearly if it is correct or not and why? Ali, as a volunteer, can manage a shelter. Ahmed, as an employee, can work in two shelters o Doctor Abdullah check a white and black dog 0 ShelterX is supervised by Doctor Abdullah only