We are a small construction company that currently has a very old, outdated database system that has been written over the past 20 years in Visual FoxPro.
I have now been designated with the task of learning the new technologies and writing a new database system that is more modern and future proof.
Here are some key points :-
There is around 70-100 people accessing the database concurrently during the day, this may increase but is unlikely to reach more than 200 in the near future
Currently our largest database file is 475MB, with the total size of the database being a few GB
It must have an "easy" to program GUI that I can design and manage as there are many departments to our company who will all need different sections of a GUI
For now we would just like a desktop application however if it were
web based this would be an advantage, but in the future there is some consideration of allowing site managers to access the database at
head office through some sort of app or maybe even a web portalWe would like to host and write the solution ourselves rather than
outsourcing- We also need the application to be responsive, currently the desktop
application has one resolution that it stays out regardless of
whether it is being accessed via desktop or laptop. Now our employees have phones and tablets we would like it to be accessible and
responsive in the future - Finally the desktop application must be able to be used remotely via
Citrix. As we have a lot of employees working on construction sites
they must be able to access the database through a remote connection
I have spent the past couple of weeks doing research, I briefly touched upon MySQL at university so I can write queries and the such, I also touched upon programming in Java and C. I am confident I can learn the required programs/languages, however I am completely at a blank on where to start (there is too much choice to be honest!).
Could somebody give some advice on a solution that would fit this scenario, where I can design a database system for our company?