Create an er diagram based on the case study

Assignment Help Database Management System

Reference no: EM133822135 , Length: word count:1500

Database Fundamentals

Assessment: Introduction
In this assessment, you are required to write a report of no more than 1500 words. You need to create an ER diagram based on the case study given and construct a written specification.

Case Study:
Victorian Hospital is a private hospital that includes a few departments, rooms, doctors, nurses, compounders, and other staff working in the hospital. Patients who have different kinds of ailments come to the hospital and get checkup done from the concerned doctors. If required they are admitted to the hospital and discharged after treatment. Book Our Writers Now!

The aim of this case study is to design and develop a database for the hospital to maintain the records of various departments, rooms, and doctors in t he hospital. It maintains records of the regular patients.

In hospital, there are many departments like Emergency, Dental, I.C.U., Operation Theater, Laboratory, M.R.I. and Cancer Department. There is an OPD where patients come and get a card (that is, entry card of the patient) for check up from the concerned doctor. After making entry in the card, they go to the concerned doctor's room and the doctor checks up their ailments. According to the ailments, the doctor either prescribes medicine or admits the patient in the concerned department. The patient may choose either private or general room according to his/her need. But before getting admission in the hospital, the patient has to fulfill certain formalities of the hospital like room charges.

Table Description:
DEPARTMENT: This table consists of details about the various departments in the hospital. The information stored in this table includes depart ment name, department location, and facilities available in that department.

DOCTORS: This table stores information about all the doctors working for the hospital and the departments they are associated with. Each doct or is given an identity number starting with DR or DC prefixes only.

PATIENT: Details of regular patients are stored in this table. Information stored includes date of visit, diagnosis, treatment, medicine recomme nded, status of treatment, etc.

ROOM_DETAILS: It contains details of all rooms in the hospital. The details stored in this table include room number, room type (general or pri vate), status (whether occupied or not), if occupied, then patient number, patient name, charges per day, etc.

You are hired for this project. After the first meeting with the board members, you decide a database system will serve as backbone for designing the system.

Activity 1: Draw a detailed ER diagram
You can use the description in the case study for the ER diagram.

Activity 2: Write Specification from Entity Relationship Diagram

Compose the operational guidelines for the Entity-Relationship Diagram in activity 1. Exclude attribute descriptions and focus on specifying all cardinalities, participation constraints, and identifying strong and weak relationships. Please use plain English rather than technical database terminology.

The format structure for the report
You are required to follow the following structure for this assessment:
Introduction
Task 1
Task 2
Conclusion

Reference no: EM133822135

Questions Cloud

Implement the normalization process on unstructured tables : Implement the normalization process on unstructured tables - Create a relational schema and demonstrate the First Normal Form (1NF), Second Normal Form (2NF)

Compute the ending inventory and cogs at september thirty : Compute the ending inventory and COGS at September 30 on each of the following on periodic bases. Explain the above with numerical examples.

What is the etiology of the selected sti : What is the pathophysiology of one STI? What is the etiology of the selected STI? What are the clinical manifestations of the selected STI?

What is a scalable clustering algorithm : What are the characteristics of data? What is a scalable clustering algorithm? How do you choose the right algorithm?

Create an er diagram based on the case study : ITDA1001 Database Fundamentals, Victorian Institute of Technology - create an ER diagram based on the case study given and construct a written specification

How are the key participants portrayed : How is reality represented? How are the key participants portrayed? How is the problem defined? Who is assigned responsibility for this issue?

Describe the general mood of the short film : Describe the general mood of the short film and how it changes through the film? Describe the mood captured through sound and/or music throughout the film.

Illustrate each with a sample case that you find : Illustrate each with a sample case that you find and discuss their urine output, symptoms and blood values or other tests that are abnormal.

What do you think the message is hoping to accomplish : What do you think the message is hoping to accomplish? Why do you think the message fails to be persuasive? Be specific.

User Account

All Pages