pretty cs4250 logo
Logo courtesy Wordclouds.com

California State University Stanislaus

CS 4250: Database Management Systems

Spring 2018

12:30 - 1:45 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

5/18/2018 Before the final exam, you may wish to review the same, small chunk of the midterm you have seen before. The final exam will also have questions related to that chunk.
5/8/2018 "Latest Internet Crime Report Released: IC3 Says Victim Losses Exceeded $1.4 Billion in 2017" (FBI's IC3, 7 May 2018)
4/24/2018 "If You Don't Have Sufficient Soft Skills, Google Might Not Hire You" (IEEE's the institute, 13 April 2018)
4/17/2018 Extra credit opportunity: Create a CAHSI MentorNet Profile. Be sure to check the CAHSI box when creating the profile. Here is a page with more information. Save a confirmation (screen shot, print out of confirmation screen) and show it to me by April 30th.
4/11/2018 OIT has reported problems with GMail, so I created alternative ways (besides email) to submit future project parts. You can use the CS Homework web site to submit Project Parts 4, 5, 6 and 7, if you wish. I'll check there when I check email for project parts.
3/18/2018 Here is a small chunk of the midterm you will take on Thursday.
3/8/2018 To help students practice SQL syntax, you may log in (using SSH or a similar tool) to hopper.csustan.edu and use your local MySQL account to try SQL queries at the MySQL command line.
After you log in to hopper, then
  • start the MySQL command line (#2 on the account paper you are given)
  • copy and paste the text from createHW2tables.txt into the MySQL prompt
  • then download and edit loadHW2data.txt so that it refers to whatever location you plan to put the files of sample data (you may need to edit on your local machine, then copy the file onto hopper.csustan.edu
  • put doctor.txt, patient.txt, department.txt at the location you specified in loadHW2data.txt
  • then copy and paste the text from loadHW2data.txt into the MySQL prompt
That will set up sample Doctor, Patient and Department tables, with schemas like in Hwk 2.(Note: for simplification, no foreign keys are set up. And real data is likely to have many more duplicates in human name fields, which a good DBA would think about carefully when writing queries.)
2/7/2018 The counseling center is offering some interesting workshops this semester, on topics like succeeding (and stuff) as a first generation college student, wellness, mindfulness, anxiety, etc, etc. Check them out!
2/5/2018 'Is Your Password on This List?' by IEEE JobSite. Hint: please do not let your password be on that list. Ever.
1/25/2018 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
Project Part 4 10
Homework 3 30
Project Part 5 25
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