Write specification from entity relationship diagram

Assignment Help Database Management System

Reference no: EM133823582

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.

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. Get Assistance Now!!

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

Submission Guidelines
You need to answer all the questions, use appropriate diagrams where required and submit in one report (.docx/pdf) file.
Your report needs to follow the naming convention below:
"Assignment 1_X_YY.docx" where X is your name and Y is your student ID.
The Late penalty applies on late submission, 10% per day would be deducted.
Incidence of plagiarism will not be tolerated and would be penalized.

Reference no: EM133823582

Questions Cloud

Examine the database established during activity : Examine the database established during Activity and deliberate on the various forms of user access permissions necessary to uphold the database's integrity

Create a relational schema and demonstrate the 3nf : Create a relational schema and demonstrate the Third Normal Form (3NF) for the database and table design you had created in your first assignment

New procedure for production line : You have just selected eight of your employees to sit on a team to propose a new procedure for the production line,

Five critical success factors : What are the top five critical success factors that the company has to consider as it initiates the project?

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

Performance improvement evaluations : As a Health Care Manager, you will be directly involved in risk management issues, performance improvement evaluations, and the peer review process.

Through the lens of organizational behavior : Through the lens of Organizational Behavior, the Office of Graduate Studies exemplifies complex interplays between leadership styles, cultural values,

Accurate statistics to make informed decisions : Given that the CBO relies heavily on accurate statistics to make informed decisions, how do you think changes in data patterns or outdated statistics

Organizational culture : The culture within the Office of Graduate Studies can be described as Collaborative and Academic-Centric and is characterized by collaboration,

User Account

All Pages