You work in health care, for a company that manages and operates hospitals. You are part of a team tasked with rebuilding the company’s patient registration and scheduling system for all the different hospitals within the company. This system will enable hospital staff to register patients for different tests and procedures – such as X-Rays, CT Scans, surgery, etc. Additionally the system will schedule these patients and hospital staff, including doctors can view these schedules online. As part of the team, you are tasked with developing the domain / business model for the system. To that end, please do the following: 1) Identify all the entities for the system. You need to identify a minimum of 4. If you are doing only 4, please try to cover the core entities of the system. 2) For each entity, figure out the attributes, including the data type of each attribute. Excluding the ID attribute, identify at least 3 attributes. Identify the relationships between the entities and ensure that these relationships are represented as attributes. 3) Create 3 records / rows for each entity. You can use a spreadsheet (with a separate worksheet for each entity). Instead of a spreadsheet, you want to use the actual SQL statement (insert), that’s fine also. Ideally, you will have values that satisfy the select statement in #4. 4) Write the Select statement that does the following: Retrieves patientname and hospitalname for all patients who are registered to undergo a CT Scan.

1) Identify all the entities for the system. You need to identify a minimum of 4. If you are doing only 4, please try to cover the core entities of the system.

Answer 1: Following are the four key entities of the system as below

a. Admission system of the healthcare.

b. Nursing system of the healthcare

c. Doctors panel of the healthcare

d. Laboratory Investigation system of the healthcare

2) For each entity, figure out the attributes, including the data type of each attribute. Excluding the ID attribute, identify at least 3 attributes. Identify the relationships between the entities and ensure that these relationships are represented as attributes.

Answer 2: Following are the three attributes of each of the above four entities of the organization as below

Attributes

Admission System

Nursing System

Doctors System

Lab Investigation System

1

Disease of the patient

Patient boarding room

Disease Status

List of Lab Investigation

2

Age of the patient

Nursing treatments

Investigation Plan

Date of Investigation

3

Doctor for the patient

Patient health primary checks

Treatment Plan

Payment of investigations

3) Create 3 records / rows for each entity. You can use a spreadsheet (with a separate worksheet for each entity). Instead of a spreadsheet, you want to use the actual SQL statement (insert), that’s fine also. Ideally, you will have values that satisfy the select statement in #4.

Answer 3:

Admission Entity

Records S. No.

Patient Name

Disease

Hospital Name

Rom no.

Condition

Record -1

ABC

Heart Problem

BCD Hospital

104

Unstable

Record-2

DEF

Lungs Problem

PQR Hospital

205

Stable

Record-3

EFG

Kidney Problem

BRT Hospital

306

Unstable

Nursing System Entity

Records S. No.

Patient Name

Disease

Doctors Name

Rom no.

Condition

Record -1

ABC

Heart Problem

Doct-1

104

OK

Record-2

DEF

Lungs Problem

Doct-2

205

OK

Record-3

EFG

Kidney Problem

Doct-3

306

Not OK

Doctor System Entity

Records S. No.

Patient Name

Disease

Doctors Name

Rom no.

Status

Record -1

ABC

Heart Problem

Doct-1

104

Doctor seen

Record-2

DEF

Lungs Problem

Doct-2

205

Doctor Seen

Record-3

EFG

Kidney Problem

Doct-3

306

Doctor to see patient

Lab Investigation System Entity

Records S. No.

Patient Name

Disease

Lab Investigations

Rom no.

Status

Record -1

ABC

Heart Problem

Angiography

104

Not done

Record-2

DEF

Lungs Problem

X-rays / Scan

205

Done

Record-3

EFG

Kidney Problem

Kidney test

306

Not Done

Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.

CategoriesUncategorized