CST 363 Week 6

Summarize what you have learned this week. 

This week, I learned that programming language tends to be categorized between being imperative or declarative. In imperative language, the statement flows are controlled so they are executed in a specific order. On the other hand, declarative language lacks this controlled flow because the statement declares the desired result. Declarative language tends to be the choice for database queries due to the ease of programming and time to execute the queries. I also learned that SQL statements can be embedded in the host language of the program where it then gets translated by the pre-compiler. This will require that the programs are connected to a database prior to executing queries, which allows the database to be accessed. The same can be done vice versa, where the host language can be utilized in SQL statements when declared between 'BEGIN DECLARE SECTION' and 'END DECLARE SECTION'. As a result, it is possible to create database programs using other programs, such as Java. The important thing to remember is that Java does not support the use of cursors. Cursors are embedded SQL variables that helps identifies a row of a table. Rather, the data must be fetched with the help of the 'ResultSet' interface, which will return an object containing the query results.

With all this new knowledge, I learned how to connect my Java program with my database. This is exciting to me because at the start of this course, I thought use of databases are very helpful but I could not understand how it could be helpful when users are going to want an easy-to-navigate GUI. Now I have a much better understanding. 

Comments

Post a Comment

Popular posts from this blog

04 February 2025

Interview with Bill McDermott The expert I decided to interview within the industry is Bill McDermott, the Technical Director of Test Operations at General Atomics. Bill is responsible for the research and development of the technology used and also manages special projects. He used to be the supervisor for my current mentor in the company, Roy Lara. It is through Roy that I became acquainted with Bill (I have a different supervisor). Now Bill is managing the Collaborative Combat Aircrafts (CCA) project for a contract we recently secured with the Air Force. I chose Bill as the expert I wanted to research because he is not only very knowledgeable, but the impression he leaves on me is different compared to other higher-ups in the company. Unlike other supervisors, Bill is rarely found in his office, but rather working hands-on tasks on the floor, whether it be routing fiber or connecting the different systems that compose a Ground Control Station (GCS). Bill is also personally writing...
Read more

Week 7

  Homework One assignment was the Markov Prompt. It read a text file and generated a collection of words and those that followed it to generate a new text. Sometimes the new sentences made sense and sometimes, they were just strange. It is funny to think about how I thought it was such a difficult assignment, but looking back, it was the only one I managed to get all the tests to pass on. I think I had the best approach with it so far, reading the prompt for understanding, then going through it once more to set up skeleton methods, prior to writing the code. How I would approach it differently is to sit down and think about my approach a little more. The prompt seemed so thorough and like it covered everything, that I just went for it. However, when it was time, I got stuck on areas like addWord and getSentence for DAYS because algorithms matter. I would also better organize myself with each method by creating a chart, because as I worked on some of them, I realized it made calls t...
Read more

January 21, 2025

Image
Review and Reflect: Based on the Effective Study Skills paper, three areas that I am strong in are: scheduling my study times, surveying what I am going to be studying, and reciting. I start out every week reviewing all the assignments so I can decide what will require more of my time. I set aside 1.5 hours after work to go to the gym and shower then understand I will get straight to studying afterwards. I tend to talk to myself a lot for anything, even reading a word I never seen before. I will say it out loud to make sure I understand it. Three areas that I think I can improve on is: reading, reviewing, and true-false questions. I find myself constantly getting in a cycle of reading and not really comprehending what I just read, so I have to reread the material. As I am usually in a rush, I don't review enough if I feel like I got it. My test scores sometimes beg to differ. But this also correlates with the fact that I tend to overthink small details in true-false questions, ofte...
Read more