STEM TRAIN: databases Well, aside from this crash course, I initially had zero understanding of either! Throughout this semester though I definitely learned that databases are much more complicated (to me) and they go farther in depth than a spreadsheet would. They allow for specific questions to be asked about the data at hand. They pull information from other tables that are made whereas a spreadsheet would just organize the data into cells. I guess a 101 explanation would be that spreadsheets are "2D" and databases are "3D". At least, this is how it makes sense to me when trying to determine the difference. So our project consisted of a csv file with raw data. My partner and I chose mortality statistics of opioid users. We were instructed to create and ER diagram that would explain the relationships between each "category" within our dataset (person type, drug type, etc.). Once we figured that out, the hard work began. We learned how to use software to...
Posts
Showing posts from November, 2022