The Knowledge Center for Coastal Tourism (in Dutch: Kenniscentrum Kusttoerisme) has developed and maintained dozens of databases on tourism data in Zeeland. These databases are used by the government to create policy, subsidies and even laws. The databases are getting harder and harder to update over the years. This can have multiple reasons, such as companies switching from name and thereby “deleting” the history you had on them. But also companies that have existed under the radar for years, and now suddenly pop up in the new dataset while they should have been there for years.
Now’s the time to make an application to manage these databases better, and most off all: make them fault-tolerant and easy to update.
One of the tasks is to have a UI that allows for easy updates. Most data is gathered in Excel sheets, that employees of the Knowledge center now have to cross-reference against all the databases for mistakes, and then input the things manually. This is fine for a few rows, but the average update contains a few thousand edits and they happen 3-4 times per year.
Your internship is to create a code review-like UI that ingests the Excel sheets, automatically cross-references them against the correct databases, shows the additions, the deletions and the edits. And finally allows the employees to make changes if they find mistakes in the data.
You will work together with a software engineer and other intern (who focuses on the backend of this app).