Attached (123) is the E-R diagram. Using the E-R diagram as the main reference point, complete this:Describe cardinalities between each relation Describe connections between each relationExplain why the PatientMedicine and PatientAllergy relations were created.The figure attached again (901)shows an example of how you can describe cardinalities and connections between relations.An example of how you can write descriptions of cardinalities and connections between relations: Doctor – PatientA doctor can admit many patients or doesn’t need to admit a patient. A patient must be associated with just one doctor and when a patient comes to the hospital, the patient must be assigned to a doctor. One order record must beassociated with a maximum of oneCustomerA customer can have many orderscustomerOrderPK CustiDPKOrderiDPK,FKI CustIDLNameFNameOrdDateAn order record must have a validA customer does not need to havecustomer and it must NOT be Nullan order to be a customer DoctorPatientSpecialtyPatientAllergyBe•AllergyIDPatientIDPatientIDNamePhoneEmailAddressAddedbateDoctorIDSpecialtyNumber|-SpecialtyNameDoctorID* NamePhone- SpecialtyNumber-SupervisorAllergyALlergyID-AllergyNanePatientMedicineAppointmentID-MedicineIDAppointmentAppointmentID1-DoctorIDPatientIDAppointmentDateBloodPressureWeightTreatmentNotesMedicineMedicineIDHedicinelame

⦁ Cardinality refers to the relationship on instances with other tables or relations. ⦁…

Answered: Attached (123) is the E-R diagram.…

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...

Related questions

Question

Attached (123) is the E-R diagram. Using the E-R diagram as the main reference point, complete this:

Describe cardinalities between each relation
Describe connections between each relation
Explain why the PatientMedicine and PatientAllergy relations were created.
The figure attached again (901)shows an example of how you can describe cardinalities and connections between relations.
An example of how you can write descriptions of cardinalities and connections between relations:
- Doctor – Patient
- A doctor can admit many patients or doesn’t need to admit a patient.
- A patient must be associated with just one doctor and when a patient comes to the hospital, the patient must be assigned to a doctor.