https://www.cs.vassar.edu/ 2026-04-12T10:39:07+00:00 https://www.cs.vassar.edu/ https://www.cs.vassar.edu/_media/favicon.ico text/html 2021-09-14T02:41:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week3?rev=1631587305&do=diff Week 3 Welcome back!! Querying the CAP Database on our postgres server: * with thanks to Alan Labouseur for permission to use his materials! :-) * CAP database creation [script] * [CAP snapshot] Class exercise: Use CAP to answer all of these query questions. Write only one query per question. Be certain to end each query with a semi-colon. Your final script should execute all of the queries in sequence from one command. Remember that CAP is one snapshot in time in the life of th… text/html 2021-09-27T18:29:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week5?rev=1632767365&do=diff Week 5 Join Queries 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