All Courses > CPSC > CPSC 2221

CPSC 2221: Data Base Systems

A comprehensive introduction to theory and practice of designing and building databases and applications using database management systems. The relational model, relational algebra, SQL (the standard language for creating, querying, and modifying relational databases), UML or E/R approach to database design, as well as relational design principles based on functional dependencies and normal forms. Other topics include indexes, views, transactions, integrity constraints, and triggers. Students will design and implement a relational database for an enterprise as a major project using programming tools widely used in industry (e.g., Oracle).

Students will receive credit for only one of CPSC 1220 and 2221.

Prerequisite(s): A minimum "C" grade in one of CPSC 1040, 1045, 1150, or 1155. Prerequisites are valid for only three years.

Course Information:

Credits:

3.0

Additional Fees:

$125.8

Repeat Limit:

2

Lecture Hours:

4.0

Seminar Hours:

0.0

Lab Hours:

2.0

Offered online:

False

Course outline(s):

None


2AR 2SC HUM LSC SCI SOC UT
False True False False True False True

Transfers:

Course Destination Credit Start/End
CPSC 2221 AU AU COMP 378 (3) 20170501 to Present
CPSC 2221 DOUG DOUG CMPT 2XXX (3) or DOUG CSIS 2300 (3) 20220901 to Present
CPSC 2221 KPU KPU INFO 2312 (3) 20200501 to Present
CPSC 2221 SFU SFU CMPT 354 (3) 20110501 to Present
CPSC 2221 TRU TRU COMP 3610 (3) 20150501 to Present
CPSC 2221 TWU TWU CMPT 339 (3) 20220901 to Present
CPSC 2221 UBCO UBCO COSC_O 1st (3) 20110501 to Present
CPSC 2221 UBCV UBCV CPSC_V 2nd (3) 20110501 to Present
CPSC 2221 UNBC UNBC CPSC 324 (3) 20150501 to Present
CPSC 2221 UVIC UVIC CSC 1XX (1.5) 20110501 to Present
CPSC 2221 VIU VIU QUME 185 (3) 20110501 to Present

Inactive Transfers:

Course Destination Credit Start/End
CPSC 2221 DOUG DOUG CMPT 2XXX (3) 20110501 to 20220831
CPSC 2221 KPU KPU CISY 2314 (3) 20110501 to 20200430
CPSC 2221 TRU TRU COMP 1XXX (3) 20110501 to 20150430
CPSC 2221 UFV UFV CIS 230 (3) 20110501 to 20151231
CPSC 2221 UNBC UNBC CPSC 2XX (3) For CPSC majors will waive CPSC 324 (3) requirement 20110501 to 20150430

Current Offerings:

Semester CRN Section Seats Waitlist Days Time Room Type Instructor
2025 10 10658 001 14 5 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
M------ 0830-1020 B015 Lab Saeed Mirjalili
2025 10 10659 002 16 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
--W---- 0830-1020 B015 Lab Saeed Mirjalili

Previous Offerings:

Semester Seats Waitlist Days Time Room Type Instructor
2024 30 0 17 -T-R--- 0830-1020 A136A Lecture Hazra Imran
--W---- 0830-1020 A275 Lab Hazra Imran
----F-- 1100-1255 A276 Exam Hazra Imran, Kim Lam
2024 30 0 17 -T-R--- 0830-1020 A136A Lecture Hazra Imran
M------ 0830-1020 A275 Lab Hazra Imran
----F-- 1100-1255 A272 Exam Hazra Imran
2024 20 0 8 -T-R--- 1630-1820 B248 Lecture Ao Ao Feng
----F-- 1630-1820 B019 Lab Ao Ao Feng
---R--- 1330-1525 A275 Exam Ao Ao Feng
2024 20 2 20 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
-T----- 1630-1820 A275 Lab Saeed Mirjalili
-----S- 0900-1055 L104 Exam Alireza Osareh, Saeed Mirjalili
2024 20 6 11 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
M------ 1630-1820 A275 Lab Saeed Mirjalili
-----S- 0900-1055 L103 Exam Saeed Mirjalili
2024 10 1 26 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
--W---- 0830-1020 B015 Lab Saeed Mirjalili
-T----- 1100-1255 L304 Exam Gladys Monagan, Saeed Mirjalili
2024 10 2 23 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
M------ 0830-1020 B015 Lab Saeed Mirjalili
-T----- 1100-1255 L303 Exam Saeed Mirjalili
2023 30 1 13 -T-R--- 0830-1020 A136A Lecture Hazra Imran
--W---- 0830-1020 A275 Lab Hazra Imran
--W---- 1600-1755 B153 Exam Bojiang Ma, Hazra Imran
2023 30 6 7 -T-R--- 0830-1020 A136A Lecture Hazra Imran
M------ 0830-1020 A275 Lab Hazra Imran
--W---- 1600-1755 B155 Exam Hazra Imran
2023 20 1 17 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
-T----- 1630-1820 A275 Lab Saeed Mirjalili
--W---- 1600-1755 B019 Exam Lixin Pan, Saeed Mirjalili
2023 20 1 20 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
M------ 1630-1820 A275 Lab Saeed Mirjalili
--W---- 1600-1755 B015 Exam Saeed Mirjalili
2023 10 1 14 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
--W---- 0830-1020 B015 Lab Saeed Mirjalili
----F-- 0830-1025 B019 Exam Mingwu Chen, Saeed Mirjalili
2023 10 2 9 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
M------ 0830-1020 B015 Lab Saeed Mirjalili
----F-- 0830-1025 B015 Exam Saeed Mirjalili
2022 30 8 17 -T-R--- 0830-1020 A136A Lecture Chinmaya Mahapatra
--W---- 0830-1020 A275 Lab Chinmaya Mahapatra
-----S- 1300-1555 B019 Exam Bojiang Ma, Chinmaya Mahapatra
2022 30 6 20 -T-R--- 0830-1020 A136A Lecture Chinmaya Mahapatra
M------ 0830-1020 A275 Lab Chinmaya Mahapatra
-----S- 1300-1555 B015 Exam Chinmaya Mahapatra
2022 20 0 5 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
-T----- 1630-1820 A275 Lab Saeed Mirjalili
-T----- 1330-1525 T530 Exam Saeed Mirjalili
2022 20 3 6 --WR--- 1630-1820 A122B Lecture Saeed Mirjalili
M------ 1630-1820 A275 Lab Saeed Mirjalili
-T----- 1330-1525 T530 Exam Saeed Mirjalili
2022 10 8 7 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
--W---- 0830-1020 A275 Lab Saeed Mirjalili
--W---- 1600-1755 T530 Exam Saeed Mirjalili
2022 10 5 4 -T-R--- 0830-1020 A122A Lecture Saeed Mirjalili
M------ 0830-1020 B015 Lab Saeed Mirjalili
--W---- 1600-1755 T530 Exam Saeed Mirjalili
2021 30 10 5 -T-R--- 0830-1020 A122A Lecture Reza Abbasi
--W---- 0830-1020 A275 Lab Reza Abbasi
-T----- 1100-1255 B031 Exam Reza Abbasi, Sahar Banisoltan
2021 30 7 3 -T-R--- 0830-1020 A122A Lecture Reza Abbasi
M------ 0830-1020 B015 Lab Reza Abbasi
-T----- 1100-1255 B032 Exam Reza Abbasi
2021 20 2 12 M------ 1630-1820 WWW WWW Saeed Mirjalili
--WR--- 1630-1820 WWW WWW Saeed Mirjalili
-T----- 0830-1025 WWW Exam Saeed Mirjalili
2021 20 2 13 -T----- 1630-1820 WWW WWW Saeed Mirjalili
--WR--- 1630-1820 WWW WWW Saeed Mirjalili
-T----- 0830-1025 WWW Exam Saeed Mirjalili
2021 10 7 19 --W---- 0803-1020 WWW WWW Hazra Imran
-T-R--- 0830-1020 WWW WWW Hazra Imran
----F-- 0830-1025 WWW Exam Hazra Imran
2021 10 2 15 M------ 0830-1020 WWW WWW Hazra Imran
-T-R--- 0830-1020 WWW WWW Hazra Imran
----F-- 0830-1025 WWW Exam Hazra Imran
2020 30 1 9 -T-R--- 0830-1020 WWW WWW Hazra Imran
--W---- 0830-1020 WWW WWW Hazra Imran
-T----- 1600-1755 WWW Exam Hazra Imran
2020 30 4 9 M------ 0830-1020 WWW WWW Hazra Imran
-T-R--- 0830-1020 WWW WWW Hazra Imran
-T----- 1600-1755 WWW Exam Hazra Imran
2020 20 3 6 M------ 1630-1820 WWW Lab Saeed Mirjalili
--WR--- 1630-1820 WWW WWW Saeed Mirjalili
---R--- 0830-1025 WWW Exam Saeed Mirjalili
2020 20 3 8 -T----- 1630-1820 WWW Lab Saeed Mirjalili
--WR--- 1630-1820 WWW WWW Saeed Mirjalili
---R--- 0830-1025 WWW Exam Saeed Mirjalili
2020 10 6 --W-F-- 0830-1020 A218 Lecture Hazra Imran
M------ 0830-1020 A275 Lab Hazra Imran
-T----- 0830-1025 A218 Exam Hazra Imran
2020 10 8 4 -T-R--- 0830-1020 A363A Lecture Saeed Mirjalili
M------ 0830-1020 B015 Lab Saeed Mirjalili
-T----- 0830-1025 A363A Exam Saeed Mirjalili
2019 30 9 --W-F-- 1230-1420 T530 Lecture Hazra Imran
M------ 1430-1620 B019 Lab Hazra Imran
-----S- 1300-1455 C510 Exam Hazra Imran, Michael Jon Burrell
2019 30 1 1 --W-F-- 1230-1420 T530 Lecture Hazra Imran
M------ 1230-1420 L304 Lab Hazra Imran
-----S- 1300-1455 C509 Exam Hazra Imran
2019 20 15 M-W---- 1630-1820 T530 Lecture Saeed Mirjalili
---R--- 1630-1820 A275 Lab Saeed Mirjalili
M------ 1100-1255 A276 Exam Khurram Shehzad, Saeed Mirjalili
2019 20 6 M-W---- 1630-1820 T530 Lecture Saeed Mirjalili
-T----- 1630-1820 A275 Lab Saeed Mirjalili
M------ 1100-1255 A272 Exam Saeed Mirjalili
2019 10 1 8 -T-R--- 1430-1620 B152 Lecture Hazra Imran
----F-- 1430-1620 B019 Lab Hazra Imran
----F-- 1600-1755 B152 Exam Hazra Imran
2019 10 9 7 MT----- 0830-1020 C410 Lecture Saeed Mirjalili
---R--- 0830-1020 B015 Lab Saeed Mirjalili
----F-- 1600-1755 B022 Exam Saeed Mirjalili
2018 30 0 17 M-W---- 1430-1620 T450 Lecture Hazra Imran
-T----- 1430-1620 C213 Lab Hazra Imran
M------ 1330-1525 B031 Exam Hazra Imran, Joe Huang
2018 30 0 20 M-W---- 1430-1620 T450 Lecture Hazra Imran
---R--- 1430-1620 C213 Lab Hazra Imran
M------ 1330-1525 B032 Exam Hazra Imran
2018 20 1 3 M-W---- 1430-1620 T001 Lecture Saeed Mirjalili
---R--- 1430-1620 A351 Lab Saeed Mirjalili
----F-- 1600-1755 B009 Exam Fred Parvaz, Saeed Mirjalili
2018 20 1 10 M-W---- 1430-1620 T001 Lecture Saeed Mirjalili
-T----- 1430-1620 A351 Lab Saeed Mirjalili
----F-- 1600-1755 B008 Exam Saeed Mirjalili
2018 10 3 10 M-W---- 1330-1520 A310 Lecture Saeed Mirjalili
----F-- 1330-1520 B019 Lab Saeed Mirjalili
-----S- 1300-1455 B152 Exam Saeed Mirjalili
2018 10 3 8 -T-R--- 0830-1020 A350 Lecture Hazra Imran
----F-- 0830-1020 A351 Lab Hazra Imran
-----S- 1300-1455 B155 Exam Hazra Imran
2017 30 1 28 M-W---- 1030-1220 T450 Lecture Hazra Imran
---R--- 1030-1220 C213 Lab Hazra Imran
--W---- 0830-1025 B031 Exam Hazra Imran, Sirine Maalej
2017 30 6 16 M-W---- 1030-1220 T450 Lecture Hazra Imran
---R--- 0830-1020 C213 Lab Hazra Imran
--W---- 0830-1025 B032 Exam Hazra Imran
2017 20 10 6 -TW---- 0830-1020 B027 Lecture Hazra Imran
---R--- 0830-1020 B019 Lab Hazra Imran
---R--- 1330-1525 B031 Exam Hazra Imran, Saeed Mirjalili
2017 20 1 21 -TW---- 1030-1220 A255 Lecture Hazra Imran
---R--- 1030-1220 B015 Lab Hazra Imran
---R--- 1330-1525 B032 Exam Hazra Imran
2017 10 3 41 M-W---- 0830-1020 B153 Lecture Hazra Imran
----F-- 0830-1020 A351 Lab Hazra Imran
----F-- 0830-1025 B153 Exam Hazra Imran
2016 30 0 21 MTWR--- 1530-1620 B032 Lecture Hazra Imran
----F-- 1230-1420 B015 Lab Hazra Imran
M------ 1100-1255 B032 Exam Hazra Imran
2016 20 0 36 -TW---- 1030-1220 B154 Lecture Hazra Imran
---R--- 1030-1220 B015 Lab Hazra Imran
--W---- 0830-1025 B032 Exam Hazra Imran
2016 10 6 12 M-W---- 0830-1020 B154 Lecture Hazra Imran
----F-- 0830-1020 A351 Lab Hazra Imran
-T----- 0830-1025 B030 Exam Hazra Imran
2015 20 0 19 -TW---- 1030-1220 B154 Lecture Hengameh Hamavand
---R--- 1030-1220 A219 Lecture Hengameh Hamavand
-T----- 0830-1025 B154 Exam Hengameh Hamavand
2014 20 4 9 -TW---- 1030-1220 B022 Lecture Hengameh Hamavand
---R--- 1030-1220 A219 Lab Hengameh Hamavand
-T----- 0830-1025 B022 Exam Hengameh Hamavand
2013 20 2 N/A M-W---- 1030-1220 B154 Lecture Hengameh Hamavand
---R--- 1030-1220 A219 Lab Hengameh Hamavand
---R--- 0830-1025 B154 Exam Hengameh Hamavand
2012 20 4 N/A -T-R--- 1030-1220 B154 Lecture Hengameh Hamavand
--W---- 1030-1220 L103 Lab Hengameh Hamavand
-T----- 0830-1025 B018 Exam Hengameh Hamavand
2011 20 4 N/A MT----- 1230-1420 B154 Lecture Hengameh Hamavand
----F-- 1230-1420 A215 Lab Hengameh Hamavand
----F-- 0830-1025 B153 Exam Hengameh Hamavand