Database Systems
Fall 2025
Lecture Notes and Syllabus
by K. Yue
The syllabus is tentative. Actual contents and order of coverage may change. There will be eight homework assignments. Additional materials are topics that may be covered if time allows. Please read the notes before coming to the class.
Date |
Topic |
Lecture Notes and Comments |
| Week #1 (8/18, 20): MW |
An Introduction and overview of database systems Database basics An introduction to the relational database model The Toy University Database (toyu) The Swim Database (Swim) An introduction to simple SQL and MySQ |
Read Ricardo Chapter 1 Introduction to the course DB Basics Read Ricardo Chapter 2, 4.2, 4.3, 4.4 The Relational Model Read Ricardo Chapter 3 Toyu DB: toyu Swim DB: swim A First Look at SQL |
| Week #2 (8/25,27) |
An introduction to simple SQL and MySQL Null Values |
Read Ricardo 4.1, 4.2, 5.1, 5.2, 5.4.1 and 5.4.2 Null Values |
| Week #3 (9/3) |
9/1 Labor Day An introduction to simple SQL and MySQL Null Values in Relational Database An introduction to conceptual data modeling |
Introduction to DB Modeling. Read Chapters 3 and 10. |
| Week #4 (9/8,10) |
Data modeling using UML |
Introduction to UML/DB Modeling Read Chapter 10. |
| Week #5 (9/15,17) |
Data modeling using UML Mapping UML data models to relational schema |
Mapping UML Class Diagrams to the relational model Read Ricardo 4.5 |
| Week #6 (9/22,24) |
SQL |
Read Ricardo 5.3 to 5.4 An introduction to SQL and MySQL Read Ricardo 5.5-5/8, 9.1, 9.2 toyu Query Exercise (in PDF) Suggested MySQL solution to even numbered questions of toyu exercises |
| Week #7 (9/29,10/1) |
More SQL: prepared statements, views, stored subrountines, triggers, systems catalog.
|
More SQL |
| Week #8 (10/6,8) |
More SQL 10/8 Wednesday: Mid-term Exam, in person, class time (one hour 20 minutes) |
Mid-term examination will be conducted face to face. Closed book. However, you can bring an 'information' sheet: letter size, can be printed or written on both sides, which must be prepared by yourself. |
| Week #9 (10/13,15) |
Introduction to Python Embedded SQL Programming |
Introduction to Python Read Ricardo Chapter 6 MySQL programming in Python |
| Week #10 (10/20,22) |
Embedded SQL Programming Web DB development with Python |
MySQL Python Web Development |
| Week #11 (10/27,29) |
Introduction to Database Design Normalization theory and normal forms |
Introduction to Database Design Introduction to Functional Dependency and Normal Forms Read Ricardo Chapter 14 |
| Week #12 (11/3,5) |
Normalization theory and normal forms Last day to withdraw: November 3 (Monday) |
Theory of Functional Dependency Normal Forms and Normalization Theory |
| Week #13 (11/10,12) |
Transaction Management Introduction to NoSQL database NoSQL DB: MongoDB |
Transaction management Introduction to NoSQL database Introduction to Mongo DB |
| Week #14 (11/17,19) |
NoSQL DB: MongoDB DB Security |
DB Security and SQL Injection |
| Week #15 (11/24) |
Physical database 11/26 Thanksgiving |
Physical database |
| Week #16 (12/3) |
12/3 Wednesday Final Examination:
|
Final examination will be conducted face to face. Closed book. However, you can bring two 'information' sheets: letter size, can be printed or written on both sides, which must be prepared by yourself. |
(*) Covered only if time permits. Not in the examinations.