Logo courtesy Wordle.net
[Syllabus ] [Announcements] [Calendar/Lecture Notes] [Homeworks] [Resources] [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
19 March 2024 | The final exam will re-use the sample schema from the midterm. Here is the small hint of the exam. |
17 April 2024 |
The sample ARIES log we created in class today, for practice: 0 begin checkpoint 10 end checkpoint 20 T2 update P4 30 T3 update P3 40 T1 update P1 50 T3 update P4 60 T3 abort 65 CLR: T3 undo of 50, prevLSN = 30 66 T1 commit 67 T1 End CRASH |
17 March 2024 | Here is one small chunk of the midterm you will take on Friday during class time. |
1 March 2024 |
From our in-class exercise work this week: Schema: Earthquake (qname, qdate, 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):
|
16 Feb 2024 |
Sample tables for classroom exercises: CREATE TABLE Books(title char(40), lastname CHAR(40), firstname CHAR(40), pubyear INTEGER, bookID INTEGER PRIMARY KEY) CREATE TABLE AwardWinners (bookID INTEGER, year INTEGER, award CHAR(60), authorage INTEGER, PRIMARY KEY (bookID, award, year)) CREATE TABLE Awards (awardname char(60), primary key (awardname)) (Note that, to fit on a PPT slide, foreign key key declarations were left out) |
26 Jan 2024 | Welcome to CS 4250! |
Points | |
Project Part 1 | 20 |
Project Part 2 | 25 + 6 |
Homework 1 | 30 |
Project Part 3 | 20 |
Homework 2 | 30 |
Project Part 4 | 10 |
Homework 3 | 30 |
Project Part 5 | 25 |
Project Part 6 | 12 |
Homework 4 | 35 |
Project Part 7 | 70 |
Books at the CSU Stanislaus Library
The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both available at the university library.
Campus Resources
DBMS Resources
Fun News Articles and Podcasts