Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started