Langara Course Information

Note: this website is a student project and is not affiliated with Langara College.

Suggestions? Feedback? Found a bug? Please send a report through this form.

CPSC 2221: Data Base Systems

Course FormatLecture 4.0 h + Seminar 0.0 h + Lab 2.0 h
Credits3.0

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 Attributes:
2nd Year ArtsNo
2nd Year ScienceYes
HumanitiesNo
Lab ScienceNo
ScienceYes
Social ScienceNo
University
Transferable		Yes
Other Attributes:
Offered online:No
Preparatory course:No
Repeat limit2
Additional fees:$128.3
First offered:Summer 2011
Last offered:Fall 2025
Registration
restrictions:		P
Outline(s):

CPSC 2221 - Summer 2019 (v. 2)

Transfer Agreements
CourseDestinationCreditStart to End
CPSC 2221Athabasca UniversityAU COMP 378 (3) 20170501 to present
CPSC 2221Douglas CollegeDOUG CMPT 2XXX (3) or DOUG CSIS 2300 (3) 20220901 to present
CPSC 2221Kwantlen Polytechnic UniversityKPU INFO 2312 (3) 20200501 to present
CPSC 2221Simon Fraser UniversitySFU CMPT 354 (3) 20110501 to present
CPSC 2221Thompson Rivers UniversityTRU COMP 3610 (3) 20150501 to present
CPSC 2221Trinity Western UniversityTWU CMPT 339 (3) 20220901 to present
CPSC 2221UBCOUBCO COSC_O 2nd (3) 20110501 to present
CPSC 2221UBCVUBCV CPSC_V 2nd (3) 20110501 to present
CPSC 2221University of Northern BCUNBC CPSC 324 (3) 20150501 to present
CPSC 2221University of VictoriaUVIC CSC 1XX (1.5) 20110501 to present
CPSC 2221Vancouver Island UniversityVIU QUME 185 (3) 20110501 to present
Inactive Transfer Agreements (click to open)

Note: If you took courses within the period stated below, you can still transfer those credits.

CourseDestinationCreditStart to End
CPSC 2221Douglas CollegeDOUG CMPT 2XXX (3) 20110501 to 20220831
CPSC 2221Kwantlen Polytechnic UniversityKPU CISY 2314 (3) 20110501 to 20200430
CPSC 2221Thompson Rivers UniversityTRU COMP 1XXX (3) 20110501 to 20150430
CPSC 2221University of the Fraser ValleyUFV CIS 230 (3) 20110501 to 20151231
CPSC 2221University of Northern BCUNBC CPSC 2XX (3) For CPSC majors will waive CPSC 324 (3) requirement20110501 to 20150430

Offerings of this course:

SemesterCRNSectionSeatsWaitlistDaysTimeRoomTypeInstructor
Fall 20253058100236N/A-T-R---0830-1020A136ALectureHazra Imran
--W----1030-1220A275LabHazra Imran
Fall 20253058000136N/A-T-R---0830-1020A136ALectureHazra Imran
--W----0830-1020A275LabHazra Imran
Summer 202520074002825--WR---1630-1820A122BLectureSaeed Mirjalili
-T-----1630-1820A275LabSaeed Mirjalili
Summer 2025200720011325--WR---1630-1820A122BLectureSaeed Mirjalili
M------1630-1820A275LabSaeed Mirjalili
Spring 2025112600035 M-W----1430-1620A122ALectureLixin Pan
-T-----1430-1620A275LabLixin Pan
-----S-0900-1155L103ExamLixin Pan
Spring 2025106590020 -T-R---0830-1020A122ALectureSaeed Mirjalili
--W----0830-1020B015LabSaeed Mirjalili
-----S-0900-1155B019ExamGladys Monagan, Saeed Mirjalili
Spring 2025106580011 -T-R---0830-1020A122ALectureSaeed Mirjalili
M------0830-1020B015LabSaeed Mirjalili
-----S-0900-1155B015ExamSaeed Mirjalili
Fall 202430125002016-T-R---0830-1020A136ALectureHazra Imran
--W----0830-1020A275LabHazra Imran
----F--1100-1255A276ExamHazra Imran, Kim Lam
Fall 202430124001016-T-R---0830-1020A136ALectureHazra Imran
M------0830-1020A275LabHazra Imran
----F--1100-1255A272ExamHazra Imran
Summer 20242078000308-T-R---1630-1820B248LectureAo Ao Feng
----F--1630-1820B019LabAo Ao Feng
---R---1330-1525A275ExamAo Ao Feng
Summer 202420546002219--WR---1630-1820A122BLectureSaeed Mirjalili
-T-----1630-1820A275LabSaeed Mirjalili
-----S-0900-1055L104ExamAlireza Osareh, Saeed Mirjalili
Summer 202420545001711--WR---1630-1820A122BLectureSaeed Mirjalili
M------1630-1820A275LabSaeed Mirjalili
-----S-0900-1055L103ExamSaeed Mirjalili
Spring 202410415002126-T-R---0830-1020A122ALectureSaeed Mirjalili
--W----0830-1020B015LabSaeed Mirjalili
-T-----1100-1255L304ExamGladys Monagan, Saeed Mirjalili
Spring 202410414001223-T-R---0830-1020A122ALectureSaeed Mirjalili
M------0830-1020B015LabSaeed Mirjalili
-T-----1100-1255L303ExamSaeed Mirjalili
Fall 202330499002113-T-R---0830-1020A136ALectureHazra Imran
--W----0830-1020A275LabHazra Imran
--W----1600-1755B153ExamBojiang Ma, Hazra Imran
Fall 20233049800167-T-R---0830-1020A136ALectureHazra Imran
M------0830-1020A275LabHazra Imran
--W----1600-1755B155ExamHazra Imran
Summer 202320459002117--WR---1630-1820A122BLectureSaeed Mirjalili
-T-----1630-1820A275LabSaeed Mirjalili
--W----1600-1755B019ExamLixin Pan, Saeed Mirjalili
Summer 202320458001120--WR---1630-1820A122BLectureSaeed Mirjalili
M------1630-1820A275LabSaeed Mirjalili
--W----1600-1755B015ExamSaeed Mirjalili
Spring 202310750002114-T-R---0830-1020A122ALectureSaeed Mirjalili
--W----0830-1020B015LabSaeed Mirjalili
----F--0830-1025B019ExamMingwu Chen, Saeed Mirjalili
Spring 20231074900129-T-R---0830-1020A122ALectureSaeed Mirjalili
M------0830-1020B015LabSaeed Mirjalili
----F--0830-1025B015ExamSaeed Mirjalili
Fall 202230397002817-T-R---0830-1020A136ALectureChinmaya Mahapatra
--W----0830-1020A275LabChinmaya Mahapatra
-----S-1300-1555B019ExamBojiang Ma, Chinmaya Mahapatra
Fall 202230396001620-T-R---0830-1020A136ALectureChinmaya Mahapatra
M------0830-1020A275LabChinmaya Mahapatra
-----S-1300-1555B015ExamChinmaya Mahapatra
Summer 20222062700205--WR---1630-1820A122BLectureSaeed Mirjalili
-T-----1630-1820A275LabSaeed Mirjalili
-T-----1330-1525T530ExamSaeed Mirjalili
Summer 20222062600136--WR---1630-1820A122BLectureSaeed Mirjalili
M------1630-1820A275LabSaeed Mirjalili
-T-----1330-1525T530ExamSaeed Mirjalili
Spring 20221082900287-T-R---0830-1020A122ALectureSaeed Mirjalili
--W----0830-1020A275LabSaeed Mirjalili
--W----1600-1755T530ExamSaeed Mirjalili
Spring 20221082800154-T-R---0830-1020A122ALectureSaeed Mirjalili
M------0830-1020B015LabSaeed Mirjalili
--W----1600-1755T530ExamSaeed Mirjalili
Fall 202130454002105-T-R---0830-1020A122ALectureReza Abbasi
--W----0830-1020A275LabReza Abbasi
-T-----1100-1255B031ExamReza Abbasi, Sahar Banisoltan
Fall 20213045300173-T-R---0830-1020A122ALectureReza Abbasi
M------0830-1020B015LabReza Abbasi
-T-----1100-1255B032ExamReza Abbasi
Summer 202120147W02212M------1630-1820WWWWWWSaeed Mirjalili
--WR---1630-1820WWWWWWSaeed Mirjalili
-T-----0830-1025WWWExamSaeed Mirjalili
Summer 202120146W01213-T-----1630-1820WWWWWWSaeed Mirjalili
--WR---1630-1820WWWWWWSaeed Mirjalili
-T-----0830-1025WWWExamSaeed Mirjalili
Spring 202110265W02719--W----0803-1020WWWWWWHazra Imran
-T-R---0830-1020WWWWWWHazra Imran
----F--0830-1025WWWExamHazra Imran
Spring 202110264W01215M------0830-1020WWWWWWHazra Imran
-T-R---0830-1020WWWWWWHazra Imran
----F--0830-1025WWWExamHazra Imran
Fall 202031927W0219-T-R---0830-1020WWWWWWHazra Imran
--W----0830-1020WWWWWWHazra Imran
-T-----1600-1755WWWExamHazra Imran
Fall 202031926W0149M------0830-1020WWWWWWHazra Imran
-T-R---0830-1020WWWWWWHazra Imran
-T-----1600-1755WWWExamHazra Imran
Summer 202021131W0236M------1630-1820WWWLabSaeed Mirjalili
--WR---1630-1820WWWWWWSaeed Mirjalili
---R---0830-1025WWWExamSaeed Mirjalili
Summer 202021130W0138-T-----1630-1820WWWLabSaeed Mirjalili
--WR---1630-1820WWWWWWSaeed Mirjalili
---R---0830-1025WWWExamSaeed Mirjalili
Spring 2020106670026 --W-F--0830-1020A218LectureHazra Imran
M------0830-1020A275LabHazra Imran
-T-----0830-1025A218ExamHazra Imran
Spring 20201066600184-T-R---0830-1020A363ALectureSaeed Mirjalili
M------0830-1020B015LabSaeed Mirjalili
-T-----0830-1025A363AExamSaeed Mirjalili
Fall 2019311040029 --W-F--1230-1420T530LectureHazra Imran
M------1430-1620B019LabHazra Imran
-----S-1300-1455C510ExamHazra Imran, Michael Jon Burrell
Fall 20193110300111--W-F--1230-1420T530LectureHazra Imran
M------1230-1420L304LabHazra Imran
-----S-1300-1455C509ExamHazra Imran
Summer 20192054300215 M-W----1630-1820T530LectureSaeed Mirjalili
---R---1630-1820A275LabSaeed Mirjalili
M------1100-1255A276ExamKhurram Shehzad, Saeed Mirjalili
Summer 2019205420016 M-W----1630-1820T530LectureSaeed Mirjalili
-T-----1630-1820A275LabSaeed Mirjalili
M------1100-1255A272ExamSaeed Mirjalili
Spring 20191095100218-T-R---1430-1620B152LectureHazra Imran
----F--1430-1620B019LabHazra Imran
----F--1600-1755B152ExamHazra Imran
Spring 20191095000197MT-----0830-1020C410LectureSaeed Mirjalili
---R---0830-1020B015LabSaeed Mirjalili
----F--1600-1755B022ExamSaeed Mirjalili
Fall 201830889002017M-W----1430-1620T450LectureHazra Imran
-T-----1430-1620C213LabHazra Imran
M------1330-1525B031ExamHazra Imran, Joe Huang
Fall 201830888001020M-W----1430-1620T450LectureHazra Imran
---R---1430-1620C213LabHazra Imran
M------1330-1525B032ExamHazra Imran
Summer 20182048000213M-W----1430-1620T001LectureSaeed Mirjalili
---R---1430-1620A351LabSaeed Mirjalili
----F--1600-1755B009ExamFred Parvaz, Saeed Mirjalili
Summer 201820479001110M-W----1430-1620T001LectureSaeed Mirjalili
-T-----1430-1620A351LabSaeed Mirjalili
----F--1600-1755B008ExamSaeed Mirjalili
Spring 201811067002310M-W----1330-1520A310LectureSaeed Mirjalili
----F--1330-1520B019LabSaeed Mirjalili
-----S-1300-1455B152ExamSaeed Mirjalili
Spring 20181106600138-T-R---0830-1020A350LectureHazra Imran
----F--0830-1020A351LabHazra Imran
-----S-1300-1455B155ExamHazra Imran
Fall 201730205002128M-W----1030-1220T450LectureHazra Imran
---R---1030-1220C213LabHazra Imran
--W----0830-1025B031ExamHazra Imran, Sirine Maalej
Fall 201730204001616M-W----1030-1220T450LectureHazra Imran
---R---0830-1020C213LabHazra Imran
--W----0830-1025B032ExamHazra Imran
Summer 201720436002106-TW----0830-1020B027LectureHazra Imran
---R---0830-1020B019LabHazra Imran
---R---1330-1525B031ExamHazra Imran, Saeed Mirjalili
Summer 201720435001121-TW----1030-1220A255LectureHazra Imran
---R---1030-1220B015LabHazra Imran
---R---1330-1525B032ExamHazra Imran
Spring 201711119001341M-W----0830-1020B153LectureHazra Imran
----F--0830-1020A351LabHazra Imran
----F--0830-1025B153ExamHazra Imran
Fall 201630401001021MTWR---1530-1620B032LectureHazra Imran
----F--1230-1420B015LabHazra Imran
M------1100-1255B032ExamHazra Imran
Summer 201620141001036-TW----1030-1220B154LectureHazra Imran
---R---1030-1220B015LabHazra Imran
--W----0830-1025B032ExamHazra Imran
Spring 201611105001612M-W----0830-1020B154LectureHazra Imran
----F--0830-1020A351LabHazra Imran
-T-----0830-1025B030ExamHazra Imran
Summer 201520290001019-TW----1030-1220B154LectureHengameh Hamavand
---R---1030-1220A219LectureHengameh Hamavand
-T-----0830-1025B154ExamHengameh Hamavand
Summer 20142012500149-TW----1030-1220B022LectureHengameh Hamavand
---R---1030-1220A219LabHengameh Hamavand
-T-----0830-1025B022ExamHengameh Hamavand
Summer 2013201760012N/AM-W----1030-1220B154LectureHengameh Hamavand
---R---1030-1220A219LabHengameh Hamavand
---R---0830-1025B154ExamHengameh Hamavand
Summer 2012202580014N/A-T-R---1030-1220B154LectureHengameh Hamavand
--W----1030-1220L103LabHengameh Hamavand
-T-----0830-1025B018ExamHengameh Hamavand
Summer 2011203880014N/AMT-----1230-1420B154LectureHengameh Hamavand
----F--1230-1420A215LabHengameh Hamavand
----F--0830-1025B153ExamHengameh Hamavand