Skip to main content

Relational Database Systems COMP 2714

Computer Systems Course

Subscribe
View cart
International Fees

International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.

Course details

This course covers relational database technology, including basic concepts, relational algebra, enhanced entity-relationship data modeling, functional dependencies and normalization, design methodology, SQL query language (DDL and DML), views, access control and transaction management. Students design and implement a database application using RDBMS. Also covers some current database trends such as data warehousing and OLAP and use of databases through web technology.

Prerequisite(s)

Credits

5.0

Not offered this term
This course is not offered this term. Please check back next term or subscribe to receive notifications of future course offerings and other opportunities to learn more about this course and related programs.

Learning Outcomes

At the end of this course, the student will be able to:

  • Describe the functions and characteristics of the relational database model.
  • Apply techniques of database design including:
    • Enhanced entity-relationship modeling.
    • Functional dependencies and normalization.
    • Derivation of relations schema from EER models.
  • Apply database design process to design and implement a database application.
  • Use SQL to implement and query a relational database including:
    • Data definition language (DDL) and constraints.
    • Data manipulation language (DML) for data insert, update and delete.
    • Data manipulation language (DML) for data queries, including subqueries and views.
    • Data control language (DCL) for access control.
  • Discuss techniques for transaction management and concurrency control.
  • Describe the use of databases in data warehousing and OLAP.

Effective as of Winter 2010

Related Programs

Relational Database Systems (COMP 2714) is offered as a part of the following programs:

  • Indicates programs accepting international students.
  • Indicates programs with a co-op option.

School of Computing and Academic Studies

  1. Computer Systems Technology
    Diploma Full-time

Contact Us

If you have a question or comment about this course, please complete and submit the form below.

  • Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of Relational Database Systems (COMP 2714)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.

Programs and courses are subject to change without notice.