Course content
CS 354 – Database Management Systems – is organized by week, with each week structured as follows:
- Classroom sessions are Monday-Wednesday-Friday 2.45PM - 3.50PM at SB 382.
- Homeworks are due Friday 23:59. They will be released every Monday.
- Project submission is due Wednesday at 23:59. They will be released every Wednesday.
- Tutoring Assistants are available in SB337 on Mondays and Thursdays, from 7 - 9 pm.
The SLOs (Student Learning Objectives), labs, and projects for each week are given in the links below. The readings are from Ramez Elmasri, S. B. N. (2016). Fundamentals of Database Systems 7th ed.
| Week | Topics | Laboratories | Projects | Tests, Video Links, etc. |
|---|---|---|---|---|
| 1 — 3/17 |
Introduction to Databases & SQL Basics Week’s page |
Homework 1 | Proj 1 | |
| 2 — 3/24 |
SQL – Intermediate Concepts Advising days – no class 26-27 Week’s page |
Homework 2 | Proj 2 | |
| 3 — 3/31 |
SQL – Data Modification & Advanced Queries Week’s page |
Homework 3 | Proj 3 | |
| 4 — 4/7 |
Database Design – ER Modeling & Schema Refinement Week’s page |
Homework 4 | Proj 4 | Test 1: Weeks 1 - 3, Friday |
| 5 — 4/14 |
Advanced SQL & Integrity Constraints Good Friday & Easter Monday – no class 18-21 Week’s page |
No lab | No project | |
| 6 — 4/22 |
Database Management & Optimization Week’s page |
Homework 6 | No project | |
| 7 — 4/28 |
Final Project and Course Wrap-Up Week’s page |
Homework 7 | Final Project | |
| Final — May 3-8 |
Search calvin.edu for “Exam Schedule” to find the time of the exam (and all exams you have, this semester, and all future semesters). | Final Test Cumulative, during exam time (You may take it in either class’s exam time. Classes met at 2.45pm MWF.) |