CIS 515 Database Modeling and Normalization Assignment

Assignment Help Other Subject
Reference no: EM132960506

CIS 515 Strategic Planning For Database Systems Assignment - Database Modeling and Normalization, Strayer University, USA

Overview - 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 streamlined 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.

Instructions - Using this scenario, write a 3-4 page paper in which you:

1. Determine the steps in the development of an effective entity-relationship model (ERM) diagram and determine the possible iterative steps and factors that one must consider in this process, with consideration of the HR core functions and responsibilities of the client.

2. Analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM diagram are not performed.

3. Select and rank at least five entities that would be required for the development of the data repositories.

4. Specify the components that would be required to hold time-variant data for policy enforcement and training management.

5. 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. Note: The graphically depicted solution is not included in the required page length.

6. Plan each step of the normalization process to ensure the 3NF level of normalization using the selected five entities of the personnel database solution. Document each step of the process and justify your assumptions in the process.

7. Diagram at least five possible entities that will be required to sustain a personnel solution. (Note: The graphically depicted solution is not included in the required page length.) The diagram should include the following:

- Dependency diagrams.

- Multivalued dependencies.

8. The cover page and the reference page are not included in the required assignment page length. Include charts or diagrams created in any chart or drawing tool with which you are familiar. The completed diagrams or charts must be imported into the Word document before the paper is submitted.

Note - All the 8 requirements have to be followed in the same sequence and each part of it should be answered. You have to make a required diagram.

Reference no: EM132960506

Questions Cloud

How has covid-19 reshaped international trade and fdi : How has COVID-19 reshaped international trade and FDI (foreign direct investment)?
Advantages and disadvantages of managed care in america : What are the advantages and disadvantages of managed care in America?
Design a diagram showing the drivers for change : Your task is to use the Force field Analysis concept to design a diagram showing the Drivers for Change and the Restraining forces together with their relative
Identify a workplace and occupation : Choose one of the hazards category (Biological, Chemical, physical, ergonomic, psychosocial) hazard:
CIS 515 Database Modeling and Normalization Assignment : CIS 515 Strategic Planning For Database Systems Assignment - Database Modeling and Normalization, Strayer University, USA - Analyze the risks that can occur
What is the rebate expense and liability : During 2021, 4,000,000 packages of light bulbs are sold, and 190,000, $2 rebates were mailed to customers. What is the rebate expense and liability
What is Avicorp pre-tax cost of debt : Problem - Avicorp has a $11.4 million debt issue outstanding, with a 6.1% coupon rate. What is Avicorp pre-tax cost of debt
Determine the Carrying amount of the bonds as of January : The company also incurred costs in the conversion amounting to P250,000 which were paid in cash. Determine the Carrying amount of the bonds as of January
Determine the rate of depreciation : A company purchased a machinery for rs.12,000. It's useful life is 10 years and the scrap value is rs 1,200. Determine the rate of depreciation

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd