Reference no: EM13755375
Effective Entity Relationship Model (ERM) Diagram
Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer 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 enable the management staff to perform essential human resources (HR) duties along with the capability to produce ad hoc reporting features for various departments. They look forward to holding data that will allow them to perform HR core functions such as hiring, promotions, policy enforcement, benefits management, and training.
Using this scenario, write a three to four (3-4) page paper in which you:
Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibilities of the client.
Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed.
Select and rank at least five (5) entities that would be required for the development of the data repositories.
Specify the components that would be required to hold time-variant data for policy enforcement and training management.
Diagram a possible 1:M solution that will hold salary history data, job history, and training history for each employee through 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 included in the required page length.
Plan each step of the normalization process to ensure the 3NF level of normalization using the selected five (5) entities of the personnel database solution. Document each step of the process and justify your assumptions in the process.Diagram at least five (5) possible entities that will be required to sustain a personnel solution. The diagram should include the following:
Dependency diagrams
Multivalued dependencies.
|
Discuss the pros and cons
: Per the text, with Server 2012, the option for policy based IP address assignment is available. Discuss the pros and cons of using policy based assignments to segregate mobile devices from the other machines on the network
|
|
When you reach the exploration and trade section
: When you reach the "Exploration and Trade" section, complete the "Become a Spice Trader" assignment. When you reach the end of your journey,
|
|
Design a switch mode pwm dc-dc converter
: Develop a open-loop model of the traction drive shown in Figure and please derive its transfer function - Design a switch mode PWM DC-DC converter for the speed regulation of the DC motor.
|
|
Analyze business strategies of organizations
: The purpose of this assignment is to increase your ability to analyze business strategies of organizations. Business strategy focuses on the strategy of individual businesses. Strategic analysis is critical for analyzing the competitive context in wh..
|
|
Developmental or iterative steps of creating an erm diagram
: Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed. Select and rank at least five (5) entities that would be required for the development of the data repositories
|
|
Simple and compound interest
: You invest $3,400 for five years at 5% simple interest at Jekyll Savings. You invest $3,400 for five years at Hyde Community Bank where interest at 5% is compounded annually. Compute the amounts that will be accumulated. Round to the nearest dollar. ..
|
|
Calculate DCFROR and NPV for evaluation life
: Consideration is being given to the investment of $420,000 at time zero for machinery and equipment to be depreciated using 7 year straight line depreciation starting in year 1 with the half-year convention. Annual sales are projected to be $450,000 ..
|
|
List three tactics of the counter-reformation
: List three tactics of the Counter-Reformation. Why were magic and superstitions so attractive to Renaissance people?
|
|
Description of functional and nonfunctional requirements
: A detailed description of both functional and nonfunctional requirements. At least four (4) functional requirements and four (4) nonfunctional requirements should be provided
|