pretty cs4250 logo
Logo courtesy Wordle.net

California State University Stanislaus

CS 4250: Database Management Systems

Spring 2024

3:00 - 3:50 pm, Mo We Fr, DBH 165. Dr. Megan Thomas


[Syllabus ]        [Announcements]        [Calendar/Lecture Notes]        [Homeworks]        [Resources]        [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

17 March 2024 Here is one small chunk of the midterm you will take on Friday during class time.

1 March 2024 From our in-class exercise work this week:

Schema:
Earthquake (qname, qdate, 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):
  1. Find the names and dates of earthquakes whose magnitude was greater than 7.0.
  2. Find the average population of all the cities whose names start with "San".
  3. List the lives lost, quake names and city names for all quakes that occurred before 1960.
  4. List the city identifiers and total cost, per city, of all quakes with magnitude greater than 7.0.
  5. List the average magnitude of quakes for each fault (grouped by fault).
  6. List all earthquakes and, where applicable, also list city IDs and lives lost in that city for quakes that affected cities.
  7. List the names of cities whose populations are greater than the average city population.
16 Feb 2024 Sample tables for classroom exercises:
CREATE TABLE Books(title char(40), lastname CHAR(40), firstname CHAR(40), pubyear INTEGER, bookID INTEGER PRIMARY KEY)
CREATE TABLE AwardWinners (bookID INTEGER, year INTEGER, award CHAR(60), authorage INTEGER, PRIMARY KEY (bookID, award, year))
CREATE TABLE Awards (awardname char(60), primary key (awardname))
(Note that, to fit on a PPT slide, foreign key key declarations were left out)
26 Jan 2024 Welcome to CS 4250!

Homeworks

Project Overview

Points
Project Part 1 20
Project Part 2 25 + 6
Homework 1 30
Project Part 3 20
Homework 2 30
Project Part 4 10

Books at the CSU Stanislaus Library

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

Campus Resources

DBMS Resources


Fun News Articles and Podcasts