Week 17 - Database Management Fundamentals

-

This was the first week in the Database Management course. The transition from Software Design into this course was smooth and I’m looking forward to expanding my skills in data. It was fun working with SQL and Java and putting them together into real-world applications. I got hands-on experience with SQL queries, debugging errors and handling constraint violations, as well as understanding how Java classes can model and manipulate data efficiently.

Homework 1 involved executing a series of SQL queries on a small course database, just to get familiarized with SQL. The lab had me write queries to get information from the database, such as instructor names and salaries, with conditions like sorting and filtering by department. I practiced using SQL commands to reinforce my understanding of relational database structures through the use of joins, subqueries, and filtering.

Labs 1 and 3 had me work with SQL operations and focus on the manipulation of databases with inserting, updating and deleting records within relational databases. I also learned the importance of enforcing constraints such as primary keys, foreign keys, and checking constraints to ensure data integrity and consistency.

In Lab 4, I focused on designing and implementing Java classes to handle table-like data structures using Schema and Tuple classes. The Schema class defines the structure of a table by outlining column names, data types, and primary keys, while the Tuple class represents individual rows of data that conform to this schema. The assignment had me develop some key methods like insert, delete and lookup. It also helped me understand the importance of data encapsulation and schema validation. Lab 8 extended the work I started in Lab 4 by introducing predicate evaluation for database queries. This involved implementing basic query conditions like EqCondition, AndCondition, and OrCondition to evaluate where clauses in SQL-like queries using Java. The lab required me to create and understand a tree structure to represent complex conditions. It also had me implement the eval method in the SelectQuery class to filter data and project it based on specified conditions. Labs 4 & 8 gave me a better grasp of how logical condition evaluation functions and supports the process of querying in database systems. It was interesting to see how these concepts translated into code that can manipulate data.

These labs and homework assignments have equipped me with essential skills in database management. I’m looking forward to using the skills I have learned in these labs to tackle more complex data management concepts.

Comments

Post a Comment

Popular posts from this blog

The End of the Byte Trail

-
Image
Time really does fly. This will be my final journal entry, and it marks the end of Gerek’s “byte trail” and undergraduate journey in Computer Science at CSUMB. Looking back, I can see how much I’ve grown both technically and professionally. I’m glad I was encouraged to keep a journal because now I’m able to look back on my past entries to reflect on my growth. Throughout the program, I’ve developed a strong foundation in core computer science concepts like algorithms, data structures, databases, operating systems, networking, and software engineering. I learned important concepts for being a competent software engineer like documentation, testing, and clean code habits. I plan to carry these forward into my career. As I close out my chapter at Cal State Monterey Bay, I’m excited about the opportunity to step into the tech workforce. It seems learning in this field never truly stops, and I expect my education to continue evolving throughout my career as technology advances. I’m partic...
Read more

Reflections on Algorithms

-
On this week’s exam, I felt confident with core topics like merge sort’s Θ(n log n), and dense graph adjacency matrices. I know I'm able to apply some foundational techniques under pressure. However, I also made some mistakes that came from missing small but important details like carefully identifying the basic operation or following traversal conventions. I need to take a step back and think about both the big picture strategy and the fine details of implementation. This week also marks the halfway point of Algorithms, and I feel like my thinking has grown. It's been both challenging and rewarding because it pushes me to break problems down logically instead of leaning on my intuition - which I often do. I need to strategize more on how I analyze loops, recurrences, and data structures. It also helps to find solutions using precise mathematical notation. Even when I get questions wrong, I view it as an opportunity to sharpen my reasoning and improve my problem solving.
Read more

Refining Documentation and Planning Final Deliverables

-
This week, our team met with our clients Tian & Shuhe to go over the remaining parts of the project as we move toward final submission. During the meeting, we discussed the two different types of tests that will be conducted: a user test performed by Shuhe and a deployment test conducted by Tian himself. This meeting helped us understand what each evaluation will focus on and what we need to prepare for. Tian also requested that we create documentation for the project, specifically a README with a developer-oriented quickstart guide. I contributed to planning the structure and content of that documentation and began outlining what developers will need to quickly understand and run our system. Next week, our main focus will be making the README file, including setting up clear quickstart instructions. I will help consolidate our existing notes, scripts, and architecture explanations into a clean and easy-to-follow document. At the same time, we will begin preparing material for the ...
Read more