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. (Academic Catalog description.)
Prerequisite: CS 3100.
Announcements and Upcoming Events
23 March 2025 |
Here is one small chunk of the midterm
you will take on Wednesday during class time. More information on Candian provinces and territories here, if you are curious. (The link is to provide context for the midterm hint relations. All the information needed for the exam questions is in the hint.) |
7 March 2025 |
For 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):
|
21 Feb 2025 |
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) |
18 Feb 2025 | "Ten Year IT Job Outlook: Positive News for Cybersecurity, Software Development, and Management Roles", Peter Tsai, spiceworks.com, 13 Jan 2025 |
28 January 2025 | Welcome to CS 4250! |
Points | |
Project Part 1 | 20 |
Project Part 2 | 25 + 6 |
Homework 1 | 30 |
Project Part 3 | 20 |
Homework 2 | 15 |
SQL Mini-Quizzes | 5 pts each |
Project Part 4 | 10 |
Homework 3 | 30 |
Project Part 5 | 25 |
Project Part 6 | 12 |
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