Assignment 4 u2013 Database Modeling and Normalization -...

This preview shows page 1 - 3 out of 8 pages.

Assignment 4: Database Modeling and Normalization 1 Assignment 4 – Database Modeling and Normalization Dr. Osama Morad CIS 515 – Strategic Planning for Database Systems January 16, 2017 Database Modeling and Normalization The consulting firm I that work for offers information technology and database services.
Assignment 4: Database Modeling and Normalization 2 Part 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 essential principals 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 of the 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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture