PHYSICIAN OFFICE CONSULTATION NURSE PhysicianID (PK) OfficelD (PK) NurselD (PK) o FirstName ConsultationID (PK) FirstName Location PatientID (FK1) 버 ROO LastName SSN RoomNo ++ PATIENT PhysicianID...



Construct a context and data flow diagram level-0 supporting the logical design/implementation of the implemented database model


PHYSICIAN<br>OFFICE<br>CONSULTATION<br>NURSE<br>PhysicianID (PK)<br>OfficelD (PK)<br>NurselD (PK)<br>o FirstName<br>ConsultationID (PK)<br>FirstName<br>Location<br>PatientID (FK1)<br>버 ROO<br>LastName<br>SSN<br>RoomNo<br>++<br>PATIENT<br>PhysicianID (FK2)<br>LastName<br>SizeSqFt<br>PatientID (PK)<br>DateFirstConsult<br>NUR SCH<br>SSN<br>DOB<br>Techology<br>FirstName<br>버 Gender<br>DOB<br>SchedID (PK)<br>LastName<br>is supervised by<br>Gender<br>OH Address<br>PhysicianID (FK1)<br>SSN<br>supervises<br>O<br>Address<br>Date Hired<br>NurseID (FK2)<br>%23<br>Specialization<br>DOB<br>StartTime<br>OfficeID (FK1)<br>Gender<br>PHARMACY<br>HighestDegree<br>EndTime<br>PRESCRIPTION<br>Address<br>OfficeID (FK1)<br>PharmacyID (PK)<br>Phone<br>PrescriptionID (PK)<br>NPICode<br>Primarylns<br>PresDate<br>Name<br>PhysicianID (FK)<br>PatientID (FK1)<br>DRUG INGDT<br>Address<br>PhysicianID (FK2)<br>PRES DRUG<br>DrugingdtiD (PK)<br>Phone<br>PharmacylD (FK3)<br>Fax<br>DrugID (FK1)<br>PresDrugID (PK)<br>IngredientID (FK2)<br>PrescriptionID (FK1)<br>Quantity<br>DrugID (FK2)<br>DRUG<br>Unit<br>Dosage<br>PAT DRUG_ALGY<br>DrugStartDate<br>DrugID (PK)<br>INGREDIENT<br>DrugEndDate<br>NatDrugCode<br>IngredientID (PK)<br>PatDrugAlgylD (PK)<br>Refills<br>s<br>PropName<br>Name<br>PatientID (FK1)<br>NonPropName<br>UNIICode<br>DrugID (FK2)<br>#ILabelerName<br>AlgyDate<br>StartDate<br>Severity<br>ActionTaken<br>Generated using Draw.io (www.draw.io)<br>is prescriba<br>allotted<br>is allotted to<br>is prescr<br>

Extracted text: PHYSICIAN OFFICE CONSULTATION NURSE PhysicianID (PK) OfficelD (PK) NurselD (PK) o FirstName ConsultationID (PK) FirstName Location PatientID (FK1) 버 ROO LastName SSN RoomNo ++ PATIENT PhysicianID (FK2) LastName SizeSqFt PatientID (PK) DateFirstConsult NUR SCH SSN DOB Techology FirstName 버 Gender DOB SchedID (PK) LastName is supervised by Gender OH Address PhysicianID (FK1) SSN supervises O Address Date Hired NurseID (FK2) %23 Specialization DOB StartTime OfficeID (FK1) Gender PHARMACY HighestDegree EndTime PRESCRIPTION Address OfficeID (FK1) PharmacyID (PK) Phone PrescriptionID (PK) NPICode Primarylns PresDate Name PhysicianID (FK) PatientID (FK1) DRUG INGDT Address PhysicianID (FK2) PRES DRUG DrugingdtiD (PK) Phone PharmacylD (FK3) Fax DrugID (FK1) PresDrugID (PK) IngredientID (FK2) PrescriptionID (FK1) Quantity DrugID (FK2) DRUG Unit Dosage PAT DRUG_ALGY DrugStartDate DrugID (PK) INGREDIENT DrugEndDate NatDrugCode IngredientID (PK) PatDrugAlgylD (PK) Refills s PropName Name PatientID (FK1) NonPropName UNIICode DrugID (FK2) #ILabelerName AlgyDate StartDate Severity ActionTaken Generated using Draw.io (www.draw.io) is prescriba allotted is allotted to is prescr

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here