Week 02 - CST363-30-2253- Intro to DB Systems

 Flavio Cervantes
05/23/2035
CST363-30-2253
Weekly Journal 02


1. SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).    Most of the time the join will use equality between a primary and foreign key.   Think of example where joining on something other than keys would be needed.  Write the query both as an English sentence and in SQL.  If you can't think of your own example, search the textbook or internet for an example.

- English sentence: Assuming there’s an online car dealership website similar to CarMax, you’re searching to buy a daily driver, but need to filter a min and max price range. That way it’s not too old, but at the same time it’s not a new release that’s out of budget. 

 - The cars table stores info such as price, model, make. 

- The customer_search table stores MIN/MAX per individual customer.

- SQL: 

SELECT 

c.id,

c.price,

c.model,

c.make,

c.price,

cust.customer_id

cust.budget_min,

cust.budget_max,

    FROM 

customer_search cust

JOIN 

    cars c

ON 

c.price BETWEEN 

cust.budget_min

AND

cust.budget_max;

2. What is your opinion of SQL as a language?  Do you think it is easy to learn and use?  When translating from an English question to SQL, what kinds of questions do you find most challenging?

SQL as a language is very well designed, it is not easy to learn because there is so many different functions and it can get very complex, but if we break each query down into smaller queries, then it is easier to understand and utilize. When translating from English question to SQL, the most difficult part is trying to remember or research what function can be used to properly solve the question being requested in the most efficient manner & to order everything in a logic manner, where it'll execute the query systematically. 


Comments

Post a Comment

Popular posts from this blog

Learning Journal - CSUMB - January 6, 2025

 Greetings,     This week I learned about the campus of CSUMB, and how it was a military base before officially becoming a CSU in the mid 90's. The vision of our school is based on collaboration, teaching us skills that are essential for the modern workforce, and to provide the best possible curriculum with relevant technologies that will help us excel in our future, if we do our part and endeavor the challenges that Computer Science conveys. I also learned about the different ways to format APA style, depending if it is a website, book, or personal interview. At my previous schools, we would utilize MLA, so this is a great learning experience.  I also refreshed on the importance of plagiarism, and why it is extremely important to do on our work, even with all the tools we have such as AI, 3rd party websites, etc. The challenge I overcame this week was to have a deeper understanding of how Dynatrace operates, and all the different components that shape a successf...
Read more

Learning Journal - Week IV

     Educational Goals My education goals in the CS program are to strengthen my engineering foundational skills. I also want to strengthen my programming skills by expanding my knowledge in python and Unix. I am working on obtaining a stronger understanding in machine learning, artificial intelligence and software engineering. This will be accomplished by working on small scale assignments or projects that introduce me into these respective technologies.  Career Goals My career goal is to continue to promote within the company I am currently working at or to move to another company and take on a more challenging engineer related role such as an Architect III or  Software Engineer. Wild guess of your percentile of the ETS Computer Science test After viewing the ETS page, test description and sample test I feel that this test will challenge me greatly but is a great standard as a computer science major. The percentile that I feel I will obtain is arou...
Read more

Learning Journal - CSUMB - January 15, 2025

Image
      Lecture: Week 2 Learning Journal Post      Part 1: Review and Reflect Learning Strategy       The tops three areas that I am good at is to stick to my schedule, unless an emergency comes up, I like to stick to my schedule from the beginning of the day, until the end of the day. I am also good at studying when I have "planned" for it, I usually plan my studies in the evening and over my online educational journey, I have been disciplined enough to stay on track. Lastly, I am good at thinking skills, I can think critically, and come up with ideas or a desire to research something and learn about it. This ability is used in our everyday life’s, at home, while studying, and at work.  The top three areas that I feel I am weak in is where to study, sometimes it is easier to study at home but that is where I can easily get distracted at. I also feel that I am weak in is reading, sometimes when I am tired, it is hard to read all the m...
Read more