95%(21)20 out of 21 people found this document helpful
This preview shows page 1 - 3 out of 8 pages.
Database Modeling and Normalization Student: Instructor: CIS 515 Strategic Plan for Database SystemsSTRAYER UniversityDate: 05/13/2016
DATA MODELING AND NORMALIZATION2In creating a database, normalization is the process of organizing it into tables in such away 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 thecreation of additional tables. (While normalization tends to increase the duplication of data, itdoes not introduce redundancy, which is unnecessary duplication.) Normalization is typically arefinement process after the initial exercise of identifying the data objects that should be in thedatabase, identifying their relationships, and defining the tables required and the columns withineach table.The purpose of this Assignment is to first determine the steps in the development of an effectiveEntity Relationship Model (ERM) Diagram and determine the possible iterative steps / factorsthat one must consider in this process with consideration of the HR core functions andresponsibilities of the client. And second, analyze the risks that can occur if any of thedevelopmental or iterative steps of creating an ERM Diagram are not performed. Thirdly, theassignment will select and rank at least five (5) entities that would be required for thedevelopment of the data repositories. Next we’ll specify the components that would be requiredto hold time-variant data for policy enforcement and training management. After that, we’lldiagram a possible 1:M solution that will hold salary history data, job history, and traininghistory for each employee. Furthermore, the assignment will plan each step of the normalization