I need you to develop some software for me. I would like this software to be developed using SQL. Build a dynamic database to track property information and lead/people information
A dynamic database with two key parts that ideally are able to talk to eachother:-
1. Property Tracking
For the Property tracking system we will need a database that our team members in-house can input information for each property for and that can handle missing information as when the system is ready we will input the data in ourselves.
Basically, the information needed to be inputted and used is Address, Postcode, Shop name, Use, Whether or not it is available, Whether or not it is a clients property, Floor sizes, rental, lease expiry, lease start date, next rent review, premium (if any), PDF attachments and image attachments along with a date for last updated for each property for 460 such streets that we will be tracking and it would be good to have them in the same database and then be able to search and filter… I just need this spreadsheet(s)/database designed for use when we program the functionality required
I envisage the software/program to automatically generate a document reports in our own predefined template, filter by each column, create a document in our own template of an individual property, and be able to click to open the PDF/Document/Image attachments [ie photos, brochures, floor plans etc] for any given property.
A solid search/filter function where we could search by Floor area, street, postcode (Partial) etc will be required. The filters should be able to separate results by whether they are available or not, whether they are one of our clients properties or not, or by any other criteria in the database…
In the future we might add a map view/mapping solution to map this data… But not until the rest is solid and usable…
2. People tracking
We need to track our clients with all their contact information and also a list of their requirements which includes floor area ranges, rental and premium budgets, and locations which could range from one specific street to a postcode to a list of streets or the whole of Central London and beyond…
We need to track potential leads and prospects.
Also, we need to input and be able to search requirements which are not our clients with the same information as above.