Posts

Showing posts from December, 2022

DB Project Recap

      Our topic this semester was focused on relational databases. Compared to previous topics, this was the most time-consuming and complex. One of the biggest takeaways from using a database rather than a spreadsheet is to remove redundancy. We can also break down data into smaller parts. These databases contain a collection of related data and a single copy of the data. We can create relations within our database. Connecting the number of tables together. This just makes viewing the data much more manageable compared to spreadsheets.     Over the course of the Semester, we were given the challenge to create and design a database. Within my group, we selected the Drugs dataset on corgis. This contains rows of data. Much more data than what I am used to seeing. Our job was to break down the data into different tables. While using SQL to help us query and export the CSV files into DB Browser. In the end, we are given a database with the number of table...