Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
Related questions
Question

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

 

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: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
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
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
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Dataset
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS