Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw the appropriate ER/EER representation of this hospital databases management system A large company with hospital branches is looking to launch a website for hospitals

Draw the appropriate ER/EER representation of this hospital databases management system

image text in transcribed A large company with hospital branches is looking to launch a website for hospitals in the Gulf Cooperation Council countries. You need to analyze the company's data requirements described below and develop a database system. The website visitors should be able to search for hospital using different options, including: - The name of the hospital - The type of hospital (e.g. trauma centers, rehabilitation hospitals, children's hospitals) - The type of the department in the hospital (e.g. Emergency, Surgery ) - The location of the hospital Each hospital has a name and unique address. We need also to record the details of the hospital's owner that includes first and last name, CPR, phone number. A hospital may have many branches in GCC, and each branch has an address that is unique for the hospital only. The patient's addresses are composed of a phone number and the city name to identify the branch in which he is being treated. In addition, we need to record the following information: the telephone number of the branch, the employee who manages the branch, the number and details of the employees working in each branch. Each employee has CPR, name, unique ID, Gender, DOB, Adress, Phone, Email , Qualifications_ . job role and can work in one branch only. Where A doctor can manage multiple departments and a department is managed by a single doctor, A doctor can belong to multiple departments and a department can have multiple doctors, One nurse can assist multiple doctors, and each doctor can have multiple assisting nurses, One doctor can conduct multiple appointments and each appointment is conducted by a single doctor The website visitors can view the different serves offered by each branch. The website should show for each serve: the name and price and Doctor Name. The same serve name can be available in different branches, but it should be unique for the branch. Once the visitor decides to make an appointment, the visitor should first register on the website using a CPR (will be used as username), password, name, Date of Birth, Email. Adress and telephone number. When the registration is completed, then the patient can proceed with the appointment and a unique appointment number will be provided. In addition, it is important to record the appointment date and time and Doctor Name. Where one patient can attend multiple appointments and each appointment is attended by a single patient And after the appointment the patient can login again and post any reviews on that appointment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions