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 tables we design with the corresponding data. 

    Throughout the semester, I kept questioning how and why databases would be better. After having the group project, I can see why. Data is messy and it can be extremely large. Not all sets of data will be perfect. After designing and knowing what data you have. It can make the experience much more enjoyable. For the most part, you know exactly what to expect when creating the database and when you query. That is, after designing it. 

    As for any future plans, I can see myself working with databases or even creating one. This felt like a real project. Compared to other applied computing/computer science projects, this felt more real. I feel as if applied computing programming projects try very hard to slam one topic into your brain and the thing you are trying to program is very particular. However, not in a bad way. The projects can be fun and so can programming. But this was the first in my academic career where I felt like having a real-world scenario. Databases contain a lot to understand, and I may not be the best at them. But creating and designing them isn't bad. I would do it again.

 

Comments

Post a Comment

Popular posts from this blog

About Me

I'm a Senior at Arizona State University! Majoring in Applied Computing with a focus on Cyber Security. In my off time, I coach high school wrestling. Currently, my classes are; Network Forensics Analysis Wireless Networks, and Security Hacking for Defense Stem Success Global Justice I am very excited to continue my journey and learn about these topics. I feel good about my classes and expect a great semester. As my previous semesters have gone good since transferring to Arizona State. This semester, I aim to earn an 'A' in all my classes.
Read more

Mindsets

  When reading some articles revolving around the topic of mindsets, they had me thinking about the time I had to do a similar paper on growth mindsets. In my former class, Career Strategies and Personal Resilience, we dove into this topic within the first two weeks of the semester. We identified what type of mindset we had and maybe the reasoning behind it. At first, I believed to have had a fixed mindset. The feeling of being okay with where I was at, not having the motivation to improve on myself. After turning twenty-one, I suddenly had the desire to make a change in my life go back to school, and develop a more growth mindset. While reflecting on this, I was reading the article  “Students’ Mindsets for Learning and Their Neural Underpinnings”,  I was stopped at the entity mindset description. I used to believe that my intelligence was fixed and cannot be improved. Later the term incremental mindset was used, and this reflected the growth mindset. These same mindsets ...
Read more