Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
• Support Groups • Support and Help Through calls y new Patient is first registered in their database before meeting the doctor. Each Doctor have specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor update the data related to the patient upon diagnosis (Including the disease diagnosed and scription).doctor examined number of patients on daily bases. Patient has unique id, name, , gender, disease status (admitted, discharged, expired), date and address.Patients with critical dition are examined by many doctors. This organization also provides rooms facility for nitting the patient who is critical. One room can be booked by one patient only and each room room#, location attributes. Rooms are distributed among two categories general and VIP. art from doctors, this organization has nurses and ward boy. Each nurse and ward boy is igned to no of doctor. Nurse and ward boys table can store name, age, gender, and address I skills. Also, they can be assigned to patients (to take care of them). One nurse can be igned to no. of patients. The bill is paid by the patient with cash and E-banking. Record of h payment made is also maintained by the organization. Payment record saves amount vable, date and status of payment pending or paid. The record of each call received to provide p and support to its existing person is also maintained. Each doctor's record is maintained by anization and no of patient examined by a doctor can be calculated. Organization also keeps ord of expiries and no of expired patients can be calculated. . Create Entity relationship diagram using any online tool. . Draw Relational model in Microsoft office word. 2NE

• Support Groups • Support and Help Through calls y new Patient is first registered in their database before meeting the doctor. Each Doctor have specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor update the data related to the patient upon diagnosis (Including the disease diagnosed and scription).doctor examined number of patients on daily bases. Patient has unique id, name, , gender, disease status (admitted, discharged, expired), date and address.Patients with critical dition are examined by many doctors. This organization also provides rooms facility for nitting the patient who is critical. One room can be booked by one patient only and each room room#, location attributes. Rooms are distributed among two categories general and VIP. art from doctors, this organization has nurses and ward boy. Each nurse and ward boy is igned to no of doctor. Nurse and ward boys table can store name, age, gender, and address I skills. Also, they can be assigned to patients (to take care of them). One nurse can be igned to no. of patients. The bill is paid by the patient with cash and E-banking. Record of h payment made is also maintained by the organization. Payment record saves amount vable, date and status of payment pending or paid. The record of each call received to provide p and support to its existing person is also maintained. Each doctor's record is maintained by anization and no of patient examined by a doctor can be calculated. Organization also keeps ord of expiries and no of expired patients can be calculated. . Create Entity relationship diagram using any online tool. . Draw Relational model in Microsoft office word. 2NE

Fundamentals of Information Systems
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 3PSE
See similar textbooks
icon
Related questions
Question
This organization provides following functionalities • Emergency Care 24x7 • Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address.Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor. Nurse and ward boys table can store name, age, gender, and address and skills. Also, they can be assigned to patients (to take care of them). One nurse can be assigned to no. of patients. The bill is paid by the patient with cash and E-banking. Record of each payment made is also maintained by the organization. Payment record saves amount payable, date and status of payment pending or paid. The record of each call received to provide help and support to its existing person is also maintained. Each doctor's record is maintained by organization and no of patient examined by a doctor can be calculated. Organization also keeps record of expiries and no of expired patients can be calculated. QI. Create Entity relationship diagram using any online tool. Q2. Draw Relational model in Microsoft office word. Q3. Normalize upto 3NF.
Transcribed Image Text:This organization provides following functionalities • Emergency Care 24x7 • Support Groups Support and Help Through calls Any new Patient is first registered in their database before meeting the doctor. Each Doctor have ID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctor can update the data related to the patient upon diagnosis (Including the disease diagnosed and prescription).doctor examined number of patients on daily bases. Patient has unique id, name, age, gender, disease status (admitted, discharged, expired), date and address.Patients with critical condition are examined by many doctors. This organization also provides rooms facility for admitting the patient who is critical. One room can be booked by one patient only and each room has room#, location attributes. Rooms are distributed among two categories general and VIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy is assigned to no of doctor. Nurse and ward boys table can store name, age, gender, and address and skills. Also, they can be assigned to patients (to take care of them). One nurse can be assigned to no. of patients. The bill is paid by the patient with cash and E-banking. Record of each payment made is also maintained by the organization. Payment record saves amount payable, date and status of payment pending or paid. The record of each call received to provide help and support to its existing person is also maintained. Each doctor's record is maintained by organization and no of patient examined by a doctor can be calculated. Organization also keeps record of expiries and no of expired patients can be calculated. QI. Create Entity relationship diagram using any online tool. Q2. Draw Relational model in Microsoft office word. Q3. Normalize upto 3NF.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS