Activity 1 is allotted PATIENT PatientRecord Number (PK) FirstName Last Name SSN CONSULTATION Consultation (PK) Patient RecordNumber (PKI) Physician (FK2) DateFirstConsult OFFICE PHYSICIAN Physiciani (PK) FirstName Last Name SSN DOB Gender Address DateofHire oil Specialization HighestDegree is allotted to DOB supervised by Gender Address PhysicianiD (FK) > supervises has been prescribed M is prescribed to prescribes authorized by PRESCRIPTION Identify suitable attributes for the PRESCRIPTION and OFFICE entities Select PKs for PRESCRIPTION and OFFICE Implement the 1-N maximum cardinality relationships between PATIENT and PRESCRIPTION as well as between PHYSICIAN and PRESCRIPTION Implement the 1:1 maximum cardinality relationship between PHYSICIAN and OFFICE Note: You could start by sketching your modifications to the diagram on a whiteboard or sheet of paper - once you have mastered the concepts, you could proceed to developing the E-R diagram using software such as MS Visio or Draw.io. Develop further the E-R diagram from the previous activity Identify other entities that could be related to the four we have seen (PATIENT, PHYSICIAN, PRESCRIPTION, OFFICE), in the context of a healthcare facility database implementation (e.g. NURSE, DRUG, DRUG_INGREDIENT, PATIENT_ALLERGY, PHARMACY ......) Please think about the attributes/properties relevant for each entity. Please think about relationships between these entities (for example, a nurse may work with MANY physicians and a PHYSICIAN may work with MANY nurses; a drug may be part of MANY prescriptions and a prescription can contain MANY drugs ....) Activity 1 is allotted PATIENT PatientRecord Number (PK) FirstName Last Name SSN CONSULTATION Consultation (PK) Patient RecordNumber (PKI) Physician (FK2) DateFirstConsult OFFICE PHYSICIAN Physiciani (PK) FirstName Last Name SSN DOB Gender Address DateofHire oil Specialization HighestDegree is allotted to DOB supervised by Gender Address PhysicianiD (FK) > supervises has been prescribed M is prescribed to prescribes authorized by PRESCRIPTION Identify suitable attributes for the PRESCRIPTION and OFFICE entities Select PKs for PRESCRIPTION and OFFICE Implement the 1-N maximum cardinality relationships between PATIENT and PRESCRIPTION as well as between PHYSICIAN and PRESCRIPTION Implement the 1:1 maximum cardinality relationship between PHYSICIAN and OFFICE Note: You could start by sketching your modifications to the diagram on a whiteboard or sheet of paper - once you have mastered the concepts, you could proceed to developing the E-R diagram using software such as MS Visio or Draw.io. Develop further the E-R diagram from the previous activity Identify other entities that could be related to the four we have seen (PATIENT, PHYSICIAN, PRESCRIPTION, OFFICE), in the context of a healthcare facility database implementation (e.g. NURSE, DRUG, DRUG_INGREDIENT, PATIENT_ALLERGY, PHARMACY ......) Please think about the attributes/properties relevant for each entity. Please think about relationships between these entities (for example, a nurse may work with MANY physicians and a PHYSICIAN may work with MANY nurses; a drug may be part of MANY prescriptions and a prescription can contain MANY drugs ....)
