Week 5

Querying the CAP Database ¹⁾ on our postgres server:

• CAP database creation script
• CAP snapshot
• Starter script: 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…)