Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool. Schema

Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool.

image text in transcribed

Schema 1 COVID-19 clinic: (50) Mass General Hospital runs a collection of COVID-19 clinics throughout the city of Boston. A clinic has many staff members who work at it. A staff member has a name, an employee number, (empNo) which is unique, as well as a job description. A staff member may only work at one clinic. Each clinic has a unique clinic number (clinicNo) and an address, The clinic has a store of vaccines that are available for injection. Each vaccine instance has a vaccine type and a unique VaccineID, which is a unique number for the vaccine type. Currently there are two vaccine types approved in the US, the Pfizer and the Moderna vaccine type. For each vaccine type the clinic must track the number of injections needed for immunization and the time interval (number of recommended days) between the injections. When a citizen is required to receive a COVID-19 vaccine, he/she contacts a clinic to schedule an appointment. The appointments are an hour in length and can be scheduled from 8AM-8PM on Monday through Friday for a specific day of the year. Each appointment has a unique appointmentId. At the appointment, a citizen is administered the vaccine and is then monitored for a 12 hour by a staff member for side effects. The side effects are: allergic reaction, swelling at the point of injection, stiffness at the point of injection, joint stiffness, fever and headache. After the monitoring stage, the patient is then required to monitor him/herself and to contact the clinic if he/she experiences any side effects. The patient is also required to contact the clinic for any further innoculations needed for the vaccine type that has been administered

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

Students also viewed these Databases questions

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago