Please help wherever you can. It's a long question, so it's all good if you don't answer the whole thing. Thank you
. p. 57 - E2.2 Create the ER diagrams for a scenario based on these requirements: A health care organization kerp track of its doctors and outpatient locations, . For each doctor it keeps track of the DoctorID (unique), Doctor Name, and DoctorYear O/MDGraduation Gear of graduating from medical school). For each outpatient location it keep track of the OLID (unique) and OLName, and the following additional requirement: E2.2a Additional requirement Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rehab and minor health issues only) and many doctors working at it. E2.2b Additional requirement Each doctor works at either one outpatient location or at none (strictly working in the main hospital. and each outpatient location must have at least one but can have many doctors working at it. E2.2c Additional requirement Each doctor work at exactly one wpatient location, and each outpatient location must have at least one but can have many doctors working or in E2.2d Additional requirement Each doctor works at either one outpatient location or at none (strictly working in the main hospita and each outpatient location can have been one rehab and minor health issues only) and more doctors working at it E2.2e Additional requirement Each doctor works ar between wone strictly working in the main hospital), and many outpatient lowcations, and each outpatient location must have at least one but can have many doctors working at it. E2.21 Additional requirement Each doctor works at between cine and many crutpatient Researions, and each outpatient location mest have one but can have many doctors working at it. E2.2g Additional requirement Each doctor_wards at between none (strierly working in the_main hospital, and many outpatient locations, and each otpatient location can have between none frehah and minor health issues only) and many doctors working at it. E2.2h Additional requirement Each doctor works ar either one outpatient location or af none (strictly working in the main hospital. and each otpatient location has exactly one doctor working at it. E2.21 Additional requirement Each doctor works at exactly one outpatient location, and each outpatient location has exactly one doctor wwwking at it E2.2) Additional requirement Each doctor works at either one outpatient location or at mone strictly working in the main hospitali. and each outpatient location can have between nane rehab and minor health issues only) and one doctor working at ir E2.2k Additional requirements Each doctor works at between one and many outpatient locations and cachottient location have at least one but can have many doctors working at it. For each occurrence of a doctor working or an outpatient location, we keep track of the No/Hours Per Week number of hours per week that a doctor works of an outpatient location. E2.21 Additional requirement Each doctor works at between two and four_outpatient locations, and each outpatient location has between three and ten doctors working at it E2.2m Additional requirements Each doctor works ar between one and many outpatient locations, and cach outpatient location must have at least one but can have many doctors working at it. Each doctor_manager, between sero_and one outpatient locations, and each gutpatient location has exactly one doctor managing it
