pretty cs4250 logo
Logo courtesy Wordclouds.com

California State University Stanislaus

CS 4250: Database Management Systems

Spring 2017

11:00 - 12:15 pm, Tu Th, CX 102, 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

3/30/2017 "Software Engineering Jobs Dominate List of Best Careers for 2017", IEEE Spectrum, 22 March 2017.
3/27/2017 Here is a small chunk of the midterm you will take on Thursday.
2/21/2017 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/7/2017 "Data Scientist, DevOps Engineer and DBA Among Top IT Jobs for 2017" (Datamation.com, Jan 2017)
2/2/2017 Wellness Workshops for students at CSU Stanislaus -- stress management, managing time and other tricky issues, etc. Offered by CSU Stanislaus Counseling Services
1/26/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