Database

Database design

Before designing the database, I created an ERD to see what columns I needed for my project. For this project, the ERD is quite simple because I am working with one schema consisting of four columns. Below you can see the structure of my database schematically in the ERD.

With the ERD as a base, the database can be set up in MySQL. That looks like this:

Image of working database

The data measured by the sensors is stored in the database. Here you can see what the working database looks like:

---

Last update: November 7, 2022