CIS515Week4 Assignment4 - Running head DATABASE MODELING...

  • Strayer University
  • CIS 515
  • Homework Help
  • blackmamba36
  • 11
  • 100% (8) 8 out of 8 people found this document helpful

This preview shows page 1 - 4 out of 11 pages.

Running head: DATABASE MODELING AND NORMALIZATION 1 Database Modeling and Normalization Edmond Labule CIS 515 Strayer University Dr. Keith Martin 08/03/2016
DATABASE MODELING AND NORMALIZATION 2 Database Modeling and Normalization This paper involves the determination of steps of development of an operating entity relationship diagram, including the possible iterative steps, not leaving out the factors consider in the process of considering the human resource core functions and responsibilities of the client. One should analyze the risk associated with the developmental or iterative step during the creation of an entity relationship model diagram if there was last of proper performance on one of the steps. Selecting and ranking five objects that are a requirement for the development of the data repositories. Specification of the components that requires holding the time-variant information for policy enforcement and training management. With the use of a diagram, present a possible solution for 1: M that contains the history of history salary data, job history, and training history for each employee. Finally, to plan each step of the normalization process to ensure the 3NF level of normalization using the five entities of the personnel database solution, and with a use of a diagram of at least five possible entities to sustain personnel solution to include the dependency graph and multivalued dependencies. An Effective Entity Relationship Model Diagram According to Brandenburg, (n.d.), an entity relationship model diagram is a type which consists of data and describes how entities relate with each other. Its primary use is to understand the domain, or clarify a terminology and connect concepts to database structures. In the development of an entity relationship model, the following steps renders necessary; a. The creation of boxes for each object that is relevant to the particular model. b. Modeling the relationship between each box by drawing a line to connect entities that are related, and labeling using verbs or numeric notations.
DATABASE MODELING AND NORMALIZATION 3 c. Identification of attributes that is relevant to each entity.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture