Week 17 (4/28/2025 - 5/6/2025)

 (Click on READ MORE for better formatting)

    Hi everyone, welcome to my 17th blog! This is the Week 1 post for CST 363 Introduction to Database Systems.

  • Relational database tables and spreadsheets look similar with both having rows and columns. What are some important differences between the two? 
    • Database systems scale much better than spreadsheets as the size of data, number of tables, and number of queries all increase. This is because these systems structure data optimally and process queries as efficiently as possible. Much of this is not possible on a spreadsheet.
    • With a database you can also establish certain rules. For example, a UNIQUE constraint on the table element ID would restrict there from being two entries with the same ID.
  • Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file.  What are some important reasons that makes a database a useful investment of time? 
    • It is worth the time investment especially if you know the database is going to get large, for the reasons underscored in the first bulletin.
  • What do you want to learn in this course that you think will be useful in your future career?
    • I am very much interested in learning about database systems in general, as I will more than likely be working with them often as a software engineer as the software often needs to fetch data from somewhere... such a "somewhere" is oftentimes a database system.

That is all for this week, see you in my Week 18 post!

Comments

Post a Comment

Popular posts from this blog

Week 32 (8/13/2025 - 8/15/2025)

     (Click on READ MORE for better formatting)      Hi everyone, welcome to my 32nd  blog!  This is the Week 8 post for CST 334 Operating Systems. Write a 1-2 paragraph journal post, of at least 250 words, summarizing what your biggest takeaways from CST334 were, including any major challenges or topics you found particularly interesting. One of the major challenges in this class (at least for me) was wrapping my head around some of the long math-style problems that have been seen throughout the course. Thankfully, I was able to get a lot of practice with these through labs, ungraded practice quizzes, Midterm Preparation Quiz, and Final Exam Preparation Quiz. In addition, members of my team were able to help me better understand what was needed to tackle these problems. For example, Wootark Kim (Tom) made a step by step video for me and the rest of Silicon Surfers that explained how to do CPU scheduling problems featuring the RoundRobin policy. V...
Read more

Weeks 41 - 48 (10/26/2025 - 12/19/2025)

     (Click on READ MORE for better formatting)      Hi everyone, welcome to my 41st-48th  blogs!  This is the Week 1-8 post for CST 336 Internet Programming. Similarly to CST 311 Introduction to Computer Networks, while journal entries were not required  for this particular course, I wanted to document the concepts and assignments from each week of class. If you would like to see some of these projects for yourself, this link acts as a homepage to visiting all of the projects described below! https://bevans34.github.io Week 1: HTML and CSS This week's primary focus was on learning/practicing creating a website using H yper T ext M arkup L anguage (HTML) and C ascading S tyle S heets (CSS). Highlights from this week included centering a <div>, which is probably one of the biggest memes to ever come out of web development. Labs: 1 - ePortfolio Site In this lab, I created a site hosted on GitHub Pages that features a homepage, about page,...
Read more

Week 24 (6/18/2025 - 6/22/2025)

       (Click on READ MORE for better formatting)      Hi everyone, welcome to my 24th  blog!  This is the Week 8 post for CST 363 Introduction to Database Systems. Briefly summarize what you consider to be the three (3) most important things you learned in this course. How to query in MySQL and MongoDB, including select, insert, update, and delete. This also includes advanced querying techniques, such as subselect. Understanding schema structure of MySQL and MongoDB. After all, for the above to work you need a schema to create/use the database and establish table structures! Creating EER diagrams can also be bundled into this section as it is related to schema creation. How to take database systems and turn them into real-world solutions. For instance, using the JDBC API to create a webapp with a MySQL or MongoDB foundation. This was explored in group labs 19 and 21. That is all for this week, see you in my Week 25  post! Onwards to CST...
Read more