Title: Database System and Concepts Code: CSCI 3030U
Instructor: Jarek Szlichta, jarek [at] uoit [dot] ca
Office hours: Tuesdays 4pm-5pm.
TAs: Spencer Bryson (spencer.bryson [at] uoit [dot] net) and Bahare Askari (Bahare.AskariFiroozjayi [at] uoit [dot] ca)
TA Office hours: UA 4029, available upon request.
Description: This course studies Database Systems and the related theories and concepts. Students will be introduced to the classical relational data model and the theory of relational data normalization. We will also cover modern data models such as the semi-structured, and unstructured data models.
We cover a range of data query languages including SQL, XQuery and text search based query methods. Practical issues such as performance, security and application programming interfaces to host languages are discussed. We also discuss the intimate connection between database engines and modern computer systems such as the WWW, mobile devices and computer networks.
Policies: Refer to following link. Refer to the Ontario Tech University Faculty of Science academic policies
Required reading: Database Systems, The Complete Book, Hector Garcia-Molina, Jeffrey Ullman and Jennifer Widom
Lecture Notes (always check newest version of the slides):
I. Introduction PDF
II. Data Modelling PDF
III. E/R PDF
IV. Relational Algebra PDF
V. SQL PDF
VI. More SQL PDF
VII. Constraints PDF
VIII. Transactions, Views and Indexes PDF
IX. Modelling Workshop PDF
X. SQL Libraries PDF
XI. Data Integration and OLAP PDF
XII. Authorization PDF
XIII. Functional Dependencies PDF
XIV. XML PDF
XV. Workshop PDF
XVI. IBM Project: Query Optimization, RDF, SPARQL (slides posted on Blackboard)
Labs will start in the week of 16th of Sept.
Any student who misses an examination (or lab) without a valid medical reason and documentation will receive zero for that examination/lab. Those with medical documentation will either be given a makeup exam/tutorial or will have the weight of the examination added to the final exam.
Midterm: 22nd of Oct, Tue (Database Design Modelling) and 24th of Oct, Thu (Applications: rest of the material including SQL and all others) BRING YOUR LAPTOP TO BOTH
Student presentations: last week of classes (Nov 28th, Thursday and Dec 3rd, Tuesday).
Final Midterm: Nov 26 (Tuesday) BRING YOUR LAPTOP