WClasses

CS 348 - Introduction to Database Management

The main objective of this course is to introduce students to fundamentals of database technology by studying databases from three viewpoints: those of the database user, the database designer, and the database administrator. It teaches the use of a database management system (DBMS) by treating it as a black box, focusing only on its functionality and its interfaces. Topics include introduction to database systems, relational database systems, database design methodology, SQL and interfaces, database application development, concept of transactions, ODBC, JDBC, database tuning, database administration, and current topics (distributed databases, data warehouses, data mining).

Prerequisites

Honours Computer Science, Honours Data Science (BCS, BMath), BCFM, BSE students only.

Corequisites

CS240/CS240E.

Antirequisites

CS338, ECE356, ECE456, MSCI346

Offerings

Spring 2026 [1265]

Section	Class	Enrolled
LEC 001	3618	0 / 90
LEC 002	3819	0 / 90
LEC 003	3922	0 / 90
TST 101	3984	0 / 270

Winter 2026 [1261]

Section	Class	Enrolled	Time	Days
LEC 001	5800	31 / 90	14:30 - 15:50	T,Th
LEC 002	6161	21 / 90	16:00 - 17:20	T,Th
TST 101	6421	52 / 180	16:30 - 18:00	F

Fall 2025 [1259]

Section	Class	Enrolled	Time	Days
LEC 001	6253	90 / 90	14:30 - 15:50	T,Th
LEC 002	6938	81 / 90	16:00 - 17:20	T,Th
TST 101	6939	171 / 180	16:30 - 18:00	F

Spring 2025 [1255]

Section	Class	Enrolled	Time	Days
LEC 001	3696	74 / 81	08:30 - 09:50	T,Th
LEC 002	3911	69 / 81	13:00 - 14:20	T,Th
LEC 003	4023	71 / 81	14:30 - 15:50	T,Th
TST 101	4089	214 / 270	16:30 - 18:00	F

Winter 2025 [1251]

Section	Class	Enrolled	Time	Days
LEC 001	5881	88 / 90	14:30 - 15:50	M,W
LEC 002	6259	87 / 90	13:00 - 14:20	M,W
TST 101	6572	175 / 180	16:30 - 18:00	F

Fall 2024 [1249]

Section	Class	Enrolled	Time	Days
LEC 001	6217	80 / 90	11:30 - 12:50	T,Th
LEC 002	6944	76 / 90	14:30 - 15:50	T,Th
TST 101	6945	156 / 180	16:30 - 18:00	F

Spring 2024 [1245]

Section	Class	Enrolled	Time	Days
LEC 001	3733	26 / 80	11:30 - 12:50	T,Th
LEC 002	3957	79 / 80	13:00 - 14:20	T,Th
LEC 003	4072	81 / 80	14:30 - 15:50	T,Th
LEC 004	5245	35 / 80	14:30 - 15:50	T,Th
TST 101	4149	221 / 320	16:30 - 18:00	F

Winter 2024 [1241]

Section	Class	Enrolled	Time	Days
LEC 001	5904	83 / 90	11:30 - 12:50	M,W
LEC 002	6310	83 / 90	08:30 - 09:50	M,W
TST 101	6694	166 / 180	16:30 - 18:00	F

Fall 2023 [1239]

Section	Class	Enrolled	Time	Days
LEC 001	6101	78 / 85	10:00 - 11:20	T,Th
LEC 002	6895	73 / 85	13:00 - 14:20	T,Th
LEC 003	8733	59 / 85	08:30 - 09:50	T,Th
TST 101	6896	210 / 255	16:30 - 18:00	F

Spring 2023 [1235]

Section	Class	Enrolled	Time	Days
LEC 001	3853	32 / 80	16:00 - 17:20	T,Th
LEC 002	4089	80 / 80	13:00 - 14:20	T,Th
LEC 003	4223	131 / 140	14:30 - 15:50	T,Th
LEC 004	5401	80 / 80	10:00 - 11:20	T,Th
TST 101	4344	323 / 380	19:00 - 20:50	M

Winter 2023 [1231]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	6032	84 / 90	14:30 - 15:50	T,Th	MC 2035	Chao Zhang
LEC 002	6493	76 / 90	16:00 - 17:20	T,Th	MC 2034	Arif Usta
TST 101	8855	160 / 180	16:30 - 18:00	F		Sylvie Lynne Davies

Fall 2022 [1229]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	7205	118 / 120	08:30 - 09:50	T,Th	MC 1085	Xi He
LEC 002	10101	118 / 120	16:00 - 17:20	T,Th	STC 0050	Xi He
LEC 003	11196	2 / 1
TST 101	10102	236 / 240	16:30 - 18:00	F		Sylvie Lynne Davies

Spring 2022 [1225]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3627	62 / 80	10:00 - 11:20	T,Th	MC 2034	David Toman
LEC 002	3893	53 / 80	11:30 - 12:50	T,Th	MC 2034	David Toman
LEC 003	4096	127 / 154	08:30 - 09:50	T,Th	STC 0040	Sylvie Lynne Davies
TST 101	5776	242 / 314	16:30 - 18:20	M

Winter 2022 [1221]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5896	83 / 85	11:30 - 12:50	T,Th	AL 105	Semih Salihoglu
LEC 002	6436	79 / 85	14:30 - 15:50	T,Th	AL 105	Semih Salihoglu

Fall 2021 [1219]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	6157	155 / 160	11:30 - 12:50	T,Th		Ahmed Hajyasien
LEC 002	6324	0 / 50

Spring 2021 [1215]

Section	Class	Enrolled	Instructor
LEC 041	3412	78 / 80	Xi He
LEC 042	3578	79 / 80	Xi He
LEC 043	3710	122 / 135	David Toman
TST 141	3600	279 / 295	Ahmed Hajyasien

Winter 2021 [1211]

Section	Class	Enrolled	Instructor
LEC 041	5947	76 / 80	Grant Weddell
LEC 042	6487	69 / 80	Grant Weddell
TST 141	6410	145 / 160	Ahmed Hajyasien

Fall 2020 [1209]

Section	Class	Enrolled	Instructor
LEC 041	6220	97 / 107	David Toman
LEC 042	6379	100 / 107	David Toman
LEC 043	9570	106 / 110	David Toman
TST 141	6559	303 / 324	Ahmed Hajyasien

Spring 2020 [1205]

Section	Class	Enrolled	Time	Instructor
LEC 001	3657	78 / 80		Grant Weddell
LEC 002	3923	76 / 80		Grant Weddell
LEC 003	5181	120 / 125		Aoqian Zhang
TST 101	3951	274 / 285	18:25 - 18:25	Gustavo Fortes Tondello

Winter 2020 [1201]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5794	68 / 70	10:00 - 11:20	T,Th	RCH 207	Xi He
LEC 002	6354	68 / 70	13:00 - 14:20	T,Th	MC 4040	Xi He
LEC 003	9455	1 / 1
TST 101	6266	136 / 140	19:00 - 20:50	Th		Dalibor Dvorski

Fall 2019 [1199]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5873	98 / 115	10:00 - 11:20	T,Th	MC 4059	David Toman
LEC 002	6041	69 / 80	16:00 - 17:20	T,Th	E2 1732	David Toman
LEC 003	6204	60 / 80	11:30 - 12:50	T,Th	MC 4059	David Toman
LEC 004	9711	14 / 1
TST 101	6395	227 / 275	16:30 - 18:00	F		Dalibor Dvorski

Spring 2019 [1195]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3666	56 / 70	11:30 - 12:50	T,Th	MC 4040	Bojana Bislimovska
LEC 002	3938	61 / 70	10:00 - 11:20	T,Th	MC 4040	Bojana Bislimovska
LEC 003	5612	1 / 1
TST 101	3972	117 / 140	19:00 - 20:50	T		Dalibor Dvorski

Winter 2019 [1191]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5669	67 / 70	10:00 - 11:20	T,Th	MC 4040	Grant Weddell
LEC 002	6286	64 / 70	08:30 - 09:50	T,Th	MC 4040	Grant Weddell
LEC 003	9382	6 / 1
TST 101	6163	131 / 140	19:00 - 20:50	Th		Dalibor Dvorski

Fall 2018 [1189]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5719	112 / 115	08:30 - 09:50	T,Th	MC 4021	Grant Weddell
LEC 002	5889	87 / 85	13:00 - 14:20	T,Th	MC 4045	Grant Weddell
LEC 003	6055	73 / 85	14:30 - 15:50	T,Th	MC 4045	Grant Weddell
LEC 004	9448	6 / 1
TST 101	6260	272 / 285	16:30 - 18:00	F		Dalibor Dvorski

Spring 2018 [1185]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3556	47 / 70	10:00 - 11:20	M,W	RCH 308	Grant Weddell
LEC 002	3836	59 / 70	11:30 - 12:50	M,W	RCH 308	Grant Weddell
LEC 003	4911	47 / 70	14:30 - 15:50	M,W	RCH 306	David Toman
TST 101	3874	153 / 210	19:00 - 20:50	Th		Ahmed Hajyasien

Winter 2018 [1181]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5725	65 / 70	14:30 - 15:50	M,W	AL 211	Tamer Ozsu
LEC 002	6415	54 / 70	10:00 - 11:20	M,W	OPT 309	Xiaofei Zhang
LEC 003	9381	3 / 1
TST 101	6249	119 / 140	19:00 - 20:50	T		Ahmed Hajyasien

Fall 2017 [1179]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5811	102 / 105	14:30 - 15:50	M,F	RCH 110	Grant Weddell
LEC 002	5986	67 / 80	13:00 - 14:20	M,F	RCH 309	Grant Weddell
LEC 003	6174	55 / 80	14:30 - 15:50	M,W	MC 2034	David Toman
LEC 004	6518	55 / 80	13:00 - 14:20	M,W	MC 2034	David Toman
LEC 005	9390	4 / 1
LEC 006	9413	1 / 1
TST 101	6399	279 / 345	16:30 - 18:00	F		Ahmed Hajyasien

Spring 2017 [1175]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3555	76 / 90	10:00 - 11:20	M,W	MC 1056	David Toman
LEC 002	3851	69 / 90	14:30 - 15:50	M,W	MC 1056	David Toman
TST 101	3892	145 / 180	19:00 - 20:50	Th		Ahmed Hajyasien

Winter 2017 [1171]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5456	66 / 70	13:00 - 14:20	T,Th	MC 4040	Grant Weddell
LEC 002	9625	66 / 70	11:30 - 12:50	T,Th	MC 4040	Grant Weddell
LEC 003	9471	9 / 1
TST 101	6016	132 / 140	19:00 - 20:50	T		Ahmed Hajyasien

Fall 2016 [1169]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5788	64 / 70	09:30 - 10:20	M,W,F	MC 2038	Alexandra Roatis
LEC 002	5968	69 / 70	12:30 - 13:20	M,W,F	MC 4040	Xiaofei Zhang
LEC 003	6164	32 / 70	08:30 - 09:20	M,W,F	MC 4040	Edward Chan
LEC 004	7765	49 / 70	09:30 - 10:20	M,W,F	MC 4040	Edward Chan
LEC 005	7766	52 / 70	11:30 - 12:20	M,W,F	MC 4040	Edward Chan
LEC 006	9140	3 / 1
TST 101	6419	266 / 350	16:30 - 18:00	F		Ahmed Hajyasien

Spring 2016 [1165]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3558	80 / 87	14:30 - 15:50	T,Th	MC 2017	Grant Weddell
LEC 002	3878	81 / 87	13:00 - 14:20	T,Th	MC 2017	Grant Weddell
LEC 003	5364	0 / 1
TST 101	3928	161 / 174	19:00 - 20:50	T		Ahmed Hajyasien

Winter 2016 [1161]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5996	98 / 100	14:30 - 15:50	W,F	MC 4045	Alexandra Roatis
LEC 002	8867	4 / 1
TST 101	7821	98 / 100	19:00 - 20:50	W		Ahmed Hajyasien

Fall 2015 [1159]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	6055	81 / 80	08:30 - 09:20	M,W,F	PHY 235	Edward Chan
LEC 002	6235	78 / 80	09:30 - 10:20	M,W,F	PHY 313	Edward Chan
LEC 003	6454	79 / 80	11:30 - 12:20	M,W,F	PHY 313	Edward Chan
LEC 004	8945	4 / 4
TST 101	7765	238 / 240	16:30 - 18:00	F

Spring 2015 [1155]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3628	66 / 70	14:30 - 15:50	W,F	MC 2034	Alexandra Roatis
LEC 002	3962	66 / 70	11:30 - 12:50	W,F	MC 2054	Alexandra Roatis
TST 101	4651	132 / 140	19:00 - 20:50	T

Winter 2015 [1151]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5784	98 / 100	13:00 - 14:20	M,W	MC 2017	Grant Weddell
LEC 002	8690	6 / 1
TST 101	7733	98 / 100	19:00 - 20:50	Th

Fall 2014 [1149]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5720	79 / 80	10:00 - 11:20	M,W	PAS 1229	Ahmed Ayaz Ataullah
LEC 002	5902	75 / 80	14:30 - 15:50	M,W	MC 2038	Ahmed Ayaz Ataullah
LEC 003	6137	58 / 80	08:30 - 09:50	M,W	RCH 305	Edward Lawrence Barsalou
LEC 004	7588	81 / 80	13:00 - 14:20	M,W	PHY 313	Ahmed Ayaz Ataullah
LEC 005	8691	3 / 1
TST 101	7589	296 / 320	19:00 - 20:50	T

Spring 2014 [1145]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3537	80 / 80	11:30 - 12:50	T,Th	MC 1056	Grant Weddell
LEC 002	4520	78 / 80	13:00 - 14:20	T,Th	MC 2034	Grant Weddell
TST 101	4521	158 / 160	19:00 - 20:50	T

Winter 2014 [1141]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5596	34 / 60	08:30 - 09:50	T,Th	MC 4061	Edward Chan
LEC 002	7330	46 / 60	11:30 - 12:50	T,Th	DWE 3516	Edward Chan
LEC 003	8667	2 / 1
TST 101	6081	80 / 120	17:30 - 18:50	Th

Fall 2013 [1139]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5375	87 / 90	08:30 - 09:50	T,Th	MC 2034	Edward Chan
LEC 002	5558	65 / 90	11:30 - 12:50	T,Th	MC 1056	Edward Chan
LEC 003	5802	92 / 90	13:00 - 14:20	T,Th	MC 1056	Grant Weddell
LEC 004	8255	1 / 1
TST 101	7403	244 / 270	16:00 - 17:20	T

Spring 2013 [1135]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3365	72 / 90	13:00 - 14:20	T,Th	MC 2034	Edward Chan

Winter 2013 [1131]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5353	94 / 95	16:00 - 17:20	T,Th	MC 1056	Ashraf Aboulnaga
LEC 002	8289	2 / 1
LEC 003	8342	1 / 1
TST 101	7639	94 / 95	19:00 - 20:50	T

Fall 2012 [1129]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5297	95 / 95	10:00 - 11:20	T,Th	MC 2035	Tamer Ozsu
LEC 002	5498	61 / 95	11:30 - 12:50	T,Th	MC 2034	Edward Chan
LEC 003	5759	95 / 95	13:00 - 14:20	T,Th	MC 1056	Tamer Ozsu

Spring 2012 [1125]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3411	40 / 50	08:30 - 09:50	T,Th	MC 4041	Grant Weddell
LEC 002	3709	49 / 50	13:00 - 14:20	T,Th	MC 4041	Grant Weddell

Winter 2012 [1121]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5136	81 / 85	10:00 - 11:20	T,Th	PHY 235	Igor Ivkovic
LEC 002	8185	3 / 1

Fall 2011 [1119]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5124	79 / 80	10:00 - 11:20	T,Th	MC 2035	Grant Weddell
LEC 002	5333	77 / 80	13:00 - 14:20	T,Th	MC 2035	Grant Weddell
LEC 003	5653	62 / 80	11:30 - 12:20	M,W,F	MC 1056	Iman Elghandour

Spring 2011 [1115]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3301	44 / 50	13:00 - 14:20	T,Th	MC 4042	Edward Chan
LEC 002	4370	43 / 50	10:00 - 11:20	T,Th	MC 4061	Edward Chan

Winter 2011 [1111]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5093	91 / 85	10:00 - 11:20	T,Th	MC 2038	Grant Weddell
LEC 002	8120	4 / 1

Fall 2010 [1109]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5160	69 / 80	10:00 - 11:20	T,Th	MC 2038	Edward Chan
LEC 002	5392	69 / 80	13:00 - 14:20	T,Th	RCH 309	Edward Chan
LEC 003	7151	80 / 80	11:30 - 12:20	M,W,F	PHY 150	Igor Ivkovic
LEC 004	8042	4 / 1

Spring 2010 [1105]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	4710	79 / 75	12:30 - 13:20	M,W,F	MC 2038	Grant Weddell

Winter 2010 [1101]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	5061	61 / 60	13:00 - 14:20	T,Th	MC 4059	Frank W Tompa

Fall 2009 [1099]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	4891	74 / 70	12:30 - 13:20	M,W,F	MC 2035	Ihab Ilyas
LEC 002	5136	83 / 80	10:30 - 11:20	M,W,F	PHY 150	Ihab Ilyas

Spring 2009 [1095]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3156	66 / 66	11:30 - 12:50	T,Th	MC 4042	Edward Chan

Winter 2009 [1091]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	4292	78 / 70	11:30 - 12:50	T,Th	MC 1056	Ihab Ilyas

Fall 2008 [1089]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3767	63 / 80	11:30 - 12:50	T,Th	CPH 3386	David Toman
LEC 002	4041	75 / 80	16:00 - 17:20	T,Th	MC 2034	David Toman

Spring 2008 [1085]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	2594	67 / 60	14:30 - 15:50	T,Th	MC 2054	Amir Hossein Chinaei

Winter 2008 [1081]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3457	47 / 80	11:30 - 12:50	T,Th	RCH 306	Amir Hossein Chinaei
LEC 002	3458	28 / 30	13:00 - 14:20	T,Th	RCH 209	Amir Hossein Chinaei

Fall 2007 [1079]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3481	52 / 60	13:00 - 14:20	T,Th	MC 2035	Ashraf Aboulnaga
LEC 002	3482	40 / 60	10:00 - 11:20	T,Th	MC 2034	Ihab Ilyas
LEC 003	3787	61 / 65	09:30 - 10:20	M,W,F	RCH 207	Grant Weddell

Spring 2007 [1075]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	2210	34 / 60	11:30 - 12:50	T,Th	MC 4063	David Edward DeHaan
LEC 002	2211	28 / 60	14:30 - 15:50	T,Th	MC 4063	David Edward DeHaan

Winter 2007 [1071]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3399	84 / 75	11:30 - 12:50	T,Th	MC 2038	Ashraf Aboulnaga
LEC 002	3400	72 / 75	14:30 - 15:50	T,Th	MC 2038	Ashraf Aboulnaga

Fall 2006 [1069]

Section	Class	Enrolled	Time	Days	Location	Instructor
LEC 001	3370	88 / 90	16:00 - 17:20	T,Th	MC 2038	David Toman
LEC 002	3371	85 / 90	08:30 - 09:50	T,Th	PHY 150	Edward Chan
LEC 003	3708	73 / 90	14:30 - 15:50	T,Th	MC 2054	David Toman

UW Flow Ratings

Liked: 38.03%

38.03%

Easy: 63.79%

63.79%

Useful: 59.78 %

59.78%

CS 348 leads to

CS 448 - Database Systems Implementation

CS 451 - Data-Intensive Distributed Computing

MSE 446 - Introduction to Machine Learning

MSE 436 - Decision Support Systems