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 igs need dc-ac ac-dc and ac-ac converters describe one

1. IGs need dc-ac, ac-dc, and ac-ac converters. Describe one application, relevant for IG-based energy system, for each of those power conversions. 2. Where are dc-dc converters used in IG systems?

For this discussion use the pest and porter 5-forces model

For this discussion, use the PEST and Porter 5-Forces Model to respond to the following: Identify environmental and industry influences that should be a concern or present an opportunity to Ford Motor Company. Provide a ...

After closing time the store manager would like to know how

After closing time, the store manager would like to know how much business was transacted during the day. Modify the CashRegister class to enable this functionality. Supply methods getSalesTotal and getSalesCount to get ...

Distinguish between a policy requirement and a mechanism

Distinguish between a policy requirement and a mechanism. Identify at least three specific security requirements for a system you know and describe at least two different mechanisms for implementing each one.

You are asked to explain whether or not your organization

You are asked to explain whether or not your organization (industrial manufacturing of furniture) should pursue ISO 14001 certification for its environmental management system. Provide a summary of your recommendation, a ...

Write a method randomshape that randomly generates objects

Write a method randomShape that randomly generates objects implementing the Shape interface: some mixture of rectangles, ellipses, and lines, with random positions. Call it 10 times and draw all of them.

In the text a variant of the cfb mode is proposed which

In the text, a variant of the CFB mode is proposed which encrypts individual bytes. Draw a block diagram for this mode when using AES as block cipher. Indicate the width (in bit) of each line in your diagram. We are usin ...

1 how does a signature-based idps differ from a

1. How does a signature-based IDPS differ from a behavior-based IDPS? 2. What is a monitoring (or SPAN) port? What is it used for? 3. List and describe the three control strategies proposed for IDPS control.

The labor movement in a global economythe topics covered

The Labor Movement in a Global Economy The topics covered throughout the course will provide a starting point for further research. The final assignment must be supported by a solid foundation in labor relations concepts ...

Consider a hash table of size 501 that contains 85 keysa

Consider a hash table of size 501 that contains 85 keys. (a) What is the load factor? (b) What is the average number of comparisons required to determine if the collection contains the key 73, if: i. linear probing is us ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen