CST363 Week 4

CST363 Learning Journal - Week 4

In this course, I remembered a few things from the last time I took an intro to database systems course. I wish I still had the textbook from that class, I feel like it would have helped me with my studies. 

I've learned how query data from a database, and how to present it to the user with conditions. The different types of joins I had trouble with previously, but now I know how to use each one best. I've used ER diagrams to visualize the relationships in a database. I am more confident about reading ER diagrams, and understanding what they convey for a database. I remember the normal form rules from a previous class, and the zybooks textbook supplements this.

There are a few questions I still have about databases:

  1. I still need guidance on how to implement SQL into Java. Many of my implementations are researched from the Internet.
  2. I need to research more about MySQL Workbench 8.0, there are some issues that occur with large databases that I need to fix, like the lost connection error I get when creating in a large database. 
  3. How ordered indexes are implemented is still confusing to me. I understand their purpose, but I want to understand more about how they are created and maintained.
  4. Subqueries in SQL are a bit confusing to me still, though I feel like I end up creating over-complicated queries to start.

Isopod Update: ZooMed sells 'roly-poly kits' now? I bought one to try it out. I think the ventilation is too high, but that can be closed up easily with tape.

Comments

Post a Comment

Popular posts from this blog

CST300 - Week 4

Week 4 has been busy! I have gotten work done a lot later than I would have liked. Part 1: Education Goals My educational goals would be to expand my knowledge about Javascript. The most tangible project to put this in practice would be to create a simple interactable website, possibly using React as a frontend. One of my ideas for a capstone project would be to create a website for a tabletop game I am developing, so the practice would be great for it.   The first step would be to learn about networking -- CST311: Intro to Computer Networking and CST336: Internet Programming would be where I hone these skills. Before these classes, I would like to create a single-task web app as a practice. It would have a starting list of about 20 items, and allow the user to arrange them into 6 specific item slots, like a digital pin board. Then, once I am in these classes, I will look back at this project and see what I can do differently or what I have learned since then.   My web develop...
Read more

CST300 - Week 2

Image
CST300 - Week 2 Part 0: The CST300 Module 2 Lectures      The Peter Diamandis presentation "The future is faster than you think" provided the insight on how fast the world is operating, but at the same time, more people are gaining an education and are enabled by the internet to achieve more. I find that the talk was a bit self-serving, in that this talk was given at Brightline Initiative in the Silicon Valley, and not given in a country that is still underserved to this day. Searching the Singularity University up on Google did not give me a good impression of their current deeds either, with embezzlement, SA, and discrimination given to me first, then my actual question after (the location of the university, in Silicon Valley).      The article "The Future of Software Engineering: Key Emerging Trends in 2024" begins as a discussion about the current downward trend of software engineer openings. Much of the future of software engineering involves AI in so...
Read more

CST300 - Week 5

Part 1:  Support and Comment on Teammates' Goals My comment on Cody's blog.   My comment on Claudia's blog. Part 2: Capstone Ideas      I've seen two projects in Week 2: DriveDiary by Christopher McMichael & Jeremiah McGrath and Out of Mana by Nathan Simpson. These two interested me as ideas for a capstone project -- a web app for a project, and a video game.     The third project I viewed was Cue Tracer by Kyle Absten, which was a database of sourced audio log files. This one stood out to me as a good project that has a much wider audience than the standard computer science audience -- in this case: videography, filmography, broadcasting, the music industry, and others. Creating a searchable database that catalogues a specific hobby's published material can also be a good idea for a capstone project.    Three possible capstone projects for me are: A web app for an in-development tabletop role-playing game written by me. Th...
Read more