CST-363 Week 2

 

  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.
    1. You want a combination of ingredients to create a food item. Ex: SELECT f.name, i.amount, i.name FROM food f CROSS JOIN ingredient i;
  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?
    1. I think SQL is not very difficult to learn. Some of the more challenging questions are ones that involve multiple JOIN statements, which may be a bit more difficult to think of an abstract solution.

Comments

Post a Comment

Popular posts from this blog

Week 5

 Part 1 Support Teammates' goals. Teammate comment (Ysabelle):  CST300 Week 4 Second comment (Faith):  Week 4 Learning Journal Part 2 Possible Capstone. I am mainly interested in mobile development, so I think some possible capstones I could work on could have the goal of making user's life more convenient.  An application for businesses to create a virtual loyalty card which allows them to send a text message of a user's QR, so they can scan their card and "punch" it. An application for users to track their workouts. They will be able to create custom workouts and track sets, rest time, reps, weights, etc.  A third idea could be working on an existing application that allows open contributions from students. Part 3 Learning Journal AI In Writing Using AI to complement your writing can benefit you by improving your reading efficiency and content creation. Instructive prompting: Used to guide your AI to a specific task. Output must be inspected to ensure it is re...
Read more

Week 4

Part 1 Educational Goals. My main educational goal is to achieve my bachelor's degree in computer science in 2 years. Another educational goal of mine is to do well in my upper division classes so I can be prepared for a career in software development. I would also like to strengthen my collaboration skills through the use of group projects.  Part 2 Career Goals. One of my main career goals is to become a professional software developer after graduation. I hope to leverage my current internship as an Android developer to find a new internship next summer, so I can explore different fields in software development. Part 3 Guess ETS percentile. If I had to guess, I think I would be in the 70th percentile. I feel pretty comfortable with programming, but I think I would struggle more with the theory-based questions and would have to review my notes from discrete/data structures beforehand.  Part 4 Learning Journal.  Writing material:  For my Ethics essay, I will need to c...
Read more

Week 2

Image
Part 1. The top 3 items I am good at is taking notes, reviewing easy questions on exams first, and setting a schedule. I think one area I could improve on is asking the right questions. Part 2. Log        Part 3 Project Management basics.      Companies have experts that focus on project management. A board of directors will decide on a project to be completed while a project manager essentially acts as CEO over that project. The work breakdown structure is a fundamental tool of project management. It is common to break down projects into its own products/deliverables. To create a work breakdown structure, you create a hierarchical decomposition of all the deliverables. Level 0 is the project. Level 1 is the Keyline (organizing principles). Level 2 is the Major Deliverable. Level 3 is sub-deliverables (helps meet end deliverables). Level 4 and further decompose sub-deliverables. Finally, get feedback before presenting final work breakdown structure. Ea...
Read more