CIS-515-Assignment-4-Database-Modeling-and-Normalization.docx

This preview shows page 1 - 6 out of 18 pages.

Assignment 4: Database Modeling & Normalization 1 Assignment 4: Database Modeling & Normalization Zainab M. Alameen Dr. Wade Poole CIS 515 August 1, 2015 Database Modeling & Normalization Introduction:
Assignment 4: Database Modeling & Normalization 2 In this paper, I will introduce the iterative steps in the development of an effective Entity Relationship Model (ERM). Then I will analyze what happen if any of the developmental steps of creating an ERM Diagram is not performed. After that, I will prefer the e ntities that would be required for the development of the data repositories with the explaining of what is the time- variant data & what is the determined components for this data type. Also, I will draw the diagram of the possible solution for the many variant data by the Visio application. In the last I will explain the steps of the normalization process to ensure the 3NF level of normalization with the drawing of the all these steps, by the Visio App. The iterative steps in the development of an effective Entity Relationship Model (ERM) Diagram, factors, consideration of the HR core functions, & the responsibilities of the client: The Entity Relationship Model (ERD) is the model to represent the relationships among the entities. It has many components: Entity: That is the person, location, or anything by it can store the data. Attribute: It is the characteristic of the entity. Relationship: It is the association among the entities. Cardinality: It is the Constraint in the ERM, among the entities. The development steps of the ERM are the following: 1. Identify the Entities: We suppose that we have in this Government agency that is the Hiring Agency, & this has in its database the entities: Management, Employee, Department, & Customer. Then we can implement these entities by the ERM as the following: Entity by the Rectangle figure.
Assignment 4: Database Modeling & Normalization 3 Fig(1): The Entities 2. Determine the relationships: That are identified in the first by the matrix: MANAGEMEN T EMPLOYEE DEPARTMENT CUSTOMER MANAGEMEN T Manages Responsible of Hires EMPLOYEE Works by Part of Manipulates with DEPARTMENT CUSTOMER Here There are many relationships among the entities: 1. MANAGEMENT manages EMPLOYEE. 2. MANAGEMENT responsible of DEPARTMENT. 3. MANAGEMENT hires CUSTOMER. 4. EMPLOYEE works by MANAGEMENT. 5. EMPLOYEE part of DEPARTMENT. 6. EMPLOYEE manipulates with CUSTOMER.
Assignment 4: Database Modeling & Normalization 4 After determining the relationships, it must draw them with all the lines between the entities & the relationships, by the ERM: (Relationship by the Diamond figure). Fig (2): Entities with the relationships 3. Determine the relationship type (1:1), (1: M), or (M: N). Every relationship type has a specific symbol to implement it .
Assignment 4: Database Modeling & Normalization 5 Fig (3): Symbols & their meanings For Example One manager manages many employees: (1: M): We can implement this relationship as the following: One & only one manager can manage one or many employees.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture