This organization provides following functionalities• Emergency Care 24x7• Support Groups• Support and Help Through callsAny 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. ▪ Create Entity relationship diagram using any online tool.▪ Draw Relational model in Microsoft office word.▪ Normalize upto 3NF.▪ Create database name as “health facilitator” in SQL server.▪ Create table in SQL with proper metadata. Take screenshot and paste on word file.▪ Insert 10 records in each table and take screenshot and paste on word file▪ Update doctor table to consultant using SQL and take screenshot and paste on word file▪ Add column in nurse table named as working experience. Take screenshot and paste on word file.▪ Update location column in room as ward. Take screenshot and paste on▪ Count number of patients examined by doctor using SQL function. Take screenshot and paste on word file.▪ Display minimum age of patients using SQL functions. Take screenshot and paste on word file.▪ You can also count no. of doctor in your database using SQL function. Take screenshot and paste on word file. This organization provides following functionalitiesEmergency Care 24x7• Support GroupsSupport and Help Through callsAny new Patient is first registered in their database before meeting the doctor. Each Doctor haveID, specialization, age, name, gender and phone no. every doctor have unique ID. The Doctorcan update the data related to the patient upon diagnosis (Including the disease diagnosed andprescription).doctor examined number of patients on daily bases. Patient has unique id, name,age, gender, disease status (admitted, discharged, expired), date and address. Patients withcritical condition are examined by many doctors. This organization also provides rooms facilityfor admitting the patient who is critical. One room can be booked by one patient only and eachroom has room#, location attributes. Rooms are distributed among two categories general andVIP. Apart from doctors, this organization has nurses and ward boy. Each nurse and ward boy isassigned to no of doctor. Nurse and ward boys table can store name, age, gender, and addressand skills. Also, they can be assigned to patients (to take care of them). One nurse can beassigned to no. of patients. The bill is paid by the patient with cash and E-banking. Record ofeach payment made is also maintained by the organization. Payment record saves amountpayable, date and status of payment pending or paid. The record of each call received to providehelp and support to its existing person is also maintained. Each doctor's record is maintained byorganization and no of patient examined by a doctor can be calculated. Organization also keepsrecord 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.Normalize upto 3NF.Create database name as "health facilitator" in SQL server.Create table in SQL with proper metadata. Take screenshot and paste on word file.Insert 10 records in each table and take screenshot and paste on word fileUpdate doctor table to consultant using SQL and take screenshot and paste on word fileAdd column in nurse table named as working experience. Take screenshot and paste onword file.Update location column in room as ward. Take screenshot and paste onCount number of patients examined by doctor using SQL function. Take screenshot andpaste on word file.Display minimum age of patients using SQL functions. Take screenshot and paste onword file.You can also count no. of doctor in your database using SQL function. Take screenshotand paste on word file.

Answered: Image /qna-images/answer/e701528c-be35-4ae8-864a-e104020cd157.jpg

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. Create Entity relationship diagram using any online tool. Draw Relational model in Microsoft office word. Normalize upto 3NF. Create database name as "health facilitator" in SQL server. Create table in SQL with proper metadata. Take screenshot and paste on word file. Insert 10 records in each table and take screenshot and paste on word file Update doctor table to consultant using SQL and take screenshot and paste on word file Add column in nurse table named as working experience. Take screenshot and paste on

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. Create Entity relationship diagram using any online tool. Draw Relational model in Microsoft office word. Normalize upto 3NF. Create database name as "health facilitator" in SQL server. Create table in SQL with proper metadata. Take screenshot and paste on word file. Insert 10 records in each table and take screenshot and paste on word file Update doctor table to consultant using SQL and take screenshot and paste on word file Add column in nurse table named as working experience. Take screenshot and paste on

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

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. ▪ Create Entity relationship diagram using any online tool. ▪ Draw Relational model in Microsoft office word. ▪ Normalize upto 3NF. ▪ Create database name as “health facilitator” in SQL server. ▪ Create table in SQL with proper metadata. Take screenshot and paste on word file. ▪ Insert 10 records in each table and take screenshot and paste on word file ▪ Update doctor table to consultant using SQL and take screenshot and paste on word file ▪ Add column in nurse table named as working experience. Take screenshot and paste on word file. ▪ Update location column in room as ward. Take screenshot and paste on ▪ Count number of patients examined by doctor using SQL function. Take screenshot and paste on word file. ▪ Display minimum age of patients using SQL functions. Take screenshot and paste on word file. ▪ You can also count no. of doctor in your database using SQL function. Take screenshot and paste on word file.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.