How would I develop a series of communication diagrams to obtain all the appoint

Question

How would I develop a series of communication diagrams to obtain all the appointment records for the patient, Derek Li, as well as the patient’s information from the Appointment System of a private clinic, using the insights given from the below class diagram and their corresponding database tables.

Remark:
(patientID, apptID) is the composite primary key.
patientID is the foreign key referencing to the Patient table.
apptID is the foreign key referencing to the Appointment table.
apptID is the unique key in the Patient-Reserve-Appointment table.

Class Diagram PFWBroker VirtualProxy object With(anOID): Object oid: OID createBroker) getBroker() getRealSubject() materializeSubject() RelationalPFWBroker Patient Relational Broker Patient Proxy AppointmentProxy Appointment RelationalBroker createBroker() patient Name() patientAddress() patient Phone() patientAge() patient Birthdate() create Broker) apptDate() apptTime() apptReason()

Explanation / Answer

Query to display information of patient "Darek Li"

select apptID,apptDate,apptTime,apptReason from Appointment inner join Patient inner join Patient-Schedule-Appointment where Appointment.apptID = Patient-Schedule-Appointment.patientID and patientName = "Derek Li"

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.