====== Week 5 ======

===== Join Queries =====

{{:courses:cs311-2021:joy-of-joins.png?nolink|}}

Querying the CAP Database ((with thanks to Alan Labouseur for permission to use his materials!)) on our postgres server:
  * CAP database creation {{ :courses:cs311-2021:cap.txt |script}}
  * {{cap.pdf|CAP snapshot}}
  * Starter script: {{ :courses:cs311-2021:cap-queries-joins.sql.txt | cap-queries-joins.sql}} 
  * Class exercise: solutions to queries


**Reading assignment for this/next week:** \\ 
  * zyBook Chapter 3: Database Design 

**HW for next week:** \\ 
  * Brainstorm final project ideas
  * What kind of database would you like to design/build/query
  * Think about: existing source(s) of data
  * Think about who you'd like to partner with
    * teams of 2 would be ideal (but we have an odd number of students, so...)