
Database designer
- or -
Post a project like this4073
£250(approx. $334)
- Posted:
- Proposals: 7
- Remote
- #533126
- Awarded
Responsive Websites, Membership Websites, Ecommerce, Bespoke Custom Solutions, C#, Angular, Python, Azure, ASP.net Core, Sql, CSS, HTML, Web development

6249692197783549560083413882415383280167





Description
Experience Level: Expert
General information for the business: We work in the same field as http://www.checkatrade.com/
Description of requirements/functionality: Hi,
Our company is quite similar to Checkatrade.com, however, we offer this service in a different country. As I am not very technical, I am not sure how this should/could work.
At the moment we are using Access to enter the details or our clients (first database) and providers (second database) . The idea is to combine both databases in just one. The ideal database would need to provide the following:
- Details of our clients (name, email address, telephone number, description of the job needed and date when first contacted us. Extra space for notes and the sort of trader that the client is looking for – plumber, builder etc)
- Details of our traders (name, email address, telephone number, date when first contacted us, space for full physical address and space to enter if they have a complete or partial partnership with us.We also need tick boxes to show if they have a silver membership , gold membership, or diamond membership)
- We need to be able to enter the name of a trader in a search box to find out the details of the clients which we have referred him to;
- We need to be able to enter the name of a client in a search box to find out the details of the traders which we have referred him to;
- As soon as we have a new client looking for a trader, the database would automatically pick up the traders that this client needs to be referred to. The database must pick up the traders that are in the same area where the client is based.
-
- If possible, we would like to have access to this database even if we are not in the office. A cloud solution could be a good idea;
This is the main idea. Other things may come up during the project, but nothing major.
Please send me your quotes and how long you may need to get this done.
Thanks
Extra notes:
Description of requirements/functionality: Hi,
Our company is quite similar to Checkatrade.com, however, we offer this service in a different country. As I am not very technical, I am not sure how this should/could work.
At the moment we are using Access to enter the details or our clients (first database) and providers (second database) . The idea is to combine both databases in just one. The ideal database would need to provide the following:
- Details of our clients (name, email address, telephone number, description of the job needed and date when first contacted us. Extra space for notes and the sort of trader that the client is looking for – plumber, builder etc)
- Details of our traders (name, email address, telephone number, date when first contacted us, space for full physical address and space to enter if they have a complete or partial partnership with us.We also need tick boxes to show if they have a silver membership , gold membership, or diamond membership)
- We need to be able to enter the name of a trader in a search box to find out the details of the clients which we have referred him to;
- We need to be able to enter the name of a client in a search box to find out the details of the traders which we have referred him to;
- As soon as we have a new client looking for a trader, the database would automatically pick up the traders that this client needs to be referred to. The database must pick up the traders that are in the same area where the client is based.
-
- If possible, we would like to have access to this database even if we are not in the office. A cloud solution could be a good idea;
This is the main idea. Other things may come up during the project, but nothing major.
Please send me your quotes and how long you may need to get this done.
Thanks
Extra notes:

Vinicius R.
100% (6)Projects Completed
4
Freelancers worked with
4
Projects awarded
22%
Last project
15 Aug 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies