"Business Rules? A property has been handles for the ‘Sale’ or ‘Rent’ by a single property manager.? A property manager can supervise another or sub managers.? Customer would send the request for a rental property or give an offer to a buyproperty to the Property Manager.? A property manager can manage multiple sale/or rent properties. ? A property manager manages two types of property, property for rent and property forsale.? Solicitor can be involved in multiple properties transactions of either buying or rentedoutAssumptions? A property manager may supervise other property managers. It stores Manager Id andthat is the property manager User Id for those managers who supervise sub managers.? Property Owner can sell or rent out more than one properties which he owns. Eachproperty have a unique property ID.? Property table stores the property manager ID which manages the property andproperty owner ID who owns the property as foreign keys.? Customer can request multiple transactions to buy or rent property. ? Transaction table have a unique transaction ID for each transaction. It have customer IDand property ID as the foreign key. One transaction is used for each property which canbe either sold or rented out by the property owner.? Transaction table also have solicitor ID as foreign key if a solicitor is involved in the saleand rent of the property.Associative Entities? PropertyManager-Property associative entity: Many property managers can managemany properties. Hence there is a many to many relationship betweenPropertyManager and Property Table. PropertyManager-Property table have primarykey from both PropertyManager and Property table.? PropertyOwner-Property associative entity:Many Property owners can have manyproperties. Hence there is many to many relationship between PropertyOwner andProperty table. PropertyOwner-Property table have primary key from bothPropertyOwner and Property table? Customer-Transaction associative entity: Many customers can conduct manytransactions. Hence there is many to many relationship between Customer andTransaction tables. Customer-Transaction table hold the primary key from bothcustomer and Transaction tables? Solicitor-Transaction associative entity: Many solicitors can be involved in manytransactions. Hence there is many to many relationship between Solicitor and Transaction tables. Solicitor-Transaction table holds the primary key from both Solicitorand Transaction tables.Entity and attribute descriptions:PropertyManager :This table store the details of the property managers which manages theproperty ? PropManID - This is the unique ID of each property manager. It is a primary key? Fname- First Name of the property manager? Lname- Last Name of the property manager? Address - Address of property manager? City- City name of property manager? State- State name of property manager? Pincode - Pincode of city of property manager? Phone- Landline phone number of property manager? Mobile- Mobile phone number of property manager? Email- email address of property managerPropertyOwner :This table store the details of the property owner who owns the property ? PropOwnID - This is the unique ID of each property owner. It is a primary key? Fname- First Name of the property owner? Lname- Last Name of the property owner? Address - Address of property owner? City- City name of property owner? State- State name of property owner? Pincode - Pincode of city of property owner? Phone- Landline phone number of property owner? Mobile- Mobile phone number of property owner? Email- email address of property ownerCustomer :This table store the details of the customer who wants to either buy the propertyor get it on rent. ? CustID- This is the unique ID of each customer. It is a primary key? Fname- First Name of the customer? Lname- Last Name of the customer? Address - Address of customer? City- City name of customer? State- State name of customer? Pincode - Pincode of city of customer? Phone- Landline phone number of customer? Mobile- Mobile phone number of customer? Email- email address of customer Solicitor :This table store the details of the solicitors who is involve in the buying or renting ofproperty with customer ? SolicID- This is the unique ID of each solicitors. It is a primary key? Fname- First Name of the solicitor? Lname- Last Name of the solicitor? Address - Address of solicitor? City- City name of solicitor? State- State name of solicitor? Pincode - Pincode of city of solicitor? Phone- Landline phone number of solicitor? Mobile- Mobile phone number of solicitor? Email- email address of solicitorProperty : This table stores the details of the property which is available of buying or rent bythe customers. The property is posted by the property owner? PropID- This is a unique ID of each property. It is a primary key? PropManID - This is the ID of the property manager which manages this property. It is the foreign key in the table? PropOwnId - This is the ID of the property owner. It is the foreign key in table? Address - Address of the property ? City- City of the property ? State- State of the property ? Pincode - Pincode of the city of the property? Area- Area in sq. ft of the property? BHK- Details of BHK in property? PropertyType - This could be either rent or sale depending on what the owner wants to do with the property.? DatePosted - Date when the property is posted by the owner? IsAvailable - Whether the property is available for sale or rented out or notTransaction:This table store the details of the transactions when a customer want to buy orrent a property? TranID- This is the unique ID of each transaction. It is a primary key? Date- Date of transaction? CustID- This is the ID of the customer who makes the application to either buy or rent the property. This is foreign key? PropID- This is the ID of the property which customer wants to buy orrent. It is foreign key.? Amount - The amount which customer offers to either buy or rent property? SolicID- This is the ID of the solicitor which is involved in transaction. It is foreign key "