pretty cs4250 logo
Logo courtesy Wordclouds.com

California State University Stanislaus

CS 4250: Database Management Systems

Fall 2017

11:00 - 12:15 pm, Tu Th, DBH 101, Dr. Megan Thomas


[Syllabus ]        [Announcements]        [Calendar/Lecture Notes]        [Homeworks]        [Fun News]

Welcome to CS4250, an introduction to database management systems. Topics include:

Modeling, development, and implementation of database systems using storage structures, data definition languages, and data manipulation languages for the relational approach to database management. Database integrity and security problems. Historical development of database systems.

Prerequisite: CS 3100.

Announcements and Upcoming Events

11/11/2017 All students are being given one extra Late Day. (See syllabus for descriptions of Late Days.) I strongly encourage students to turn Part 4 in on the Tuesday deadline, and conserve your new Late Day to use on Part 5 or 7. But it is your group's choice; you may use the new Late Day on Part 4 if you wish.
11/10/2017 For those students who consider 20 (or 10, or 30) characters enough to store a human name, please take a look at the full name of Pablo Picasso, the famous painter.
10/9/2017 Here is a small chunk of the midterm you will take on Thursday.
10/3/2017 Deadline for Project Part 3 moved, to give students more time to revise Part 2 ER diagrams.
9/28/2017 Schema:
Earthquake (qname, date, latitude, longitude, magnitude, fault)
Damage(cityID, qname, cost, liveslost)
Cities(cID, cname, latitude, longitude, population) [city names may not be unique]
Questions (in SQL, and relational algebra where possible):
  • Find the names and dates of earthquakes whose magnitude was greater than 7.0.
  • Find the average population of cities whose names start with "San".
  • List the lives lost, quake names and city names for all quakes that occurred before 1960.
  • Find the names of earthquakes that have occurred in cities with a bigger population than that of Vancouver, Canada. (Query should be written so can "swap in" name of a different city easily.)
  • List the city names and total cost, per city, of all quakes with magnitude greater than 7.0.
  • List the average magnitude of quakes for each fault (grouped by fault).
  • List all earthquakes and, where applicable, also list city names and lives lost in that city for quakes that affected cities.
  • List the names of cities whose populations are greater than the average city population.
9/26/2017 For the in-class SQL "live" demos, I've been using the command line 'sqlite3' tool, available to download here, from sqlite.org. (Basic instructions for the command line SQLite are here.)
Feel free to try. I just tried the latest version for Mac, and it worked. 'cd' (Unix/Mac) or 'chdir' (Windows/ Command Prompt) your command line window into whatever folder you put the files you downloaded and unzipped, and type ./sqlite3 (Unix/Mac) or .\sqlite3 (Windows) and the SQLite should start up.
I've put the start-up file of SQL commands here. I usually copy-and-paste the ch5-demo.sql file's contents into the sqlite3 command prompt. (There is an import command, but it has occasionally behaved oddly for me.)
8/23/2017 Welcome to CS 4250!

Homeworks

Project Overview

Points
Project Part 1 20
Project Part 2 25
Homework 1 20
Project Part 3 20
Homework 2 40
Mini-Homework 1 7
Project Part 4 10
Project Part 5 25
Homework 3 30
Project Part 6 12
Project Part 7 70
Homework 4 35

Resources

At the CSU Stanislaus library:

The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both available at the university library.

On-line Resources

CSU Stanislaus Dreamers: Resources for AB540 and undocumented students


Fun News Items