Databases Project
This semester has been beneficial for me as I now understand a little bit more about databases. I honestly had not had much exposure to them before; if I had, I would have been very confused about them. In the past, I related a database as something that could only be physical (like a room where you save files and data), which did not sound appealing to me. But now, I understand that we have digital databases that make life so much easier for us when handling large amounts of data compared to using spreadsheets in excel or google sheets. Moreover, this class offered a project that helped us apply our database knowledge from a spreadsheet to the SQ lite database program. My partner and I chose to work on an Opioids dataset from the CORGIS website. This dataset focuses on the mortality rate of opioids categorized by year and people using the drugs (race, gender). The first step in building the database was to build an ER diagram, which was quite challenging initially. Secondly, we had to...