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)
Running head: DATABASE MODELING AND NORMALIZATION 3 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 requiring any data type consisting of a date or time.From a security standpoint I would recommend at least weekly full backups considering the sensitivity of the information within.redundancy audit would include a check against current operational procedures against the attributes currently associated with each entity to ensure that the database will continue to provide beneficial output to the company.A very sophisticated control is required to avoid redundancy and loss of integrity which an audit could help mitigate. (Doon & Rivero 2002) Another part of the redundancy audit would include an internal integrity audit to ensure that factors affecting performance are at least analyzed quarterly.A
Want to read all 9 pages?
Previewing 4 of 9 pages Upload your study docs or become a member.
Want to read all 9 pages?
Previewing 4 of 9 pages Upload your study docs or become a member.
End of preview
Want to read all 9 pages? Upload your study docs or become a member.