Assume that you work for a consulting firm which offers information technology and database services. Part of its core services is to optimize and provide streamline solutions for efficiency. In this scenario, your firm has been awarded a contract to implement a new personnel system for a government agency. This government agency has requested an optimized data repository for its system which will allow the management staff to perform necessary human resources (HR) duties all along with the capability to produce ad hoc reporting features for different departments. They look forward to holding data which will permit them to perform HR core functions like hiring, promotions, policy enforcement, benefits management and training.

By using this scenario, prepare a three to four page paper in which you:

Find out the steps in the development of an effective Entity Relationship Model (ERM) Diagram and find out the possible iterative steps or factors which one must consider in this process with consideration of the HR core functions and responsibilities of the client. Analyze the risks which can take place if any of the developmental or iterative steps of making an ERM Diagram are not performed. Choose and rank at least five entities which would be needed for the development of the data repositories. Specify the components which would be needed to hold time-variant data for policy enforcement and training management. Diagram a possible 1:M solution which will hold salary history data, job history, and training history for each employee via the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia.

Note: The graphically depicted solution is not comprised in the required page length. Plan each step of the normalization process to make sure the 3NF level of normalization by using the selected five entities of the personnel database solution. Document each step of the process and justify your suppossitions in the process. Diagram at least five possible entities that will be required to sustain a personnel solution. The diagram should include the following: Dependency diagrams Multivalued dependencies

Related Questions in Computer Engineering

Assignment 1 System Security Certification and Accreditation Becoming better acquainted with the history of accreditation and authorization has made you aware that you need to start planning tasks in order to complete a ...

A click counter is a small hand-held device that contains a push button and a count display. To increment the counter, the button is pushed and the new count shows in the display. Clicker counters also contain a button t ...

A certain program consists of three independent parts A, B and C each of which can execute in parallel on a separate processor. Part A requires 78 billion cycles to complete, part B requires 40 billion cycles to complete ...

1. Can a router combine the advertisement of a link and a network in a single link-state update? 2. Explain why we can have different intradomain routing protocols in different ASs, but we need only one interdomain routi ...

Computer viruses and worms are often transmitted as attachments to electronic mail. The Drib's development network infrastructure directs all electronic mail to a mail server. Consider an alteration of the developmen ...

1. Write a regular expression that finds all the words in a string that contain double letters, such as "deep" and "book". 2. Write a regular expression that finds all the header tags (, , etc.) in a Web page. 3. Write a ...

Write a program named IntArrayDemo that stores an array of 10 integers. Until the user enters a sentinel value, allow the user three options: (1) to view the list in order from the first to last position, (2) to view the ...

1. Assume we want to connect two isolated hosts together to let each host communicate with the other. Do we need a link-layer switch between the two? Explain. 2. If there is a single path between the source host and the ...

Assignment: Conflict Resolution Conflict resolution is a necessary skill for any manager or leader. In this assignment, you will examine the difference between conflict and competition. You will also explore ways of dete ...

1. In TCP, does a FIN segment close a connection in only one direction or in both directions? 2. In TCP, what type of flag can totally close the communication in both directions? 3. Most of the flags can be used together ...

4,153,160 Questions Asked

13,132 Experts

2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses,
Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.