Online database

We are a small recruitment agency that supplies temporary care workers into care homes. We looking at having a Database custom built for organising and logging our staff bookings and producing reports along with general data management.

Currently we subscribe to a software provider and would like to be able to replicate most of the functions of that system to our new database.

Please could you quote us on having this system designed and built, there would normally be 1 user using the system , however would be good to have a multi user system in case 2 people access at any time, also if we wanted to migrate this system to the cloud so we can work from any location.

I have attached a screen shots of the current system we are using, it is built using oracle and is hosted in the cloud.

From the front end Fig 1 you may be able to get a good idea of the general detail.

The way we operate is normally shifts are emailed to us sometimes in an excel attachment which we can upload by amending the spreadsheets so that it maps the template provided by the current software. They can also just be emailed and occasionally over the phone.

We then log this information into our system, firstly we select the home in the first column using the drop box, we then select the date using the calendar tool, then we select the shift type using the drop box(there are several shift types abbreviated e.g. a long day would be LD, an early shift would be E, and a Late would be L and so on, etc). Then we type the start and finish time of the shift, the total units/hours is automatically calculated, then the staff is selected using the drop box and after we select the status( this could be covered/cancelled/no show/outstanding etc). We then type the reference number in the PO field and we have a couple of columns for notes then final column states the name of the user who has input the data or made the last change. The PO Ref tab should not accept duplicate numbers, finally we can tailor a report by filtering any column and hitting the refresh button, this report can them be downloaded to a excel spreadsheet.

• The back end would be to Input homes that we supply see fig 2,

• Report tab Fig 3 should filter the data to a customised excel spreadsheet that we can download, we will supply the format that we want the data in( the system we are currently using does not do the reporting as the developer has not fixed the system)

• Enter Staff Tab Fig 4 is where we can enter all information on staff and upload docs, there are sections where we can input visa and DBS expiry dates this should flag up and not allow us to book the staff if their Visas have expired etc, the current software does not actually do any of that as developer hasn’t gotten around to fix that. However I will leave this to your selves to advise if it can or not be done.

• The view staff tab simply shows the status of data that we had input in enter staff tab along with an action tab as in the attachment.

• Lastly the data load tab Fig 6 is used when homes send shifts on a spreadsheet, we normally copy the data onto the template and upload it from here.

What I am looking for is a system that doesn’t necessarily have to be exactly as the one described, if it could be done in a more efficient way to capture the data that we need and maybe improve on this model as we have been using it for a few years without any updates or changes.

Would be good to have more useful features such as being able to know who can work in which home and if they would be available, although our current system has a tab stating who is available, it doesn’t work or do anything.

I would be grateful if you could let me know if there is a solution that can be created using sql and all costs associated with that, I am open to different ideas as there may be better solutions and more advance features we can have.


Skills: Database Programming, MySQL, Oracle, PHP, SQL

See more: online database builder, online database examples, free online database hosting, google online database, free online database with api, free online relational database, free online database for android, online database software, online database interface user friendly, online database client log, create online database post csv, php mysql database populate form selected, query online database asp, design online database windows, create online database free, extract online database, build secure online database, save online database, grab data online database, review online database forms

About the Employer:
( 0 reviews ) London, United Kingdom

Project ID: #18551293

55 freelancers are bidding on average £1457 for this job


Hi, I've read the project description and definitely can develop the online database. I'll provide you with the highly skilled & dedicated HTML, PHP, JavaScript, MySQL, front & back-end development services and complet More

£2500 GBP in 20 days
(421 Reviews)

Hello, I have checked your requirement with attached PDF files. We will definitely assist you on your Online database creation project. I am very much confident to deliver you desired work solution. PAST PROVEN More

£2300 GBP in 40 days
(177 Reviews)

Dear Employer, Greetings of the Day! Thanks for sharing your requirements with us. For your project scope, I would be really glad to let you know that you can hire from our team,skilled developers and profess More

£4117 GBP in 60 days
(154 Reviews)

Hello, Apropos your requirement, you need an Online database, we have shared our company portfolio please go through it: We have a team of professional Full Stack developers with an experience of more than 8+ yea More

£1000 GBP in 20 days
(184 Reviews)

Hello, We are here a professional at web-crafting on various platforms as web development, mobile application development (IOS / Android). I went through your requirements and red all PDF you attached. It looks p More

£2700 GBP in 30 days
(58 Reviews)

Thank you for looking at our bid, sorry for exceeding max budget. Would like to propose a multiple admin CRM - something web based that can be hosted on cloud. We probably have to replicate all of the features you ha More

£3000 GBP in 60 days
(88 Reviews)

Sure, can custom built database for logging staff bookings and reports , but need to ask some points. So please send me a text message when you have some time to discuss further. For Now I am submitting a placeholder b More

£1000 GBP in 20 days
(48 Reviews)

Respected Sir/Madam, No need to go to cloud as it will cost you alot. Lets discuss Working in below technologies => Server Side Languages: VB.NET, C#, Delphi, Cold Fusion, PHP, ASP.NET MVC Razor => Client Sid More

£1500 GBP in 20 days
(228 Reviews)

Hello, Greetings!!! As per your requirement, you want a Developer who had knowledge of Database & Oracle so Developer can assist you Database Migration & Management. You have a website for a small recruitment More

£1529 GBP in 20 days
(99 Reviews)

Hello, we are experts in Database Programming, MySQL, Oracle, PHP, SQL, we can build your project "Online database" within your budget in freelancer prpvar_budget. Please contact for further details. Kind Regards, M More

£750 GBP in 24 days
(46 Reviews)

Dear employer. I have read your detailed description carefully. As a senior database programmer I'm very confident building efficient sql database. I worked 2 million records before so that I know how I can optimize d More

£1500 GBP in 20 days
(63 Reviews)

Hi, I can build this online database with usage of PHP 7.3 and Nette Framework + MySQL. As checked description and attached PDF all seems to be clear. In case you want some improvements different approaches (as you wr More

£1000 GBP in 7 days
(31 Reviews)

Hi, please check I do have worked on very similar two systems one for carer and one for security guard. [login to view URL] (its under development) [login to view URL] More

£2000 GBP in 20 days
(22 Reviews)

Hi there, I have checked the details I have rich experienced with Database Programming, MySQL, Oracle, PHP, SQL. Please initiate chat so we can discuss this job.

£1250 GBP in 20 days
(40 Reviews)

Hello, How are you? I have read your requirements carefully and being an experienced developer who has done extensive work in this part. I am confident that I am 100% suitable for your project. Look forward to worki More

£1250 GBP in 20 days
(13 Reviews)

Hi, I see you’re looking for somebody to create a software to be used online for managing the staff. I have checked all the attached screens and reports. We have good experience in doing such web applications. fo More

£1200 GBP in 45 days
(112 Reviews)

Hello Sir! I'm ready to take part in this project if you ok with my bid. Expert in C++, PHP, MySQL, JavaScript, jQuery, CSS3, HTML5, Java, A-Frame, Node.js, [login to view URL], Java, MQL, CGI, Google API, XML, JSON, SOAP More

£1500 GBP in 10 days
(22 Reviews)

Dear Sir, we made lots of crawler before and which is running in the market also we have team of data so please let us know how we can proceed for the same Thanks

£1500 GBP in 30 days
(21 Reviews)

Hello, We believe in small recruitment agency that supplies temporary care workers into care homes and that is why we had already build a CRM on (Healthcare Relationship Management Application) which focuses on all More

£2500 GBP in 45 days
(32 Reviews)

INTRODUCTION I can see you are interested in building database application for care and nursing home. I have studied your attachments and I have dome similar projects before. I can develop your database and schedul More

£1000 GBP in 25 days
(25 Reviews)