The system should provide ad-hoc query and repoting functionality. Less then ideal United Way participation. Add the following maintenance Use-Cases: This use case describes the event of updating Staffing Dept pay rates,job title,and supervisor for employees. The hourly wage of an hourly employee or a contract employee. HR cost and labor required for processing employee information changes excessive.

Foreign keys are marked with FK and a number. It is possible they might have identified different ones and stated completely different values for each of the cells. MiscDeduction requires a concatenated primary key because an employee could have multiple records over time. The following completed maxtrix is one possible solution. 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. Describe time required by administrator to maintain employee information from 12 hours per week to 1 or Mail Stop A room or an area of an office where employees can go and retrieve their mail.

System must be platform independent and accessible from all desktops and remote locations. For all transaction processes described in the accompanying narrative, draw the Primitive Data Flow Diagram.

N An employee’s date of birth. This solution is slightly different than the solution given in Milestone 2 simply because later milestones provided more information. A decomposition diagram is a DFD planning tool that shows the top-down functional decomposition and structure of a system.

However,by making them separate entities we can assure that spelling is consistent for all records and provide the user interface with dropdown controls to lookup the values. The date an employee was hired. Also remember that data flows are not allowed between entities. The first name, middle name, and last name of an emergency contact. Users cannot get reports that they need in a timely fashion.


Finally you will construct a system data flow diagram that shows the big picture of the system, and a primitive data flow diagram for a single event process. Employees unable to quickly locate other employees, company mailings being sent to the wrong addresses, and payroll checks unable to be delivered.

Cost of maintaining and operating current mainframe system excessive. You can add this document to your study collection s Sign in Available only to authorized users.

esss case study solutions milestone 2

This use case describes the event of building an Manager ad-hoc query with SQL. Provide a single source of entry for employee information and have the data available real-time.

Case study ESSS milestone 05 data model normalization

But some users have very specific ideas or expectations. A challenge for the systems analyst is to force the user to prioritize. Evaluate students’ thought processes in arriving at them. The full name of a department.

The system should integrate all employees data database into a single Non-functional unified database. Upload document Create flashcards. An order submitted by employees to have a charitable contribution deducted from their payroll. Permanent Employer The permanent employer of a contract employee. Other events exist for basic data maintenance add records, delete records, etc.


esss case study solutions milestone 2

Some students may identify other use cases based on standard maintenance functions. Record your findings in the Reason column.

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

Room A room where employees may work. 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.

Actor Action System Response Step 1: None Need to verify which information should and should not be displayed.

For complaints, use another form. In this section we will learn the necessary background information to be able to complete the milestones of this case study. All of the cardinalities of the major solutinos can be determined from the interview or the forms. This is real life!

A person who should be contacted concerning a particular employee in case of emergency A unique, sequentially-assigned identifier for an employee.