Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an EERD containing all attributes of the data requirements for situation below using the Unified Modelling Language (UML) notation: State Hospital requests your consultation

image text in transcribed

Create an EERD containing all attributes of the data requirements for situation below using the Unified Modelling Language (UML) notation: State Hospital requests your consultation expertise to design the relational database system that provides information on their stakeholders during lockdown. Basically, each stakeholder has IC, name, address, phone number, email and gender. The following are the definition of generalization hierarchy containing Doctor, Nurse and Patient. Doctor has staff ID, salary, hire date, and expertise. Nurse has to work overtime during lockdown, especially when the cases rise up. Hence, other than staff ID, salary and hire date, nurses also have overtime allowance. Meanwhile, patient must take the swab test before they can be placed in HS. Thus, patient has swab test ID, date, and test result. Each sample must be submitted to lab in certain date, and they will receive the result in three to four days after the test. If the sample test is positive, case number will be generated and all symptoms will be recorded. Stakeholder (except the outpatients) take one or many swab test in HS. Every swab test has test ID, name, conducted lab and person in charge

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

Online Systems For Physicians And Medical Professionals How To Use And Access Databases

Authors: Harley Bjelland

1st Edition

1878487442, 9781878487445

More Books

Students also viewed these Databases questions

Question

=+what information would you need about the compact disc industry?

Answered: 1 week ago