Please Post EERD Complete Solution with all possible entites.

4. Build an EER diagram to capture the following scenario. Be sure to include total/partial designations, and overlap/disjoint overlap. Show specializations when they are necessary to show and do not show them (even if they exist), when they are not necessary to the design of the database. Be sure to include the subtype discriminators: CovidClinic staff are feeling overwhelmed with all of the new protocols and the spikes in the cases of this pandemic. They are concerned that their lack of familiarity with some of the unusual challenges and also the number of cases may cause them to give less-than-optimal care to their patients. Therefore, Covid Clinic has instituted a mentoring program to help train and support their staff and patients. Covid Clinic has several different types of people in their clinic. These would include medical employees (doctors, psychologists, nurses, clinical staff (such as phlebotomists, etc.)), administrative and support staff (such as clerical workers and so forth), who are also employees. Patients and mentors are also persons about whom CovidClinic wants to track. Mentors can be current or past employees, current or past patients, or outside volunteers or consultants who have had some prior experience with covid and are able and willing to provide guidance or support to other members of CovidClinic community. CovidClinic retains basic contact information about every person associated with the clinic. This would be things like a PersonlD, name, address and phone#. For Employees, the clinic stores the Date Of Hire and the job title. Every person who expresses an interest in having a mentor can be assigned one (but only one). Every person who feels qualified in serving as a mentor can request to serve as a mentor to as many people as the mentor feels capable of helping. There are many categories of mentoring that are provided. These can include things like counseling, providing training in vaccination, testing and scheduling, and several other type of training and support. CovidClinic keeps track of the different kinds of mentoring services that different mentors can provide. As part of its efforts, some Covid Clinic administrators give monthly zoom informational sessions to the public. The title, description, administrator, date and attendance for each zoom session are stored. Covid Clinic provides further support to the community by providing free or reduced rate mental health therapies due to the stress of covid. These sessions can only be provided by psychologists or psychiatrists (who are physicians). These therapy sessions are scheduled individually and a record is kept of the therapist, the patient and the date of the session. As part of the special covid support program Covid Clinic has extended this service to include not only patients but any member of the CovidClinic community