British Columbia Institute of Technologywww.bcit.ca/study/courses/comp3673

BCIT

COMP 3673 - Computer Systems Technology Foundations 3

Computer Systems Part-time Studies Course

School of Computing and Academic Studies

Course Details

COMP 3673 is an intensive course intended for applicants to the Bachelor of Technology degree in Computer Systems. The primary focus of this course is systems analysis, design and implementation in a relational database environment. The course introduces the students to concepts and techniques used in project development lifecycles which include: (1) gathering user requirements, (2) ascertaining feasibility and practicality of projects, planning, and (3) managing and monitoring projects. These will serve as foundation to more in depth understanding of database design, modeling, implementation and maintenance. Topics to be covered will include: 1)Basic Relational Database Design concepts (Use case and use case considerations, Relational Schemas, Relational algebra, Entity (ER) and Enhanced Entity Relationship (EER) modeling, & Normalization); 2)Structured Query Language (Data Definition Language (DDL), & Data Manipulation Language (DML)); and 3)Database Maintenance (Use of views, Database security, & Concurrency Control and Transaction Management). Students will be required to use Relational Database Management Systems, such as MS SQL Server or MySQL, to complete the assignments and project.

Prerequisite(s)

COMP 2653 or COMP 3653

Credits

9.0

Cost

$1,060.00

Spring/Summer 2019

Below is one offering of this course for the Spring/Summer 2019 term.

CRN 55061

Mon Apr 08 - Mon Jun 24 12 Weeks

Class Meeting Times

Dates Days Times Locations
Apr 08 - Jun 24 Distance

Instructor

Donabel Santos

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$1,060.00

Notes

  1. Departmental approval needed
  2. To register, students must contact the program assistant for approval at cstbtech@bcit.ca with your student ID. This foundation course is primarily for advanced students looking for pre-entry into the Computer Systems Technology, Bachelor of Technology program. The course is very intense and students are advised to not take any other courses at the same time. Students must have internet access to communicate with the instructor. Be sure your email address is current by updating your personal information at my.bcit.ca/cp/home/loginf

Learning Outcomes

Upon successful completion, the student will be able to:

  • Explain systems development lifecycles.
  • Use techniques learned in class to gather user requirements, prepare feasibility studies, plan, design, implement, manage and monitor systems projects.
  • Describe the functions and characteristics of the relational database model.
  • Create project design documents and make recommendations to stakeholders based on a given business case.
  • Use relational algebra operations to solve relational queries.
  • Apply techniques of database design including:
    • Enhanced entity-relationship modeling.
    • Functional dependencies and normalization.
    • Derivation of relations schema from EER models.
  • Apply database design techniques to implement a relational database application using SQL on a desktop RDBMS.
  • Describe common considerations, security issues and data protection techniques in a database environment.
  • Discuss implications of transaction management and concurrency controls in a relational database environment.

Effective as of Fall 2003

Related Programs

COMP 3673 is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Computer Systems Foundations
    Part-time   Associate Certificate

Contact Us

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

Contact Information

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

Subscribe

Interested in being notified about future offerings of COMP 3673 - Computer Systems Technology Foundations 3? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

Contact Information

Suggest course days and times

If you are interested in taking this course on-campus (classroom delivery only) and would like to see it offered on specific days and/or at specific times, please indicate your preferences below. Day and time suggestions are not applicable to online courses.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

Programs and courses are subject to change without notice.

Find Courses

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is now open for the Spring/Summer 2019 term.

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at BCIT part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid ›

© BCIT