Blog - DB Project - Fall 2022
During the Fall semester of 2022, the LSC 394 class had the opportunity to learn about databases. Typically, in my experience, it is not uncommon that when one learns about something initially, in many cases this starts out as talking about the topic for a little while but never actually doing the thing until much later. In the case of LSC 394, the class had the chance to have hands on experiences working with databases in a short amount of time, which subsequently provided the opportunity to experience the differences between traditional Excel spreadsheets and relational databases created using SQL. To begin the semester, we practiced some more advanced techniques using Excel. In particular, using hurricane data we constructed a spreadsheet and did some basic analysis using built in commands. Some of the commands used were: if, vlookup, and countif statements. However, despite these clearly presenting useful procedures for obtaining information from the data used, it later became...