Wk4.Assign.LMorgan.docx - CIS 515 Week 4 Assignment...

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

CIS 515 Week 4 Assignment Database Modeling and Normalization
Introduction This paper will present steps to develop a effective Entity Relationship Model (ERM). I will break down what happen if any of the steps in the development process of making an ERM Diagram isn't performed. From that point onward, I will suggest the entities that would be required for the development of the data repositories with the clarifying of what is the time- variation data and what is the decided outcome for this data type. Additionally, I will be using Visio to draw the diagrams of the conceivable answer for the numerous variation data. In the last part, I will clarify the means of the normalization procedure to guarantee the 3NF level of normalization with the illustration of the every one of these steps. The possible iterative steps in the development of an effective Entity Relationship Model (ERM) Diagram, factors, consideration of the HR core functions, and the responsibilities of the client: The Entity Relationship Model (ERD) is the model used to show the relationships between the entities. It is made up of numerous parts: Entity: That is the individual, area, or anything that can store the information. Attribute: It is the main factor of the entity. Relationship: It is the relationship among the entities. Cardinality: It is the Constraint in the ERM, between the entities. The steps to developing the ERM are the following: 1. Defining the Entities: We assume that we have in this Government organization that there is the Hiring Agency, and its database consist of these entities: Management, Employee, Department, and Customer. At this point we can implement these entities by the ERM shown in the diagram below.
2. Determine the relationships: That are identified in the first by the matrix: MANAGEMEN T EMPLOYEE DEPARTMEN T CUSTOMER MANAGEMEN T Manages Responsible of

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture