97%(36)35 out of 36 people found this document helpful
This preview shows page 1 - 3 out of 8 pages.
Assignment 4: Database Modeling and Normalization1Assignment 4 – Database Modeling and NormalizationDr. Osama MoradCIS 515 – Strategic Planning for Database SystemsJanuary 16, 2017Database Modeling and Normalization The 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, my firm 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 will enable the management staff to perform essential human resources (HR) duties along with the capability to produce ad hoc reporting features for various departments. The agency would like the 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 Relationship Model. The means required for building up a robust ERM model incorporate few stages distinguishing business guidelines and prerequisites give a comprehension of its operations and strategies. An entity relationship diagram (ERD) is at first created to take into consideration the differential 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 ERM further. Taking after these means ceaselessly over a period in such a valid approach can help a planner 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 and recurrence in which will suggest performing them. A time variant data review would comprise ofthe governing rules encompassing substances identified with accounting and any characteristic requiring any information sort comprising of a date or time. From a security outlook, I would