Assignment 4: Database Modeling and Normalization1Assignment 4 – Database Modeling and NormalizationDr. Osama MoradCIS 515 – Strategic Planning for Database SystemsJanuary 16, 2017Database Modeling and NormalizationThe consulting firm I that work for offers information technology and database services.
Assignment 4: Database Modeling and Normalization2Part of its core services is to optimize and offer streamline solutions for efficiency. Recently, myfirm has been awarded a contract to implement a new personnel system for a government agency.This government agency has requested an optimized data repository for its system which willenable the management staff to perform essential human resources (HR) duties along with thecapability to produce ad hoc reporting features for various departments. The agency would likethe ability to grasp data that will allow them to perform HR core functions such as hiring,promotions, policy enforcement, benefits management, and training.First, I will determine the steps in the development of an effective Entity RelationshipModel. The means required for building up a robust ERM model incorporate few stagesdistinguishing business guidelines and prerequisites give a comprehension of its operations andstrategies. An entity relationship diagram (ERD) is at first created to take into consideration thedifferential proof of the individual traits for every element and also reasonable essential keys.Once finished, a correction and audit of the ERD can aid in helping to define the entire ERMfurther. Taking after these means ceaselessly over a period in such a valid approach can help aplanner build up a powerful ERM for any organization.In the outline below I have selected a few stages for components in light of three essentialprincipals of information correspondence. As represented in below, I have denoted the parts andrecurrence in which will suggest performing them. A time variant data review would comprise ofthe governing rules encompassing substances identified with accounting and any characteristicrequiring any information sort comprising of a date or time. From a security outlook, I would
Want to read all 8 pages?
Previewing 3 of 8 pages Upload your study docs or become a member.
Want to read all 8 pages?
Previewing 3 of 8 pages Upload your study docs or become a member.
End of preview
Want to read all 8 pages? Upload your study docs or become a member.