Assignment 4 Database Modeling and Normalization - Database...

This preview shows page 1 - 3 out of 8 pages.

Database Modeling and Normalization Student: Instructor: CIS 515 Strategic Plan for Database Systems STRAYER University Date: 05/13/2016
DATA MODELING AND NORMALIZATION 2 In creating a database , normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended. Normalization may have the effect of duplicating data within the database and often results in the creation of additional tables. (While normalization tends to increase the duplication of data, it does not introduce redundancy, which is unnecessary duplication.) Normalization is typically a refinement process after the initial exercise of identifying the data objects that should be in the database, identifying their relationships, and defining the tables required and the columns within each table. The purpose of this Assignment is to first 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. And second, analyze the risks that can occur if any of the developmental or iterative steps of creating an ERM Diagram are not performed. Thirdly, the assignment will select and rank at least five (5) entities that would be required for the development of the data repositories. Next we’ll specify the components that would be required to hold time-variant data for policy enforcement and training management. After that, we’ll diagram a possible 1:M solution that will hold salary history data, job history, and training history for each employee. Furthermore, the assignment will plan each step of the normalization

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture