pretty cs4250 logo
Logo courtesy Wordle.net

California State University Stanislaus

CS 4250: Database Management Systems

Fall 2016

3:00 - 3:50 pm, M W F, 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

12/14/2016 Here is a small chunk of the final exam you will take on Friday.
12/6/2016 "These Tech Jobs Are Set To Get a Major Pay Bump" (Fortune, Dec 2, 2016)
12/6/2016 CSU Stanislaus Dreamers: Resources for AB540 and undocumented students
10/19/2016 Here is a partial solution to Homework 2.
10/17/2016 Here is a small chunk of the midterm you will take on Friday.
10/7/2016 "Want a sure-fire well-paid job? Train to fight computer hackers" (Sacramento Bee, 7 Oct 2016)
10/3/2016 Schema:
Earthquake (qname, date, latitude, longitude, magnitude, fault)
Damage(city, qname, cost, liveslost)
Cities(cname, latitude, longitude, population) [Assume cities have unique names.]
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 total cost, per city, of all quakes with magnitude greater than 7.0.
  • Find the name of the quake that did the most damage ($$) in a city with a population less than 2 million (i.e., of all quakes that have damaged cities with populations less than 2 mill, find the one (or more) that did the most damage)
  • 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.
9/23/2016 "Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment about jobs related to big data...
9/21/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.
9/20/2016 For student who are interested:
Psychological Counseling Services Workshops - workshops on coping with stress, and other issues that come up in college years.
Also, Fall 2016 Counseling Groups offered by our Psychological Counseling Services.
9/13/2016 For the sports fans in CS 4250: "Tackle This: Football's Newest Most Valuable Player Is a Robot" (IEEE Spectrum, September 2016)
9/13/2016 "How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)
9/8/2016 Fall 2016 Tutoring Schedule for the Commons (1st floor, Naraghi Hall)
8/25/2016 The Louis Stokes Alliance for Minority Participation (LSAMP) program is looking to recruit students and Research Interns this Fall! (https://www.csustan.edu/AMP) Here are a couple of videos explaining more about LSAMP:
8/25/2016 The Commons is hiring Peer Mentors/Tutors for the 2016-2017 academic year. Applications are due by August 31. Upper division students majoring in Biology, Chemistry, Physics, Geology, Math, or Computer Science are needed. Interested students must have a minimum 3.0 GPA.

A copy of the complete job announcement with all requirements is available on the HR website at https://www.csustan.edu/hr/employment-opportunities/student-assistants

8/25/2016 As I mentioned in class today, the Girls Who Code organization contacted our department recently, looking for volunteers, particularly those who might be interested in starting and facilitating a local club for middle / high school students.
8/24/2016 Welcome to CS 4250!

Homeworks

Project Overview

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

Resources

At the CSU Stanislaus library:

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

On-line Resources


Fun News Items

Topic Ideas for End of Semester