Worksheets

Worksheets and solutions can be found on courseworks. The worksheet will be published on the date indicated in the table below.

No. Topics Out Due
1 Entity-Relationship Modeling, relational algebra 1/29 2/12
2 SQL, security 2/17 3/3
3 Object-relational DBs, Storage and Indexing, Query processing and optimization, materialized views 3/31 4/16
4 Transactions, Normalization 4/16 4/30

Part of the reason for shifting to non-graded worksheets is the advent of tools like ChatGPT. Try to answer the worksheets without ChatGPT (or just use ChatGPT for small hints) so that you can gain experience and understanding. Remember that the exams will be pen-and-paper in-class exams without access to such tools.



Ken Ross 2025-01-23