I need crow's foot diagram for my ms sql server hospital database project. I add the business rules and the assets I created below. Business Rules A patient can only visit a doctor. A doctor can examine many patients. An examination can be done by a doctor. A doctor can do multiple exams. A patient can request more than one exam from the doctor. Each staff member can only have one title. Some staff members may not have a title. A hospital can employ more than one doctor A doctor can work in a single hospital. A patient can give more than one test. Each assay can only be given by one patient. A prescription is for one patient only. A patient may have more than one prescription. It can contain many drugs in one prescription. The same medicine can be prescribed in many prescriptions. Only one patient can stay in a ward. More than one patient can stay in each room. A patient can stay in only one room. By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful for everything
I need crow's foot diagram for my ms sql server hospital database project. I add the business rules and the assets I created below. Business Rules A patient can only visit a doctor. A doctor can examine many patients. An examination can be done by a doctor. A doctor can do multiple exams. A patient can request more than one exam from the doctor. Each staff member can only have one title. Some staff members may not have a title. A hospital can employ more than one doctor A doctor can work in a single hospital. A patient can give more than one test. Each assay can only be given by one patient. A prescription is for one patient only. A patient may have more than one prescription. It can contain many drugs in one prescription. The same medicine can be prescribed in many prescriptions. Only one patient can stay in a ward. More than one patient can stay in each room. A patient can stay in only one room. By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful for everything
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
I need crow's foot diagram for my ms sql server hospital
Business Rules
A patient can only visit a doctor.
A doctor can examine many patients.
An examination can be done by a doctor.
A doctor can do multiple exams.
A patient can request more than one exam from the doctor.
Each staff member can only have one title.
Some staff members may not have a title.
A hospital can employ more than one doctor
A doctor can work in a single hospital.
A patient can give more than one test.
Each assay can only be given by one patient.
A prescription is for one patient only.
A patient may have more than one prescription.
It can contain many drugs in one prescription.
The same medicine can be prescribed in many prescriptions.
Only one patient can stay in a ward.
More than one patient can stay in each room.
A patient can stay in only one room.
By the way, Please alert me if you think I have made the relational diagram wrong. I'm so grateful for everything
Transcribed Image Text:Clinic
* Clinic_ID
Hospital
* HospitalID
Personnel
* PersonnelID
Examination_ID
Pers_Name
Personnel_ID
Clinic_Price
Pers_Surname
Superscription
Phone_Number
Pers Address
Phone_Number
Doctor
Pers_Birth_Day
Fax
Clinic_Personnel
Pers_Phone_Number
Hospital Address
Clinic_Name
Diploma_Number
Tax_Number
Education
Trade_Name
Pers_TC
Ownerships
Pers_Email
Superscription
Clinic_ID
Medicine
Registration_Number
* Medicine_ID
Rooms
Medicine_Name
* Room_ID
Medicine_Type
Clinic_ID
Prospectus
Room_Capacity
Packaging
Туре
Examination
Medication_Use
Room_No
* Examination_ID
Equipment
Personnel_ID
Patient_ID
Patient_ID
Recipe
* Recipe_ID
Test_ID
Complaint
Medicine_ID
Examination_Date
Patient_ID
Examination_Diagnosis
Patient
oo/
Examination_Result
co
Examination_ID
* Patient_ID
Patient_Name
Test
Patient_Surname
* Test_ID
Patient_Address
Test Price
Patient_Phone
Test Type
Patient Job_Phone
Test Detail
Patient_TC
Test Date
Patient_Birth_Day
Examination_ID
Patient_Gender
Patient_Email
Patient_Tax_Nu
Transcribed Image Text:Examination
Date
RecipelD
PatientID
Complaint
Examination
Diagnosis
ExaminationID
Examination
PersonnellD
Result
Examination
PatientID
Recipe
Write
ExaminationlD
TestPrice
TestID
M
Belongs To
RecipelD
M
M-
M
Test
M
MedicinelD
TestDate
TestDetail
TestType
Contain
Done
Packaging
Examine
Gets
MedicineType
MedicationUse
Medicine
ClinicID
ExaminationID
ClinicPrice
Prospectus
M
PhoneNumber
Clinic
MedicineName
MedicinelD
Doctors
ClinicPersonnel
ClinicName
RegistrationNumber
PersSurname
PatientSurname
PersAddress
PatientID
PersName
PatientBirtDay
PersBirthDay
Personnel
PatientTC
PersID
Patient
PatientEmail
PersPhoneNumber
ClinicID
PatientTaxNu
M
PatientName
DiplomaNumber
Email
PatientGender
PatientAddress
TC Number
Education
PatientJobPhone
Superscription
PatientPhone
M
Works
Has
Stay
PersonnellD
PhoneNumber
Ownership
HospitallD
PatientID
Hospital
TradeName
ClinicID
RoomNo
Fax
Superscription
Rooms
Address
RoomCapacity
Туре
TaxNumber
RoomlD
CliniclD
Equipment
00
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education