Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database Design for Covid-19 Vaccination Centers. The Ministry of Health is interested in keeping track of all the records of the vaccination centers located across

image text in transcribed

Database Design for Covid-19 Vaccination Centers. The Ministry of Health is interested in keeping track of all the records of the vaccination centers located across the country to provide the vaccine to the people. Thus, the analysis team worked with the business team to agree on certain specifications: * Each center has a location, an id, and the maximum number of patients can accommodate per day. * A staff member has an id, a given name, a phone number, and whether he/she is a doctor or nurse. The staff who are running the centers can belong to only one center. * A patient has an id, a phone number, a history of diseases, and whether he/she is a smoker or not. * The patient can book an appointment at any center during a specific date and time. * The appointment has the status (if the patient presents at the specific date and time), type of vaccine, and the staff member who administered the dose. Draw a single ER diagram that represents the specifications listed above

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

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions