Final Exam MIS 425

This exam is to be completed individually.  You may not work in teams and you may not solicit help from others in the class. Failure to abide by these rules will result in a zero on the exam.

Submission of your exam indicates that you understand the above rule.

Due May 12, 2003

This exam uses the same swimming lesson scenario used in the midterm exam. Two uses cases have been prepared for this scenario: Register Student and Accept Payment. You should read these use cases.

1. (15 pts.) A class diagram needs to be created for the Swimming Complex. The systems analysts documented several classes that correspond to the employee portion of the application. The Swimming Complex employs Swimming Instructors, Lifeguards, and Staff. All Employees have an employee id, first name, last name, start date, and payment rate. Lifeguards also have a certification level and certification date. All Swimming Instructors are also Lifeguards. Swimming Instructors have a list of swimming level preferences (that is, the levels they prefer to teach). The system must keep track of the Swimming Lessons (that is, class with date/time) taught by a particular swimming instructor. A lesson must have one instructor. An instructor can teach more than one class (i.e., lesson). Staff have an attribute that indicate their office assignment. Staff members typically belong to a Department. A department can employ many staff. Create a class diagram for the employee portion of the system (you do not need to reference the Register Student and Accept Payment use case at this time).

2. (15 pts.) The class diagram in question 1 was developed to support the employee portion of the system. Another class  diagram must be developed to support the registration and payment portion of the system. Refer to the Register Student and Accept Payment use cases. Draw a class diagram that represents the relationships between the objects mentioned in these uses cases (note: one class diagram should cover both use cases). List attributes and methods associated with each class.

3. (20 pts.) A new system is to be developed that supports registering students for swimming lessons. Create a sequence diagram for the normal flow of events in the Register Student use case. The sequence diagram should use boundary, control, entity, and lifecycle objects. Make sure that the methods shown in your sequence diagram are consistent with the methods identified in question 2.

4. (5 pts.) How many total sequence diagrams are likely to be developed for the Register Student use case? Explain.

5. (15 pts.) A registration object is likely to have several states: Registration Unpaid, Waiting for Check Clearance, Registration Paid, Swimming Lesson Complete (see the Accept Payment use case for more information). Draw a state diagram to illustrate the relationships between these states of the registration object.

6. (15 pts.) A class diagram representing inventory used at the swimming complex was developed (see Inventory Class Diagram). This model must be converted to a relational schema for implementation in a relational database. Specify the relations that will be used.

7. (10 pts.) Assume that the decision to custom build the software was not made. The swimming complex is debating whether to custom develop, purchase Swimming Management 2003 software, or purchase Aqua Software. Each alternative has a different cost. In addition, Swimming Management 2003 does not support the determine swimming level feature. Aqua Software does not support look-up of swimmers based on a parent's ID. Aqua software appears to be more easily upgraded, but Swimming Management 2003 appears to be easier to use. Other differences also exist.  The manager of the Swimming Complex asks you to evaluate the alternatives. Describe an approach you would take for making a recommendation (note: Just describe the approach, you do not actually need to make a recommendation).


Last modified: May 6, 2003
Dirk Baldwin, MIS, UW-Parkside, dirk.baldwin@uwp.edu