Database modeling and normalization

Assignment Help Basic Computer Science

Reference no: EM132451199

Database Modeling and Normalization

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.

Using this scenario, write a 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 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. 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 5 entities of the personnel database solution. Document each step of the process and justify your assumptions in the process.

Diagram at least 5 possible entities that will be required to sustain a personnel solution. The diagram should include the following:

Dependency diagrams.

Multivalued dependencies.

Reference no: EM132451199

Questions Cloud

Emphasis on electronically stored information : What likely effect will its emphasis on electronically stored information (ESI) have on an organization's need for a digital forensic capability?

Explain the importance of continuing education : The health care industry, like other industries, is a very competitive environment. As organizational behavior within health care companies evolves

Adolescent and young adult health : You will submit one 350-word thread to the questions posed in the forum in APA format: here is the discussion

Fatigue and cellphone distraction when it comes to patient : What does research show on alarm fatigue and cellphone distraction when it comes to patient safety?

Database modeling and normalization : Imagine that you work for a consulting firm that offers information technology and database services.

Biophysical risks include factors that originate : Biophysical risks include factors that originate with either the mother or the fetus and affect the functioning of either one or both.

Discuss the elements of strategic management : Discuss the elements of strategic management and explain why it is crucial to an organization's survival. Explain a strategy and a business model

Advise and teach parents about health and wellness : The time from infancy to school-age are significant development years for children and their parents. What educational role is most appropriate for the nurse?

What control can be instituted for each fraud : What control can be instituted for each fraud to reduce the likelihood of occurrence. List an audit procedure that can be used to discover each fraud

User Account

All Pages