30 likes | 262 Views
Class Diagram (brief) for Clinic Database System. 1) Write multiplicity business rules for associations with specified multiplicity. 2) Write multiplicity where missing by using the business rules below. (1) - A physician can fill many patient
E N D
Class Diagram (brief) for Clinic Database System 1) Write multiplicity business rules for associations with specified multiplicity. 2) Write multiplicity where missing by using the business rules below. (1) - A physician can fill many patient records, and each record is filled by a particular physician. - A nurse can fill many patient records, and each record can be filled by a different nurse. - Each patient can have many patient records, and each record belongs to a single patient. fills 1 Examination Room Physician 1 1 1 used for performs fills * * * 1 Nurse Prescription Examination * assists in * fills * * applied on gets 1 1 * * 1 * < has Patient Record Patient MIS 3500, Exercises Task 1, Multiplicity • Each examination is applied on a particular patient, and each patient can • have many examinations. • An examination room is used in many examinations, and each examination takes • place in one room. (2) - Each physician fills many prescriptions, and each prescription is filled by one physician. - A patient can get many prescriptions, and each prescription is for one patient. - A physician can perform many examinations, and each examination is done by one physician. - A nurse can assist in many examinations, and each examination is assisted by one nurse.
Worker WorkerID Clerk ClerkID WorkOrder WONo • Task DateStart ExpEndDate EndDate Solved y/n Hours Parts Task 2. MIS 3500 * Class exercise on creating Class Diagram (A) 1 makes * Complaint ComplaintNo • Description • Date/Time * < fills 1 Renter RenterID * * occupies Apartment AptID 1 cited in * • Apartment • Occupation • DateIn • DateOut * 1 responds to * 1 ProblemType ProblemID ProblemName • ProblemSpecs Manager ManagerID 1 issues * employs 1 *
Clerk ClerkID Worker WorkerID WorkOrder WONo • Task WorkerID ManagerID DateStart ExpEndDate EndDate Solved y/n Hours Parts MIS 3500 * Class exercise on creating Schema (B) Complaint ComplaintNo RenterID ClekID AptID • Description • Date/Time • ManagerID • ProblemID 1 * * 1 Apartment AptID 1 1 1* Renter RenterID * * • Apartment • Occupation • RenterID • AptID • DateIn • DateOut * ProblemType ProblemID ProblemName • ProblemSpecs * * Manager ManagerID 1 1 1 * 1 *