MiscDeduction requires a concatenated primary key because an employee could have multiple records over time. If the user selects the option to return to the search screen,the use case returns to step 2. Suggest us how to improve StudyLib For complaints, use another form. Processing costs may 1. The narrative only mentioned the priority of the project as a whole, six months. HR cost and labor required for processing employee information changes excessive. Redundancy of keying employee information in both micro and application.

The students should try to identify problems and opportunities that were mentioned in the narrative. If your class size is small enough to allow it, have the students demonstrate a typical user session. During this milestone you will first construct a context diagram to establish project scope and boundaries. The street address, city, state, and zip of an emergency contact. Case Study – Suggested This use case describes the event of updating the Employee employee profile information.

The interview contains clues that this is the preferred method. Prepared by Kevin C. Often users will stress that everything is milestonee priority. Eliminate duplicate keying of information by providing a single source of entry for employee information 2. Provide an ad-hoc technology does not reporting and inquiry support ad-hor report feature for users.

esss case study solutions milestone 4

Students should realize that based on additional interviews they may need to revise this matrix to reflect new problems, opportunities, directives, and changes in their understanding of urgencies and priorities.


Optional Merge your event diagrams from 3 above into a System Diagram. It is important that the students recognize that while it may appear to the students that Jack Mills initiated this project, Dotty Jones is the key user contact. Economics and Efficiency 1.

esss case study solutions milestone 4

Make sure students specify primary keys that uniquely identify the entities as well as use proper names for the keys. No tracking mechanisms exist to monitor employee contributions.

Case Study ESSS

A decomposition diagram is a DFD planning tool that shows the top-down functional decomposition and structure of a system. The work phone number of an emergency contact. Redundancy of keying employee information in both micro and mainframe. Merge event diagrams into a system data flow diagram. A Case Study in the De The screen will include an mileston to return to the list of employees and an option to return to the return to the Step 7: The difference between an aggregation and a regular association is often a judgment call.

Mail Stop A room or an area solutoons an office where employees can go and retrieve their mail.

Less than ideal 1. MiscDeduction requires a concatenated primary key because an fsss could have multiple records over time. A payroll deduction that can be specified by employees. Because the same employee directory shows two buliding with the same room numbers,Room must use RoomNum and RoomBldgID as the primary key.


Include partitions for the actor and the system. If you have not already drawn a Context Diagram in Milestone 2, draw one now based on the meeting transcript in Exhibit 2.

Provide management inquiry and reporting 2. Solutoins telephone book,published quarterly,becomes quickly out of date. Whether or not they identify the optional entities will depend on how they interpret the user requirements and on thheir experience level with datebase normalization.

Grade based on the logic of the student’s approachto the problem and consistency of implementation. Employee data casse be out of sync across company system. Evaluate students’ thought processes in arriving at them.

Case Study ESSS

Every Employee has zero or more EmergencyContacts. Salary Employee An employee who is paid a salary. Some students may identify other jilestone cases based on standard maintenance functions.

esss case study solutions milestone 4

Your e-mail Input it if you want to receive answer. Another alternative is to start with this data model for Milestone but add addition requirements,such as the Milestone Advanced Option and require that students revise the data model accordingly. Similaryiy,two or more building could feasibly hava the same mail stop Ids.