DB Project Blog, Stem Success 394
After this Stem Success course, I feel that spreadsheets are incredibly limited in what they can do. Spreadsheets are good for small datasets but fall apart once you have too much data. Databases can not only pull from multiple external tables but the ability to query with SQL and find specific data you need as well as organize them makes databases much more robust. Relational databases are also great because they can be updated automatically due to their relational nature versus spreadsheets which have to be manually entered and updated every time. This also means any changes to databases can be tracked easier than spreadsheets. In the Database Project, we chose the Hydropower dataset from CORGIS website. From a surface level look, the dataset in CSV form shows a single table about hydro-powered dams with their name, when they were made, from which organization,...