Assignment 4: Database Modeling and Normalization Due Week 4 and worth 120 points Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solutions

Assignment 4: Database Modeling and Normalization Due Week 4 and worth 120 points Imagine that you work for a consulting firm that offers information technology and database services. Part of its core services is to optimize and offer streamline solutions for efficiency. In this scenario, your 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. They look forward to holding data that will allow them to perform HR core functions such as hiring, promotions, policy enforcement, benefits management, and training. Using this scenario, write a three to four (3-4) page paper in which you: Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps/factors that one must consider in this process with consideration of the HR core functions and responsibilities of the client.