Skip to main content

Database Design COMP 7071

Computer Systems Part-time Studies Course

Course details

​This course offers an in-depth study of Database System Concepts and Architectures including, query processing, query optimization, transaction processing, concurrency control, recovery, parallel databases, distributed databases and access control. Design of storage and file structures including different indexing and hashing organizations are also discussed. ACID (Atomicity, Consistency, Isolation and Durability) property and non-ACID complied database are discussed. Various database languages are discussed including Data Definition Language (DDL) and Data Manipulation Language (DML). Comparative analysis with alternative data models and database systems is conducted. Assignments will reinforce learning through designing and constructing a database from conceptual, to logical model to final physical deployment.

Prerequisite(s)

  • Acceptance into the Bachelor of Technology in Computer Systems Degree program.

Credits

3.0

Cost

$790.22

Course offerings

Fall 2022

Below is one offering of COMP 7071 for the Fall 2022 term.

CRN 31385

Duration

Tue Sep 13 - Tue Nov 29 (12 weeks)

  • 12 weeks
  • CRN 31385
  • $790.22
Class meeting times
Dates Days Times Locations
Sep 13 - Nov 29 Tue 18:30 - 22:15 Downtown DTC Rm. 678
Instructor

Tejinder Randhawa

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$790.22

Important information
  1. Departmental approval needed
  2. 1. Please email cstbtech@bcit.ca for departmental approval. Include your student number (A0#), course number (COMP__) and preferred CRN. 2. This is a CST BTech course. CST BTech courses are also open to non-bachelor program students. 3. CST Bachelor program students have up to seven (7) years to complete the Bachelor program starting from the date of their first Technical degree-level course or the date of acceptance to the Bachelor program, WHICHEVER COMES FIRST.
Status

Learning Outcomes

Upon successful completion, the student will be able to:

  • Design effective relational data models and database deployment architectures based on the storage requirements of an application.
  • Facilitate data storage and access by designing suitable SQL statements.
  • Evaluate efficiency of non-relational data models such as extended-relational, object-oriented and JSON/XML in addressing the data storage needs in comparison to relational database systems.
  • Develop storage structures suitable for temporal and spatial data.
  • Use indexes, RAID, query optimizers, and apply schemes such as data partitioning to ensure that data retrieval meets the performance requirements.
  • Use indexes, RAID, query optimizers, and apply schemes such as data partitioning to ensure that data retrieval meets the performance requirements.
  • Apply integrity constraints and other functional dependencies to ensure data integrity.
  • Utilize recovery logs and implement RAID and replicated database architectures for recovery and fault tolerance.
  • Develop native, web and mobile apps that integrate with the database systems to evaluate effectuality of the underlying database in addressing the OLTP requirements.

Effective as of Fall 2019

Related Programs

Database Design (COMP 7071) is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Computer Systems (Database Option)
    Bachelor of Technology Part-time
  2. Computer Systems (Human Computer Interface Option)
    Bachelor of Technology Part-time
  3. Computer Systems (Network Security Administration Option)
    Bachelor of Technology Part-time
  4. Computer Systems (Network Security Applications Development Option)
    Bachelor of Technology Part-time
  5. Computer Systems (Wireless and Mobile Applications Development Option)
    Bachelor of Technology Part-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 Database Design (COMP 7071)? 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.