Assignment 4: Database Modeling and NormalizationDue Week 4 and worth 90 pointsImagine 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:Note:The graphically depicted solution is not included in the required page length.Your assignment must follow these formatting requirements: