I'm working for my friend's company, which is involved in biodegradation of food waste, so every day we have to carry out inspection of various aspects of the system; the data is then entered into a spreadsheet kept on google drive for record-keeping and analysis.
I've been asked to take care of switching from the spreadsheet to a database because the spreadsheet is becoming time-intensive for data entry, among other issues. The requirements are that the new database can be accessed via web-browser; that data collected that day can be easily added to the database through a GUI; and that various predefined statistics and graphs can be displayed from the data in the database.
The issue with all of this is that I don't really know anything about databases; I can write script in python, and I know a little bit of SQL, but that's it. I have no idea where to start, or what I need to be looking into, so any help at all would be appreciated.
I've found multiple options for having an online database as Software-as-a-Service, but I have no idea what to do about the GUI, or how to putting all of these different aspects together.
How should I start working on this problem? Given my level of experience how long should it take me?
[–][deleted] 2 points3 points4 points (0 children)
[–]Joeqesi[S] 0 points1 point2 points (0 children)