CST363 Module 2

 1. An example of joining two tables on anything other than two keys would be performing a cartesian join, where you want to find every possible combination of multiple columns such as wanting to find every possible combination of meal and drink in two data tables where the first table contains every drink selection and the second table contains every meal selection.

Such as join can be seen as SELECT drinks.name, meals.name from drinks, meals

2. SQL is so far an alright query language. I have yet to use anything else so I don't have any reference points. I do believe that it is quite easy to use and learn, the translation from English to syntax isn't too big of a jump. The most difficult kind of requests to translate would be ones that need to rely off of multiple nested queries to grab data out of a target table.

Comments

Post a Comment

Popular posts from this blog

CST489 / 499 Week 10

  5pt: What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall. This week I was able to complete the objects for our applications logs. 5pt: What is your plan for next week? I plan to finish the controllers to add, remove, update, and view these logs. I will also look into tackling a systems test for logging in. 5pt: What challenges, if any, are you currently facing in project development? Do you need instructor assistance? We aren't facing any extra challenges.
Read more

CST489 / CST499 Week 12

  5pt: What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall. We have the front end completely secured due to needing to have it ready for a public facing domain. Our user pages are also making headway into a final stage. 5pt: What is your plan for next week? We plan to continue work on the front end for our user pages while also getting our application running on AWS in some form. 5pt: What challenges, if any, are you currently facing in project development? Do you need instructor assistance? N/A
Read more

CST489 / 499 Week 16

  For this week, please spend time browsing through your two years of journals and reflect on your overall experience and growth in the program. Some thoughts on future plans would be great, also.   This program has been an interesting two years, we've gone over so much material and yet I know I have so much more to learn just due to the nature of this field. I hope to continue to grow as I have these past 2 years and into a position where I can leverage my new skills.
Read more