Logo courtesy Wordclouds.com
[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/12/2017||Here is one small chunk of the final exam and this is a second chunk of the final exam.|
|11/11/2017||All students are being given one extra Late Day. (See syllabus for descriptions of Late Days.) I strongly encourage students to turn Part 4 in on the Tuesday deadline, and conserve your new Late Day to use on Part 5 or 7. But it is your group's choice; you may use the new Late Day on Part 4 if you wish.|
|11/10/2017||For those students who consider 20 (or 10, or 30) characters enough to store a human name, please take a look at the full name of Pablo Picasso, the famous painter.|
|10/9/2017||Here is a small chunk of the midterm you will take on Thursday.|
|10/3/2017||Deadline for Project Part 3 moved, to give students more time to revise Part 2 ER diagrams.|
Earthquake (qname, date, 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):
For the in-class SQL "live" demos, I've been using the command line 'sqlite3'
tool, available to download here, from sqlite.org. (Basic instructions for the command line SQLite are here.)
Feel free to try. I just tried the latest version for Mac, and it worked. 'cd' (Unix/Mac) or 'chdir' (Windows/ Command Prompt) your command line window into whatever folder you put the files you downloaded and unzipped, and type ./sqlite3 (Unix/Mac) or .\sqlite3 (Windows) and the SQLite should start up.
I've put the start-up file of SQL commands here. I usually copy-and-paste the ch5-demo.sql file's contents into the sqlite3 command prompt. (There is an import command, but it has occasionally behaved oddly for me.)
|8/23/2017||Welcome to CS 4250!|
|Project Part 1||20|
|Project Part 2||25|
|Project Part 3||20|
|Project Part 4||10|
|Project Part 5||25|
|Project Part 6||12|
|Project Part 7||70|
At the CSU Stanislaus library:
The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both available at the university library.
On-line ResourcesCSU Stanislaus Dreamers: Resources for AB540 and undocumented students
Fun News Items