Marking Scheme:	Text:
Assignments     10 %        Quiz 1 10 % Mar. 8 (Feb. 5)                   Quiz 2 10 % Mar. 22 (Feb. 22) Quiz 3 10 % Apr. 5 (Mar. 22) Project 20 % Final Exam 40 % Apr. 16 2:00 AX 23A	Database Systems     T. Connolly and C. Begg Addison-Wesley     Fifth Edition - 2010.

Overview

This course covers the essential concepts, principals, techniques, and mechanisms for the design, use and implementation of computerized database systems. Concentration will be on the Relational model, with an overview of the other significant models, Hierarchical and Network. The query language SQL will be studied in some detail. Planning and design of databases through the ER model and normalization are also covered. Most assignments will be done using ORACLE Database software. Thus the student will be introduced to the ORACLE system and gain familiarity with its components.

By providing a balanced view of theory and practice, the material covered should give the student an understanding and use of practical database systems. CS 275 provides practical examples of concepts taught in other Computer Science courses, including locking and buffer management (Operating Systems), data structuring (Data Structures), indexing and query processing algorithms (Algorithms), and their use in solving database problems.

Topics:

Introduction to Databases	1.1 - 1.6	SQL: Data Definition	6.1 - 6.6
Database Environment	2.1 - 2.6	Entity-Relationship Modeling	11.1 - 11.6
The Relational Model	3.1 - 3.4	Enhanced E-R Modeling	12.1
The Relataional Algebra	4.1	Normalization	13.1 - 13.9
SQL: Data Manipulation	5.1 - 5.3	Transaction Management	20.1 - 20.3

Term Project:

A term project involving the implementation of a database is associated with the course. This is a group project, with group sizes of 2 to 3 persons. The project plan and its design are due on Tuesday, February 19th (January 29th).

Printable version here.