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.
To register, students must contact the program assistant for approval at email@example.com 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
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
COMP 3673 is offered as a part of the following programs:
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 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.