CSC343H1: Introduction to Databases

Hours: 
24L/12T

Introduction to database management systems. The relational data model. Relational algebra. Querying and updating databases: the query language SQL. Application programming with SQL. Integrity constraints, normal forms, and database design. Elements of database system technology: query processing, transaction management.

Prerequisite: 

CSC165H1/​ CSC240H1/​( MAT135H1, MAT136H1)/ MAT135Y1/​ MAT137Y1/​ MAT157Y1; CSC207H1. Prerequisite for Engineering students only: ECE345H1/​ CSC190H1/​ CSC192H1

Exclusion: 
Distribution Requirements: 
Science
Breadth Requirements: 
The Physical and Mathematical Universes (5)