Introduction to Databases
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.
Prerequisites & course information
Prerequisite: CSC111H1 / CSC165H1 / MAT102H5 / CSCA67H3 / MATA67H3 / CSC240H1 / ( MAT130H1 / MAT135H1 , MAT136H1 )/ ( MAT148H1 / MAT158H1 , MAT149H1 / MAT159H1 )/ MAT137Y1 / MAT157Y1 ; CSC207H1 / CSC207H5 / CSCB07H3 Prerequisite for Faculty of Applied Science and Engineering students: ( ESC194H1 , ESC195H1 )/ ( MAT186H1 , MAT187H1 )/ ( MAT194H1 , MAT195H1 ); ECE345H1 / ESC190H1; Prerequisite:; Exclusion: 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.; Exclusion:
Sources
- Course catalogue ↗2026-2027