CST 363 Week 2

 1.  A table titled Store has columns  a key name, address, and average_price, a second table titled store budget has columns  a key name,  and budget join the two tables to show what store matches each budget. 

select s.name, s.address, s.average_price, b.name,  b.budget 

from store s

join budget b

on b.average_price<b.budget;

2. Sql does feel easy to learn and use because many of the key words follow along with how they work in the english language and it feels like I am just writing a sentence when I am writing rather than stringing together individual statements.  At the beginning of this week I had a hard time with join queries but the more I have done them the easier it has gotten.

Comments

Post a Comment

Popular posts from this blog

CST 370 Week 5

 This week we moved from learning how to read and understand algorithms, to a more direct approach to writing some of the more advanced algorithms that explore the more common mathematical and logical problems programmers tend to face. Learning about topological ordering, tree structuring, and quick sort was very interesting as these concepts are huge throughout the computer science landscape. COming off the test last week I feel reinvogorated to keep learning. 
Read more

CST 370 Week 2

 This week was very interesting, I had learned about time efficiency and Big O, Theta and Omega notation in the past but it was great to learn formal definitions and see some examples of how they can be applied. Understanding how to evaluate recursive algorithms was new for me and pretty difficult to understand at first but after reading the text book and other required materials it started to make a little more sense. I would like to continue practicing evaluating both recursive and nonrecursive algorithms  just to continue understand the asymptotic notations a little bit more. Overall it was a good week and the homework was challenging in a great way. 
Read more

CST 370 Week 4

 This week I was able to study some of the topics I struggled with in previous weeks like recurrence relationships. In preparing for the test being able to use two sheets of paper as notes was helpful for studying but also helpful for the test. A refresher on merge sort was also a welcome experience as well as the divide and conquer techniques. 
Read more