CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 11

CIS 515 WEEK 4 ASSIGNMENT 4 DATABASE MODELING AND
NORMALIZATION
Assignment 4: 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 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:
1. 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.
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 (5) 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.