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

For many years industries and financial institutions hired

For many years, industries and financial institutions hired people who broke into their systems once those people were released from prison. Now, such a conviction tends to prevent such people from being hired. Why you t ...

1 design and implement a function that reverses the order

1. Design and implement a function that reverses the order of the items in a queue. Your solution may only use the operations defined by the Queue ADT, but you are free to use other data structures if necessary 2. Implem ...

Spatial location and grass in the wolf sheep simple model

Spatial location and grass In the Wolf Sheep Simple model, the grass is randomly distributed across the space. However it is more realistic that areas of grass are spatially collocated, that is, areas with more grass are ...

1 how is an incident response plan different from a

1. How is an incident response plan different from a disaster recovery plan? 2. What is risk appetite? Explain why risk appetite varies from organization to organization. 3. What is a cost benefit analysis?

1 discuss the concept of global privilege does it work well

1. Discuss the concept of global privilege. Does it work well in a distributed authorization or centralized authorization? 2. With the principle of "least privileged," is it possible to have too much authorization? What ...

Program a consists of 1000 consecutive add instructions

Program A consists of 1000 consecutive ADD instructions, while program B consists of a loop that executes a single ADD instruction 1000 times. You run both programs on a certain machine and find that program B consistent ...

What is the relationship between increased social

What is the relationship between increased social responsibility and IT at the workplace? Answer in about two paragraphs with reference. Must be 200-400 words and show an understanding and full development of the concept ...

Security in the futurenbspnbspplease respond to the

"Security in the Future"  Please respond to the following: Based on what you've learned in this course, give your opinion on the current state of the security industry. Take a position on whether you believe that hackers ...

An airplane has an airspeed of 550 kmh bearing 48degreesdeg

An airplane has an airspeed of 550 km/h bearing 48degrees° north of east. The wind velocity is 50 km/h in the direction 26° north of west. Find the resultant velocity representing the path of the airplane with respect to ...

In distance-vector routing good news decrease in a link

In distance-vector routing, good news (decrease in a link metric) will propagate fast. In other words, if a link distance decreases, all nodes quickly learn about it and update their vectors. In Figure 20.33, we assume t ...

  • 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