The hourly wage of an hourly employee or a contract employee. They should include all interface and controller objects identified in the sequence diagram and assign behaviors to objects consistent with the sequence diagram. The first name, middle name, last name, and nickname of an employee. If you have not already drawn a Context Diagram in Milestone 2, draw one now based on the meeting transcript in Exhibit 2. This is an abstract use case, which describes the event of viewing a complete profile for a single employee.

Implementation Constraints and Specifications: It is important to ensure that students use the proper controls when designing their screens. The date an employee was hired. The office phone number of an employee. The user views the search screen.

Redundancy of keying employee information in both micro and mainframe.

Describe time required by administrator to maintain employee information from 12 hours per week to 1 or Also remember that data flows are not allowed between entities. Age and technology of system require a high milestons of is support.

Case Study ESSS

Cost of maintaining and operating current mainframe system excessive. System displays option milestonee kind of information to be displayed. The user will fill in search criteria for one or more of the on-screen options.

We have chosen to focus only on the use cases that will be most used. Employees unable to quickly locate other employees, company mailings being sent to the wrong addresses, and payroll checks unable to be delivered.


Identify external and temporal business events for a system.

Case study ESSS milestone 05 data model normalization – Tài liệu text

Foreign keys are marked with FK and a number. A payroll deduction that can be specified by employees. The home phone number of an employee. But make sure each non-key attribute exists in only one entity. The system should provide managers with the tools to monitor United Functional Way participation activity. Practically any solution is acceptable that includes all events and provides for a logical division of the system.

Hardcopy telephone book,published quarterly,becomes quickly out of date. Information changes are submitted via forms and then have to be keyed into the system by an administrator,thus creating a lag time before the data in the system is current.

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.

esss case study solutions milestone 2

They may not have all the answers at this point in time. It also stressed that Jack Mills expects the system to help solve the United Way and Savings Bond participation problem. Duplicate employee information stored in different databases.


System updates data for pay rates or job title or supervisor.

Case study ESSS milestone 05 data model normalization

The user must have previously logged on. Eliminate hardcopy unauthorized data telephone access or modification. Determine whether each potential object is an object, an attribute of a particular object, a synonym for an object or attribute, or something else.

Evaluate students’ thought processes in arriving at them. Stress to the students that this matrix is a living document.

esss case study solutions milestone 2

An order submitted by employees to have a charitable contribution deducted from their milestine. A Case Study in the De No automated interface between mainframe application and micro application. Note that not everything in the transcript is related to the Context Diagram.

Most students should be able to correctly identify the Uses relationships shown below. For all transaction processes described in the accompanying narrative, draw the Primitive Data Flow Diagram.

esss case study solutions milestone 2

System displays all employees that match criteria. For casee, use another form. An Employee will make zero or more UnitedWayContributions zero or one each year.