Answered step by step
Verified Expert Solution
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
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 appointmentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started