https://www.cs.vassar.edu/ 2026-04-12T11:38:05+00:00 https://www.cs.vassar.edu/ https://www.cs.vassar.edu/_media/favicon.ico text/html 2021-08-29T20:27:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/techref?rev=1630268848&do=diff Technical Reference Command Line Access (SSH Tunnel from laptop) From a local terminal window open up an SSH tunnel through mote to our postgres server: $ ssh -L 5555:postgres:5432 -p 443 username@mote.cs.vassar.edu where username is the name of your CS account. text/html 2021-09-28T15:54:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/top?rev=1632844460&do=diff Database Systems CMPU-311 Vassar College, Fall 2021 Syllabus / Course Wiki Welcome to our course wiki. It will be updated throughout the semester with important course information, so check here regularly. Contact Information Professor: 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-02T15:31:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/resources?rev=1630596691&do=diff Relational Databases * Software * PostgreSQL (RDBMS) * DBeaver Community (native IDE) * Here's a screenshot of how to configure DBeaver from a CS linux workstation: * And here's a screenshot of how to configure DBeaver with an SSH Tunnel from your laptop: * pgAdmin (browser-based IDE) text/html 2021-12-06T19:06:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/assigns?rev=1638817593&do=diff Final Projects Teams Team # Members Database Project [database name] Presentation text/html 2021-12-06T06:52:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/sched?rev=1638773548&do=diff Weekly Schedule * Week 1: Aug 30, First class * Week 2: Sep 6, Labor Day (no class) * Week 3: Sep 13, first queries of the CAP database * Week 4: Sep 20, nested queries * Week 5: Sep 27, join queries * Week 6: Oct 4, data normalization (poster), brainstorming project ideas 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 text/html 2021-09-20T18:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week4?rev=1632162591&do=diff Week 4 Nested Queries Querying the CAP Database on our postgres server: * CAP database creation [script] * [CAP snapshot] * Starter script: [cap-queries-nested.sql] * Class exercise: solutions to queries Reading assignment for next week: * zyBook Chapter 3: Database Design HW for next week: text/html 2021-11-01T18:36:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week10?rev=1635791766&do=diff Week 10 Importing Data into Tables from CSV files Here's a reference on how to import data from a CSV file into a table via psql: <https://codeburst.io/two-handy-examples-of-the-psql-copy-meta-command-2feaefd5dd90> text/html 2021-09-20T18:25:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/sidebar?rev=1632162327&do=diff CMPU-311 * General * Schedule * Assignments * Resources * Tech Ref * zyBook * SQL Cheat Sheet * PDF text/html 2021-10-05T05:49:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week6?rev=1633412950&do=diff Week 6 Data Normalization From the 5 Rules of Data Normalization [poster]: * Unnormalized data * redundant and repetitive data (jagged length rows) * 1st Normal Form (1NF) -- eliminate repeating groups * 2NF -- eliminate redundant data * 3NF and 3.5NF