Using the relations ATTACHED, normalize your relations into first, second, and third normal forms. First, KINDLY describe the changes required to your relations to meet the standard of the first 1NF and then 2NF and lastly 3NF. Then, you should provide an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labelled. Hint: Remember that in the hospital software system, the “Patient” relation includes the “medicines” attribute and the “Appointment” relation includes the “allergies” attribute. Allergies describe a list of any known allergies and medicines describe a list of medicines prescribed for a patient.   Please add:   Define or describe the changes required to get the relations into the 1st normal form. Define or describe the changes required to get the relations into the 2nd normal form. Include an Entity Relationship diagram in the 3rd normal form. The primary and foreign keys, at a minimum, are defined for each relation in the Entity-Relationship diagram. In an Entity Relationship diagram that details the relationships between Relations.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Using the relations ATTACHED, normalize your relations into first, second, and third normal forms.

First, KINDLY describe the changes required to your relations to meet the standard of the first 1NF and then 2NF and lastly 3NF.

Then, you should provide an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labelled.


Hint: Remember that in the hospital software system, the “Patient” relation includes the “medicines” attribute and the “Appointment” relation includes the “allergies” attribute. Allergies describe a list of any known allergies and medicines describe a list of medicines prescribed for a patient.

 

Please add:

 

  • Define or describe the changes required to get the relations into the 1st normal form.
  • Define or describe the changes required to get the relations into the 2nd normal form.
  • Include an Entity Relationship diagram in the 3rd normal form.
  • The primary and foreign keys, at a minimum, are defined for each relation in the Entity-Relationship diagram.
  • In an Entity Relationship diagram that details the relationships between Relations.
Appointment
AppointmentlD
Number
Belong to
Made by
DoctorID
Number
PatientID
Number
Patient-Appointment
One-to-Many
relationship
Doctor-Appointment
One-to-Many
relationship
AppointmentDate
Date
BloodPressure
Number
Weight
TreatmentNotes
Number
Text
PATIENT
Medicines
Тext
Makes
PatientID
Number
DOCTOR
%23
DoctorID
Ask for
Number
Name
Тext
Treat
Phone
Number
Email
Тext
Name
Тext
Doctor to Patient
Address
Тext
Work with
Phone
Number
Treated by
One-to-Many
relationship
SpecialityNo
Speciality
AddedDate
Date
Number
Allergies
DoctorID
Тext
Тext
Number
HeadDoctorID
Number
Doctor-Doctor
Manager of
One-to-Many Unary
relationship
Transcribed Image Text:Appointment AppointmentlD Number Belong to Made by DoctorID Number PatientID Number Patient-Appointment One-to-Many relationship Doctor-Appointment One-to-Many relationship AppointmentDate Date BloodPressure Number Weight TreatmentNotes Number Text PATIENT Medicines Тext Makes PatientID Number DOCTOR %23 DoctorID Ask for Number Name Тext Treat Phone Number Email Тext Name Тext Doctor to Patient Address Тext Work with Phone Number Treated by One-to-Many relationship SpecialityNo Speciality AddedDate Date Number Allergies DoctorID Тext Тext Number HeadDoctorID Number Doctor-Doctor Manager of One-to-Many Unary relationship
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY