Posts

Showing posts from December, 2022

Fall 2022 DB Project

    Throughout my undergraduate education and research, using spreedsheets has become like putting on pants. It provides many useful recording and analytical tools to manage. However, this semester I was introduced to relational databases, which seemed like pants that were much more difficult to get on. At first, I was really confused about everything from the terminlogy to the navigation. After working through the assignments and projects, I feel a lot more confident in understanding relational databases. I've found that they remove a lot of redundancy in data, and I particularly like tables that break it down in to smaller parts. Relational databases also are nice if you're sharing access with others and if it needs to be modified by others. Spreedsheets have more repeitition and aren't great for combining related data as concisely.      In class, we had to explore databases and apply our knowledge in a database project. The first project was to take a csv of data and cre