CPSC 2221: Data Base Systems

« Back to Course Listing

Course Format Lecture 4.0 h + Seminar 0.0 h + Lab. 2.0 h
Credits 3.0

Course Description

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 (New Window)

Check course schedule availability » Check if this course is Transferable » Check Bookstore for required textbooks »

Course Outline