Skip to main content

Database Systems ACIT 1630

Computer Information Technology 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 and NoSQL database technologies, including basic concepts, relational algebra, enhanced entity-relationship and NoSQL data modeling, functional dependencies and normalization, design methodology, SQL query language (DDL and DML), views, security and transaction management.

Prerequisite(s)

  • No prerequisites are required for this course.

Credits

4.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

Upon successful completion of this course, the student will be able to:

  • Analyze database requirements.
  • Apply database design techniques including:
    • Enhanced Entity Relationship Modeling.
    • Derivation of relation schema from EER models.
    • Modeling for NoSQL databases.
    • Identification of functional dependencies.
    • Table normalization.
  • Create database and database objects using a desktop RDBMS.
  • Use SQL to implement and query a relational database.
  • Identify security issues and propose data protection techniques for databases.
  • Identify and diagnose issues related to transaction management and concurrency control.
  • Use relational algebra operations to solve relational queries.

Effective as of Fall 2020

Related Programs

Database Systems (ACIT 1630) 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 Information Technology
    Diploma Full-time

Subscribe

Interested in being notified about future offerings of Database Systems (ACIT 1630)? 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.