pretty cs4250 logo
Logo courtesy

California State University Stanislaus

CS 4250: Database Management Systems

Spring 2016

12:30 - 1:45 pm, Tu-Thu 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

5/27/2016 Average score earned on the final exam was 47.
5/5/2016 The Engineer Guy opens up a hard drive.
4/26/2016 Execute PHP MySQL On-line, a PHP testing facility provided by (pointed out by C Busby)
3/24/2016 appears to be a web site that allows uers to "fiddle around" with SQL. A student pointed it out to me.
3/21/2016 Very minor clarification of question 10 on Hwk 2 posted today.
3/1/2016 Schema from class exercise: CREATE TABLE BookAwardWinners (lastname CHAR(20), firstname CHAR(20), title CHAR(30), year INTEGER, award CHAR(10), age INTEGER, PRIMARY KEY (lastname, title, award))
Goofy schema, and not normalized.
1/1/2016 "Data Center Love: Tech Chiefs Show Off the Gear That Keeps Everything Humming" by CIO Journal Staff, of the Wall Street Journal, on Dec. 31, 2015.
1/28/2016 Welcome to CS 4250! Please sign up for the class mailing list.


Project Overview

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

Student Projects


At the CSU Stanislaus library:

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

On-line Resources

Fun News Items

Topic Ideas for End of Semester