Advance Database management class? Database Project You are the Senior Consultant at Abacus Consulting, tasked with the database project for Amadeus Real Estate client. The company employs real estate agents who work with customers to buy and sell properties (both residential and commercial). As part of your lead role, you are responsible for meeting with the client team and gathering requirements. You are then scheduled to design the data model and implement a working prototype to demonstrate the validity of the data model. Your specific tasks are broken down as below Phase 1 – Requirements Gathering As part of the requirements phase, develop a minimum of 10 business rules that apply to the client’s business. Phase 2 – Database Design Develop a database model based on the requirements. Use the Crow’s Foot notation, indicate all attributes, primary/foreign key relationships, cardinalities and relationship strengths. Phase 3 – Implementation Implement the table structure designed for the system. Assume property details (type, area, list price, sale price …etc). Assume 3% commission on all transactions. 1.Write the SQL code to create the needed tables. Ensure all primary keys, foreign keys and constraints are defined. 2.After implementing the table structures, insert dummy data for 10 transactions, placed between January-1-2012 to February-1-2012. Phase 4 – Validation To validate the data model you have developed, you are asked to write some queries and verify the results with expected results. Write the SQL statements that provide the following information: •Total of all sales for the period Jan-2-2012 to Jan-15-2012 •Agent who sold the most number of properties between Jan-2-2012 to Jan-15-2012. •Agent who sold the most $$ value of properties between Jan-5-2012 to Feb-1-2012. •Most expensive property sold between Jan-1-2012 to Feb-1-2012. Submission Instructions Statements for all phases and the ERD must be submitted as a single zip file. The SQL file must be in plain text format (.filename with .sql extension). The SQL file must be called Lastname_Project.sql. The ERD diagram must be uploaded into BB or turned in during class.