ASSIGNMENT 3

NAME: SHIVA KUMAR REDDY BANDI
STUDENT ID: 10000120422
COURSE: CMP 552 ANALYSIS MODELING AND DESIGN
HOMEWORK NO: 3
DATE: 11/09/2014
TITLE: CONTEXT AND CLASS DIAGRAMS

1. Draw a context diagram and level-0 diagram for the pharmacy at Mercy Hospital fills medical prescriptions for all Patients and distributes these medications to the nurse station responsible for the patient's care. Medical prescriptions are written by doctors ad sent to the pharmacy. A pharmacy technician reviews the prescriptions and send them the appropriate pharmacy station. Prescriptions for drugs that must be formulated are sent to lab station, prescription for off-the-shelf are sent to shelving station and prescription for narcotics are sent to secure station. at each station a pharmacist reviews the order , checks the Patient file to determine the appropriateness of the prescriptions , and fills the order if the dosage is at safe level and it will not negativity interact with the other medications or allergic indicated in the Patient's file . If the pharmacist does not fill the order, the prescribing doctor is contacted to discuss the situation. In this case the order may ultimately be filled or the doctor may write other prescriptions depending on the outcome of the discussion. Once filled, a prescription label is generated listing the Patient's name, the drug type and dosage, an expiration date, and any special instructions. The label is placed on the drug container and the order is sent to the appropriate nurse station. The patients admission number, the drug type and amount dispends and the cost of the prescription are then sent to the billing department.

Patient Number and Drug Type,
Amount & Cost

Prescription
Drug Label Info
Unfilled Order Info

Doctor

Store
Manager
0

Hospital
Pharmacy
System
Unfilled Order Info
Response

D1
Patient File

2
Review
Prescription Order by Station

Patient Number and Drug Type,
Amount & Cost

2. Draw a class diagram, showing the relevant classes, attri-butes, operations, and relationships for each of the fol-lowing situations ( if you believe that you need to make additional assumptions, clearly state them for each situation):
a. A company has a number of employees. The attributes of Employee include employeeID ( primary key), name, address, and birth date. The company also has several projects. Attributes of Project include projectName and startDate. Each employee may be assigned to one or more projects, or may not be assigned to a project. A project must have at least one employee assigned, and it may have any number of employees assigned. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate for each employee when assigned to a particular project. At the end of each month, the company mails a check to each employee who has worked on a project during that month. The check amount is based on the billing rate and the hours logged for each project assigned to the employee.

b. A university has a large number of courses in its catalog. Attributes of Course include courseNumber ( primary key), courseName, and units. Each course may have one or more different courses as prerequisites, or a course may have no prerequisites. Similarly, a particular course may be a prerequisite for any number of courses, or it may not be a prerequisite for any other course. The university adds or drops a prerequisite for a course only when the director for the course makes a formal request to that effect.

c. A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of Chemist include name and phoneNo. Attributes of Project in-clude projectName and startDate. Attributes of Equip-ment include serialNo and cost. The organization wishes to record assignDate— that is, the date when a given equipment item was assigned to a particular chemist working on a specified project— as well as total Hours, that is, the total number of hours the chemist has used the equipment for the project. The organiza-tion also wants to track the usage of each type of equip-ment by a chemist. It does so by computing the average number of hours the chemist has used that equipment on all assigned projects. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item.

d. A college course may have one or more scheduled sec-tions, or it may not have a scheduled section. Attributes of Course include courseID, courseName, and units. At-tributes of Section include sectionNumber and semes-ter. The value of sectionNumber is an integer ( such as 1 or 2) that distinguishes one section from another for the same course, but does not uniquely identify a section. There is an operation called findNumSections that finds the number of sections offered for a given course in a given semester.

e. A hospital has a large number of registered physicians. Attributes of Physician include physicianID ( primary key) and specialty. Patients are admitted to the hospi-tal by physicians. Attributes of Patient include patien-tID ( primary key) and patientName. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of pa-tients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or he or she may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment by including the date, time, and results of the treatment.