100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 4 out of 9 pages.
Running head: DATABASE MODELING AND NORMALIZATION1Database Modeling and NormalizationDr. Larisa BulyshevaCIS 515 – Strategic Plan For Database SystemsAugust 5, 2018
Running head: DATABASE MODELING AND NORMALIZATION2Week 4 Assignment 4Mark FisherDeveloping an Effective Entity Relationship Model (ERM)The steps needed for developing an effective ERM model include iterative steps identifying business rules and requirements given an understanding of its operations and procedures. An entity relationship diagram (ERD) is initially developed to allow for the identification of the individual attributes for each entity as well as suitable primary keys. Once completed a revision and review of the ERD can be performed helping to further define the complete ERM. Following these steps continuously over a period in such an iterative approach can help a designer develop an effective ERM for any business.In working with this government contract I would suggest meeting up initially with the business meeting with key stakeholders and decision makers so that identification of operational activities can be started. From there meetings and interviews would be recommended with the different managers from the operational groups to identify key entities, plausible and possible attributes, and their relations. After initial entity relationship diagrams and models are designed, further meetings with operators themselves will be conducted to further define any specific data elements. (ie. Entities, relationships, constraints)The diagram I have chosen I have included iterative steps for factors based on three important principals of data communication. Shown in Figure 1, I have highlighted the factors and frequency in which I would recommend performing them. A time variant data audit would consist of the checks and balances surrounding entities related to accounting and any attribute
Running head: DATABASE MODELING AND NORMALIZATION3requiring any data type consisting of a date or time.