Course Overview
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 Science in Applied Computer Science (BScACS) program.
Credits
3.0
Domestic fees
$885.49
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
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 Applications Development and Optimization (COMP 7071) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Computer Science (Database Option)
Bachelor of Science Full-time/Part-time
- Applied Computer Science (Human Computer Interface Option)
Bachelor of Science Part-time
- Applied Computer Science (Network Security Administration Option)
Bachelor of Science Part-time
- Applied Computer Science (Wireless and Mobile Applications Development Option)
Bachelor of Science Part-time
Course Offerings
Winter 2027
Below is one offering of COMP 7071 for the Winter 2027 term.
CRN 92545
Dates
Jan 04 - Mar 29 Loading
- CRN 92545
- $885.49 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 04 - Mar 29 | Mon | 18:30 - 22:15 | Burnaby SE12 Rm. 306 |
Duration
12 weeks
Instructor
Tejinder Randhawa
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Registration requirements
Departmental approval is required to register for this course offering. You must have approval from the department to register. Students accepted into a program can register directly.
Important information
- No class on February 15 due to statutory holiday - Family Day. 1. Please email compBSc@bcit.ca for departmental approval. Include your full name, student number (A0#), course number (COMP__), and CRN #. 2. This is a BScACS course. BScACS courses are also open to non-bachelor program students, if approval is granted by the BScACS Program Head. 3. BScACS program students have up to seven (7) years to complete the program starting from the date of their first technical degree-level course or the date of acceptance to the BScACS program, whichever comes first.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
No approval yet? Request approval You must have approval from the department to register. Students accepted into a program can register directly.
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.