Project Synopsis: ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system.   Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a fifty-dollar fine.   During a visit to the clinic, a patient reports to the secretary and she either puts him in the walk-in queue or in case of patients with existing appointments, checks them in. A Nurse then takes the patient to an examination room and writes down   about her symptoms and other medical issues and then based on each individual patient’s needs may take their blood pressure, temperature, height, and weight and then enters all this information in the computer system.   The clinic system should keep a track of patients’ appointments and change the status accordingly: booked, cancelled, arrived, checked in, checked out, LWT(left without treatment), No show etc. Healthcare is free in Canada and most people are not charged any fee (clinic is paid by the government), however sometime a small fee is charged for items not covered by the government such as Sick notes or fee is charged from the patients who are not covered under the government health coverage (visitors etc.)   Next, the doctor examines the patient and may order some diagnostic tests for the patient (blood work, XRAY, Ultrasound etc). The doctor will enter patient symptoms, her diagnosis and treatment (prescription medicines). The system should have the capability to store all of the above information entered by the doctor for a patient’s visit. The doctor may also refer the patient to a specialist doctor and store this information in the system.   When the results come back from the Laboratory, one of the nurses will review all the reports and enter them in each patients file (electronic file within the clinic system). She may also call a patient to book a follow up appointment with a doctor in case of adverse results.   The clinic runs in two six hour shifts (7a.m to 2p.m) and (2p.m to 8p.m). Manager should be able to schedule doctors, nurses, and secretaries for shifts. Doctors are paid by the government but the Manager is supposed to pay salary to all other employees based on their hours worked. The system should be able to store this information and the manager should be able to generate a bi weekly report for the hours worked by the nurses and secretaries and therefore calculate their salaries (assume reasonable hourly rates for nurses and secretaries).   Project Requirements: Please make reasonable and educated assumptions about missing/ ambiguous information and properly document (in a few words/sentences only) your assumptions and the rationale behind those assumptions.   i. Please create a Conceptual Data Model (using io), containing entities and their relationships as they exist in the problem domain (including any M:M relationships)(N.B NO ATTRIBUTES TO BE DISPLAYED JUST ENTITIES CONNECTED USING RELATIONSHIP SHAPES.)    ii.Please create a Physical (Logical) Data Model using MySQL Workbench® based on the conceptual Create a new schema named GroupxxSchema and then create a physical EER model in it containing the tables with appropriate columns and relationships among these tables (resolved as 1:M only). Assign proper data types to columns and add appropriate keys & constraints. Make sure that all relations are in t3NF.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Project Synopsis:

ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system.

 

Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a fifty-dollar fine.

 

During a visit to the clinic, a patient reports to the secretary and she either puts him in the walk-in queue or in case of patients with existing appointments, checks them in. A Nurse then takes the patient to an examination room and writes down

 

about her symptoms and other medical issues and then based on each individual patient’s needs may take their blood pressure, temperature, height, and weight and then enters all this information in the computer system.

 

The clinic system should keep a track of patients’ appointments and change the status accordingly: booked, cancelled, arrived, checked in, checked out, LWT(left without treatment), No show etc. Healthcare is free in Canada and most people are not charged any fee (clinic is paid by the government), however sometime a small fee is charged for items not covered by the government such as Sick notes or fee is charged from the patients who are not covered under the government health coverage (visitors etc.)

 

Next, the doctor examines the patient and may order some diagnostic tests for the patient (blood work, XRAY, Ultrasound etc). The doctor will enter patient symptoms, her diagnosis and treatment (prescription medicines). The system should have the capability to store all of the above information entered by the doctor for a patient’s visit. The doctor may also refer the patient to a specialist doctor and store this information in the system.

 

When the results come back from the Laboratory, one of the nurses will review all the reports and enter them in each patients file (electronic file within the clinic system). She may also call a patient to book a follow up appointment with a doctor in case of adverse results.

 

The clinic runs in two six hour shifts (7a.m to 2p.m) and (2p.m to 8p.m). Manager should be able to schedule doctors, nurses, and secretaries for shifts. Doctors are paid by the government but the Manager is supposed to pay salary to all other employees based on their hours worked. The system should be able to store this information and the manager should be able to generate a bi weekly report for the hours worked by the nurses and secretaries and therefore calculate their salaries (assume reasonable hourly rates for nurses and secretaries).

 

Project Requirements:

Please make reasonable and educated assumptions about missing/ ambiguous information and properly document (in a few words/sentences only) your assumptions and the rationale behind those assumptions.

 

i. Please create a Conceptual Data Model (using io), containing entities and their relationships as they exist in the problem domain (including any M:M relationships)(N.B NO ATTRIBUTES TO BE DISPLAYED JUST ENTITIES CONNECTED USING RELATIONSHIP SHAPES.) 

 

ii.Please create a Physical (Logical) Data Model using MySQL Workbench® based on the conceptual Create a new schema named GroupxxSchema and then create a physical EER model in it containing the tables with appropriate columns and relationships among these tables (resolved as 1:M only). Assign proper data types to columns and add appropriate keys & constraints. Make sure that all relations are in t3NF.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY