100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 4 out of 13 pages.
CIS 515Week 4 AssignmentDatabase Modeling and Normalization
IntroductionThis 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 effectiveEntity Relationship Model (ERM) Diagram, factors, consideration ofthe HR core functions, and the responsibilities of the client:The Entity Relationship Model (ERD) is the model used to show therelationships 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 relationshipamong the entities. Cardinality: It is the Constraint in the ERM, between theentities. The steps to developing the ERM are the following:1.Defining the Entities: We assume that we have in this Governmentorganization that there is the Hiring Agency, and its database consistof these entities: Management, Employee, Department, and Customer.At this point we can implement these entities by the ERM shown in thediagram below.
2.Determine the relationships: That are identified in the first by the matrix:MANAGEMENTEMPLOYEEDEPARTMENTCUSTOMERMANAGEMENTManages Responsibleof