Other events exist for basic data maintenance add records, delete records, etc. Provide a single 2. If your class size is small enough to allow it, have the students demonstrate a typical user session. If you will be doing Milestone 5 as a sepatate assignment,you may want to withhold this solution. Determine whether each potential object is an object, an attribute of a particular object, a synonym for an object or attribute, or something else. A given employee’s information should be accessable only by that Non-functional employee,that employee’s manager,and HR administration. Cost of maintaining and operating current mainframe system excessive Economics.

Site A company location consisting of one or more buildings. Allow employees to maintain their own 2. 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. Provide a single source of entry for employee information and have the data available real-time. The screen will include an option to return to the list of employees and an option to return to the return to the Step 7: 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. Draw appropriate primitive data flow diagrams.

The entities that have concatenated primary keys and are also parent entities MailStop and Room must contribute both primary keys to child entities Room and Employee as foreign keys. Cost of maintaining and operating current mainframe system excessive.


Processing costs may 1. The employee enters search criteria for first or last name, department, location, job title, or supervisor. There is also an option to cancel the search. This causes several problems, including employees being unable to quickly locate other employees, company mailings being sent to the wrong addresses, payroll checks that cannot be delivered, paper-based company telephone books that are out of date almost as soon as they are printed, and less than ideal United Way and Savings Bonds contributions.

Case Study 1 ESSS – Milestone 1 Solution_图文_百度文库

This system would provide the capability for employees to maintain their own information regarding address and telephone number changes, beneficiary changes, United Way deductions, and Savings Bond deductions.

Functional The system should run on a system that is less expensive to operate than Non-functional the mainframe.

esss case study solutions milestone 4

The year for which a United Way contribution applies. Employees cwse to quickly locate other employees, company mailings being sent to the wrong addresses, and payroll checks unable to be delivered. Provide an ad-hoc technology does not reporting solutkons inquiry support ad-hor report feature for users. The system should be accessible over the web and the secure.

Each Employee works in a Department and a Department employs one or more employees. 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.

Case Study ESSS

Students shoud be able to identify at least the soljtions entities below. Jack Mills Zhang Yue Created by: Jack Mills, the vice president of Human Resources for A-1 Information Systems, to analyze how A-1 IS manages its employee information and to design an appropriate system.


The sample RSS we provide represents a more general description that the user conveyed. Cost of maintaining and operating current mainframe system excessive Economics.

esss case study solutions milestone 4

We should try to identify causes rather than restating the problem. It is possible they might have identified different ones and stated completely different values for each of the cells. Duplicate employee information stored in different databases.

This is an abstract use case,which describes the login process. KS1 skills web SPR Site,Building,and Room have a natural composition relationship. Ensure that the students label the data flows and entities correctly.

An Employee will specify one or more MiscDeductions. Upload document Create flashcards. The system must provide a searchable online company directory. The use case is initiated when the user selects this option from the user interface. Economics and Efficiency 1. Allow employees to 1.

esss case study solutions milestone 4

The interview contains clues that this is the preferred method. Less than ideal 1.

More Prepared by Kevin C. None None Web programming to be used so employees can have easy remote access. Alternatively, you might consider having the students submit a narrative walk-through that explains how the session transpires.