CSCC43: Introduction to Databases - Winter 2025

This course is about designing relational databases, building applications with database management systems (DBMSs), and understanding DBMS internals. Topics covered include entity relationship models, relational algebra, normalization theory, SQL, and implementation of relational databases. The course also includes a project where students design a realistic database following a design process, implement the design using SQL and an open-source DBMS, and evaluate the implementation with extensive testing.
Prerequisites: CSCB09 (or equivalent courses on computer science and systems foundations)
Textbook: Database Systems: The Complete Book (Second Edition)

Instructor
Qizhen Zhang
TA
David Lin
TA
Jianning Qu
TA
Haoqian Zhang

Lectures: Thursday 1:00 PM - 3:00 PM, SW 319
Discussions: Piazza

Tutorials: Office hours:

Tentative Schedule

     
Date Lecture Note
     
Jan. 9 Overview, ER Diagrams First day of class
     
Jan. 16 ER Diagrams, Relational Model, Functional Dependencies
     
Jan. 23 No class (conference travels)
     
Jan. 30 Functional Dependencies, Normalization Homework release
     
Feb. 6 Relational Algebra
     
Feb. 13 SQL
     
Feb. 20 No class (Reading Week)
     
Feb. 27 SQL Homework due (Quercus)
     
TBD Midterm exam
     
Mar. 6 Constraints, Triggers, Views, Indices Project release
     
Mar. 13 Introduction to Transactions
     
Mar. 20 Advanced SQL Topics Last day to drop the course on Mar. 24
     
Mar. 27 Query Execution and Optimization
     
Apr. 3 NoSQL Databases
     
Apr. 5 Project demonstration on Zoom, 9:00 AM - 12:00 PM Project code/report due (Quercus)
     
TBD Final exam
     

Grading

Attendance

Students are expected to attend all the lectures and tutorials, which are supposed to be in-person only. Some materials covered in tutorials might not be taught in lectures but might be tested in the homework and/or the exams.

Late Policy

No late homework/project submissions are allowed. If you miss a submission deadline or an exam because of an emergency, fill out this form to request special consideration, and in case of a medical emergency, also email the instructor the UofT Student Medical Certificate, completed and signed by the doctor.
If the request is approved, the late homework or project can be submitted. The midterm exam, however, has no make-up test. If a missed midterm is approved, its mark is considered the same as the final exam mark.

Remarking Policy

If you believe there are mistakes in your homework/project/exam mark, fill out this form and email the submission or exam to the instructor to request remarking. The request should be made no later than one week from the date the mark is released.

Collaboration Policy

No collaboration of any form is allowed on the homework and exams, e.g., you may not copy a solution written by anyone else, or develop a solution together with another student/person. The project will be the group work of two students.
Any violation of these policies is considered cheating and will result in a zero grade for the homework/project/exam and will be referred to the Academic Integrity Office. More information about academic integrity can be found at Academic Integrity Matters.

Accessability Volunteering

AccessAbility Services requires Volunteer Note Takers
Register to become a note taker today --- Co-Curricular Record (CCR) approved position
1. Go to myAIMS for Note Takers
2. Follow the simple step-by-step process to register
3. Upload notes files into the AccessAbility Services myAIMS note taking portal
If you have questions please contact AccessAbility Services:
(416) 208-2662 or notetaking.utsc@utoronto.ca