Management of the Urban Real Estate Agency wants the following business rules integrated into the database design. Each property must have a unique listing number that identifies it. Searches for properties can be made by property type, price, location, number of bedrooms, or any combination of property descriptors. Transaction types are Purchase, Sell, or Rental One Agent is assigned to multiple clients, but each client only works with one Agent. Agents must be identified by a unique identifier. Not all Agents are employees. Some Agents are independent agents that work for the agency on a commission basis. Management wants to be able to access Agent related data quickly. Agent specific data, should be able to track the usual information, (Name address etc) but also the Agents real estate licence number and , and track the commissions paid to the Agent on all transactions Management want to be able to quickly identify what clients each Agent is working with. Each transaction must have a unique transaction identifier that serves to track the transaction, the transaction details, and the client that entered into the transaction. Transaction details must be easily accessible by management for accounting requirements. They must be able to track transactions by date, (by week, month, year as needed) and by Agent. Each property that is listed for sale has a listing Agent. The listing Agent may be different from the Agent that is working with the client on a property purchase. Commission on each transaction is set as 6% of the transaction amount if the listing Agent is the same as the selling Agent. If the selling Agent is different from the listing Agent, then the commission is set at 3% each The Agency retains a total of 6% of the transaction as fees. From this amount, 1.5% is given as commission to the listing agent and 1.5% is given as commission to the selling agent. Your task: For this assignment, you will be responsible only for designing the database structure only. You will not need to create the database, its tables or its relationships. Essentially, you will be responsible for analyzing the case above and designing the database structure, its tables and its fields.