| CPSC 343 | Database Theory and Practice | Fall 2026 |
Dates for things in light gray are for planning purposes and are subject to change.
| Assignments | ||||
|---|---|---|---|---|
Week 1: 8/31-9/4Topics: course introduction; DB foundations; SQL — basic queries |
||||
| Mon |
Materials from class:
|
|||
| Wed | Materials from class: | |||
| Fri |
Materials from class:
|
homework 1 SQL basic queries comments |
||
Week 2: 9/7-9/11Topics: SQL — joins, grouping and aggregation |
||||
| Mon |
Materials from class:
|
homework 2 SQL — joins comments |
||
| Wed |
Materials from class:
|
milestone 1 topic and requirements |
||
| Fri |
Materials from class:
|
homework 3 SQL — aggregation and grouping comments |
||
Week 3: 9/14-9/18Topics: SQL — subqueries, set operations, views; data modeling and design introduction, data models |
||||
| Mon |
Materials from class:
|
homework 4 SQL — subqueries comments |
homework collected (weeks 1-2) (hw 1-3) |
|
| Wed |
Materials from class:
|
homework 5 SQL — set operations comments |
||
| Fri | Materials from class: | |||
Week 4: 9/21-9/25Topics: ER modeling, ER design principles, EER extensions |
||||
| Mon | Materials from class: | homework 6 ER modeling |
homework collected (weeks 2-3) (hw 2-5) |
|
| Wed |
Materials from class:
|
|||
| Fri |
Materials from class:
|
homework 7 EER modeling |
milestone 2 modeling and design |
|
Week 5: 9/28-10/2Topics: the relational model, ER/EER→relational mapping, normalization |
||||
| Mon |
Materials from class:
|
homework collected (weeks 3-4) (hw 4-7) |
||
| Wed |
Materials from class:
|
homework 8 ER/EER→relational mapping |
||
| Fri |
Materials from class:
|
|||
Week 6: 10/5-10/9Topics: normalization; physical DB design and SQL data definition; SQL data modification; DB applications |
||||
| Mon |
Materials from class:
|
homework 9 normalization |
homework collected (weeks 4-5) (hw 6-8) |
|
| Wed |
Materials from class:
|
homework 10 SQL data definition |
||
| Fri |
Materials from class:
|
homework 11 SQL data modification |
||
Week 7: 10/12-10/16Topics: JDBC fundamentals, DAO layer; business logic, routing |
||||
| Mon |
Materials from class:
|
homework collected (weeks 4-6) (hw 6-11) |
||
| milestone 2 handin meetings (Mon/Tue) | ||||
| Wed |
exam 1
|
|||
| Fri |
Materials from class:
|
|||
Week 8: 10/19-10/23Topics: routing; error handling |
||||
| Mon | fall break | |||
| Wed | *** bring laptop to class if you can | homework 12 photo album |
milestone 3 implementation |
|
| Fri | *** bring laptop to class if you can | |||
Week 9: 10/26-10/30Topics: |
||||
| Mon | homework collected (weeks 5-8) (hw 8-12) |
|||
| Wed |
exam 2
|
|||
| Fri | ||||
Week 10: 11/2-11/6Topics: |
||||
| Mon | homework collected (weeks 8-9) |
|||
| Wed | ||||
| milestone 3 handin meetings (Thu/Fri) | ||||
| Fri | ||||
Week 11: 11/9-11/13Topics: |
||||
| Mon | homework collected (weeks 9-10) |
|||
| Wed |
exam 3
|
|||
| Fri | ||||
Week 12: 11/16-11/20Topics: |
||||
| Mon | homework collected (weeks 10-11) |
|||
| Wed | milestone 4 due data integrity and security hardening |
|||
| Fri | ||||
Week 13: 11/23-11/27Topics: |
||||
| Mon | homework collected (weeks 11-12) |
|||
| Wed | Thanksgiving break | |||
| Fri | ||||
Week 14: 11/30-12/4Topics: |
||||
| Mon | ||||
| Wed |
exam 4
|
|||
| Fri | ||||
Week 15: 12/7-12/11Topics: |
||||
| Mon | homework collected (weeks 12-14) |
|||
| Wed | milestone 5 due performance audit and final handin |
|||
| Fri | homework collected (weeks 13-14) |
|||
Reading Period: 12/12-12/14 |
||||
| Sat | ||||
| Sun | ||||
| Mon | ||||
Final Exams: 12/15-12/18 |
||||
| Tue | ||||
| Wed | ||||
| Thu | ||||
| Fri |
exam 5
final exam 12/18 7-10pm |
end-of-semester deadline no work accepted after 12/18 10pm |
||