Important Information
- Meeting times: Tuesdays (virtual, asynchronous) and Thursdays, 18:30-19:45
- Room: Engineering Technology Center Room 310
Required Materials
- FoDS: Fundamentals of Database Systems by Elmasri and Navathe, 7th Ed, https://www.pearson.com/en-us/subject-catalog/p/fundamentals-of-database-systems/P200000003546/9780137502523
Recommended Materials
Schedule
Date | Topics | Reading/Resources | Exercises | Assignments | Reminders |
---|---|---|---|---|---|
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 |