CSC343H1: Introduction to Databases

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.

CSC111H1/ CSC165H1/ MAT102H5/ CSCA67H3/ MATA67H3/ CSC240H1/ ( MAT135H1, MAT136H1)/ MAT135Y1/ MAT137Y1/ MAT157Y1; CSC207H1/ CSC207H5/ CSCB07H3 Prerequisite for Faculty of Applied Science and Engineering students: ( ESC194H1, ESC195H1)/ ( MAT186H1, MAT187H1)/ ( MAT194H1, MAT195H1); ECE345H1/ ESC190H1
CSC343H5, CSCC43H3, MIE253H1, MIE353H1. NOTE: Students not enrolled in the Computer Science Major or Specialist program at A&S, UTM, or UTSC, or the Data Science Specialist at A&S, are limited to a maximum of 1.5 credits in 300-/400-level CSC/ECE courses.
The Physical and Mathematical Universes (5)