Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Computer Engineering Expert

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

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M915495

Have any Question? 


Related Questions in Computer Engineering

1 what is physical security what are the primary threats to

1. What is physical security? What are the primary threats to physical security? How are they made manifest in attacks against the organization? 2. What are the roles of IT, security, and general management with regard t ...

Implement a class roachpopulation that simulates the growth

Implement a class RoachPopulation that simulates the growth of a roach population. The constructor takes the size of the initial roach population. The breed method simulates a period in which the roaches breed, which dou ...

1 in your own words describe the two motivations for

1. In your own words, describe the two motivations for defining functions in your programs. 2. We have been thinking about computer programs as sequences of instructions where the computer methodically executes one instr ...

1 in wireshark go to statistics gt summary what is the

1 .In Wireshark, go to Statistics > Summary. What is the Average Mbps? 2. Go to Statistics > Protocol Hierarchy. Which protocols use most of the bandwidth? 3. Go to Statistics > Packet Lengths > Create Stat. What percent ...

1 using the web identify some certifications with an

1. Using the Web, identify some certifications with an information security component that were not discussed in this chapter. 2. Search the Web for at least five job postings for a security administrator. What qualifica ...

1 consider proposed implementations of a systolic array you

1. Consider proposed implementations of a systolic array (you can find these in on the Internet or in technical publications). Then attempt to program the loop provided in Exercise 6.11 using this MISD model. Discuss any ...

Design and implement an algorithm that performs insertions

Design and implement an algorithm that performs insertions and deletions on a doubly linked list. In a doubly linked list each node has two pointers (except at the head and tail), one to its successor and one to its pred ...

Create 1 webpage that lays out the attached design using

Create 1 webpage that lays out the attached design using CSS. You may use any font you want.  You can get the pictures from the Word document by right clicking on each picture and choosing "Save as picture". Zip all your ...

Internet technology project executiion ip3project execution

Internet Technology Project Executiion IP3 Project Execution IP3 Unit: Project Execution Deliverable Length: New content of 3-4 pages All sources should be cited both in-text and in References using APA format; with supp ...

1 ftp uses the services of tcp for exchanging control

1. FTP uses the services of TCP for exchanging control information and data transfer. Could FTP have used the services of UDP for either of these two connections? Explain. 2. In FTP, which entity (client or server) start ...

  • 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.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro