Uncategorized

Halfway through this course, I now better understand significantly both the theory and the practice of database systems. Here are five important takeaways of the first portion of the class: 1. The Relational Model and Its Relevance I learned how the relational model forms the basis of contemporary data systems, structuring data into tables with […]

Example of a Non-Key JoinWhile most SQL joins are performed using primary key–foreign key relationships, there are situations where a join is based on a non-key condition. For instance, consider the following scenario: we want to identify employees whose hourly wage exceeds the budget-per-hour allocated to certain projects. This allows management to quickly identify assignments

Example of a Non-Key Join:  In most practical scenarios, SQL joins aren’t limited to primary key–foreign key joins. Instead, data might be joined by comparisons, ranges, or some other business rule as determined by analysts or developers. For instance, let’s say we’re interested in finding employees whose hourly pay is higher than the spend-per-hour available

Orientation and readings this week gave me a good grounding in the necessity of relational databases within data management. At first glance, relational database tables are similar in many ways to spreadsheets—they’re rows and columns and are utilized in organizing data. However, one significant difference that I was taught is that relational databases are more

Looking back on HW1 from early in the semester, it is clear to me how much progress I have made as a programmer. At that time, I would approach problems with a more try-it-and-see method, often resorting to guessing over planning. Now, I to revisit HW1 today and I would first break down the problem

I spent this week on the Markov assignment and teamed up with my fellow student Taylor, also receiving 19.5 out of 20 for the project. Both of us treated the assignment consecensively and not only considered making the code work but also how to make the code more beautiful and user-friendly. Teamwork helped us to

With whom did you work?I worked with Branden Woods, Richard Alvarenga, and Taylor Farner. We shared our approaches, reviewed each other’s code, and gave feedback on how closely we followed the Google Java Style Guide. We also discussed what strategies worked best and what we might do differently next time. What was your strategy for

Review: Brandon WoodsGeneral OverviewBrandon’s Hangman implementation is exceptionally clear, well-documented, and efficient. Itdemonstrates strong object-oriented design and precise logic flow tailored to assignmentrequirements.Variable Names:Descriptive and follow conventions: secretWord, remainingGuesses, numberOfHints.Constant PLACEHOLDER is properly uppercase and meaningful.No changes needed.Logic & Efficiency:chooseWord()): Effective utilization of while loop to avoid repeats.getHint(): Hint provision optimization with early break.makeGuess(): Clear

During Week 1, I worked on Lab 00 and Lab 01, which introduced foundational tools and concepts like Git, GitHub Classroom, IntelliJ, unit testing, and Java interfaces. Lab 00 was a setup-focused assignment that ensured our development environments were properly configured. This included learning to use Git commands like git clone, git add, git commit,

Learning Journal: Solving CodingBat Challenges (String-1, String-2, Array-1, Logic-1, Map-1, Functional-1) During my work on the CodingBat challenges in Java, I focused on six key sections: String-1, String-2, Array-1, Logic-1, Map-1, and Functional-1. Each section presented different types of problems that required varying approaches and problem-solving techniques. Approach and Planning For most problems, especially in