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.
Acceptance into the Bachelor of Technology in Computer Systems Degree program.
Below is one offering of this course for the Fall 2020 term.
Tue Sep 15 - Tue Dec 01 12 Weeks
|Sep 15||Tue||18:30 - 22:15||DTC Online Delivery|
|Sep 15 - Dec 01||Online Online Delivery|
|Oct 06||Tue||18:30 - 22:15||DTC Online Delivery|
|Nov 10||Tue||18:30 - 22:15||DTC Online Delivery|
|Dec 01||Tue||18:30 - 22:15||DTC Online Delivery|
Upon successful completion, the student will be able to:
Effective as of Fall 2019
COMP 7071 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
|Database System Concepts, 7Th Ed.|
|Oracle Performance Survival Guide|
|Sql In A Nutshell|
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 7071 - Database Design? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.