Important Information

Required Materials

Recommended Materials

Schedule

DateTopicsReading/ResourcesExercisesAssignmentsReminders
Databases Concepts and Conceptual Models
Week 1
2025-01-07 Introduction to Databases FoDS 1
2025-01-09 Database Concepts FoDS 2 Registration Ends (2025-01-10)
Payment Deadline (2025-01-10)
Week 2
2025-01-14 ER Models FoDS 3.1-3.7.3
2025-01-16 ER Models FoDS 3.1-3.7.3 Movie Rental ER Exercise Financial Aid Disbursement (2025-01-17)
Graduation Petition Deadline (2025-01-17)
Week 3
2025-01-21 EER Models FoDS 4.1-4.3 Unpaid Course Deletion (2025-01-21)
2025-01-23 EER Models FoDS 4.1-4.3 Humane Society EER Exercise Assigned: Project
Week 4
2025-01-28 Conceptual Design Process
2025-01-30 Conceptual Design Process
Relational Model
Week 5
2025-02-04 Relational Model FoDS 5
2025-02-06 Relational Model FoDS 5
Week 6
2025-02-11 Relational Algebra FoDS 8.1 - 8.3.4, 8.4.4
2025-02-13 Relational Algebra FoDS 8.1 - 8.3.4, 8.4.4 Relational Algebra Exercises - Answers
Relational Algebra Masterclass
Due: Project Phase 1
Week 7
2025-02-18 Midterm Review Midterm Practice
Midterm Practice Answers
2025-02-20 Midterm Exam
Relational Databases and SQL
Week 8
2025-02-25 ER - Relational Mapping FoDS 9
2025-02-27 ER - Relational Mapping FoDS 9
Week 9
2025-03-04 Basic Relational Design FoDS 14.1-14.3
2025-03-06 DB Workshop MySQL
Week 10
2025-03-11 Spring Break - No Class
2025-03-13 Spring Break - No Class
Week 11
2025-03-18 SQL DDL FoDS 6
2025-03-20 SQL CRUD FoDS 6 Exercise: Registration Database Midterm Grades Due (2025-03-21)
Week 12
2025-03-25 SQL Queries FoDS 6
2025-03-27 SQL Queries FoDS 6 Exercise: Dorms Queries Due: Project Phase 2 Withdrawal Deadline (2025-03-28)
Week 13
2025-04-01 Advanced SQL FoDS 6,7
2025-04-03 Advanced SQL FoDS 6,7 Exercise: Sakila Queries
Relational Database Design
Week 14
2025-04-08 Relational Design FoDS 14.1-14.5
2025-04-10 Relational Design FoDS 14.1-14.5
Week 15
2025-04-15 Advanced Relational Design FoDS 15.1-15.3
2025-04-17 Advanced Relational Design FoDS 15.1-15.3 BCNF Decomposition Exercise Due: Project Phase 3
Week 16
2025-04-22 NoSQL Databases FoDS 16.1-16.7
2025-04-24 Storage and Indexing FoDS 16.1-16.7, 17