Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question S.2.3 Requirment- ER diagram 1. Knox private Hospital contracted with GeenIT services to develop and design their hospital database, the hospital IT Manager provided
Question S.2.3
Requirment- ER diagram
1. Knox private Hospital contracted with GeenIT services to develop and design their hospital database, the hospital IT Manager provided the following business rules to the GreenIT services software developer: User view 1 requirement: Patients are identified by a PatientlD, and their names, addresses, and ages must be recorded. User view 2 requirement : Doctors are identified by a DoctorlD. For each doctor, the name, specialty, and years of experience must be recorded. User view 3 requirement : Every patient has a primary physician/doctor. Every doctor has at least one patient. User view 4 requirement_ Doctors prescribe drugs for patients. A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription can have more than one drug. User view 5 requirement: For each drug, identified by DruglD and the trade name and formula must be recorded User view 6 requirement: Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another. User view 7 requirement: Each pharmacy has a unique name, address, and phone number. Complete the information-level design for the database that satisfies the above constraints and user view requirements. In order to complete this information-level design you are required to answer questions given below 1(a) (f) 1Step 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