https://www.cs.vassar.edu/ 2026-04-14T21:58:58+00:00 https://www.cs.vassar.edu/ https://www.cs.vassar.edu/_media/favicon.ico 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-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-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-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 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