CSC343H1: Introduction to Databases

Hours: 
36L

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/​ ESC190H1/​ CSC190H1/​ CSC192H1

Exclusion: 

CSC443H1. NOTE: Students not enrolled in the Computer Science Major or Specialist program at the UTSG, UTM, or UTSC are limited to a maximum of three 300-/400-level CSC/ECE half-courses.

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