Skip to main content

Relational Database Design and SQL COMP 1630

Computer Systems Course

International Fees

International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.

Course details

​This intensive, hands-on course is the prerequisite for follow-on database courses in several BCIT Computing programs. Students are introduced to relational database design concepts and industry standards. COMP 1630 starts with tools and processes for data modeling in Relational Database Management Systems (RDBMS). Labs and exercises take place in a Windows 11 PC environment. There is also a heavy focus on the Structured Query Language (SQL) to define and manipulate data. Topics include functional dependencies, normalization, database design methodologies, entity relationship modeling and the use of UML as a diagramming notation. Advanced topics include: an introduction to SQL, DDL- data definition language and DML- data manipulation language, views, security, transaction management, triggers and stored procedures. Current trends in database such as Replication, Data Warehousing, Online Analytical Processing (OLAP), using databases on the web and in the cloud are discussed. Students in are required to participate in group work, there is significant reading and assignments required outside of class. Online activities via the BCIT Learning Hub are mandatory. COMP 1630 is a required course for the Applied Database Administration and Design (ADAD) Associate Certificate; the Applied Data Analytics Certificate (ADAC) and the Computer Systems Certificate (CSC). It is also equivalent to the Full-time COMP 2714 and ACIT 1630 database courses. Upon successful completion, participants will be able to design and implement a database application and be prepared to move on to higher level database courses including COMP 3678 SQL Server Development; COMP 3679 Business Intelligence (BI) Tools, COMP 3839 Data Quality Improvement, and COMP 4677 Database Administration.​ This course may be eligible for students to receive funding through the StrongerBC Future Skills Grant at www.bcit.ca/financial-aid/strongerbc-future-skills-grant. Students register themselves into the course, then apply for the StrongerBC Future Skills Grant to cover payment, if eligible.

Prerequisite(s)

Credits

5.0

Domestic fees

$725.62 - $766.48 See individual course offerings below for actual costs.

Course offerings

Winter 2024

Below are seven offerings of COMP 1630 for the Winter 2024 term.

CRN 88275

Duration

Wed Jan 10 - Wed Mar 27 (12 weeks)

  • 12 weeks
  • CRN 88275
  • Domestic fees $766.48
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 10 - Mar 27 Wed 18:30 - 21:30 Burnaby SE12 Rm. 320
Jan 10 - Mar 27 N/A N/A Online
Instructor

Ashok Pamu

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$766.48

Important information
  1. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  2. This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status

CRN 74013

Duration

Sat Jan 06 - Sat Mar 23 (12 weeks)

  • 12 weeks
  • CRN 74013
  • Domestic fees $725.62
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 06 - Mar 23 N/A N/A Online
Instructor

Frank Wegener

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$725.62

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  4. This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time Saturday 1000-1100. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, February 03 at 0900; FINAL exam: Saturday, March 23 at 0900. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. Q&A in session February 17 (Family Day).
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

CRN 82098

Duration

Sat Jan 06 - Sat Mar 23 (12 weeks)

  • 12 weeks
  • CRN 82098
  • Domestic fees $725.62
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 06 - Mar 23 N/A N/A Online
Instructor

Frank Wegener

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$725.62

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  4. This course is 5.0 credits and has the workload of two courses. This course section is delivered online asynchronously. There are optional 90-minute interactive Q&A/Review sessions (via Virtual Classroom) each week in real time Saturday 1200-1300. The exams are synchronous and attendance is required on the scheduled dates and times: MIDTERM exam: Saturday, February 03 at 1300; FINAL exam: Saturday, March 23 at 1300. Course is 60 hours. Depending on the student, the typical total time commitment for this course may be a total of 13-15+ hours each week. Late registration is not permitted. Q&A in session February 17 (Family Day). Q&A in session February 17 (Family Day).
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

CRN 88274

Duration

Sat Jan 06 - Sat Mar 23 (12 weeks)

  • 12 weeks
  • CRN 88274
  • Domestic fees $725.62
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 06 - Mar 23 Sat 09:00 - 12:00 Online
Jan 06 - Mar 23 N/A N/A Online
Instructor

Alexander Volkov

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$725.62

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  4. This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted. Class in session February 17 (Family Day).
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

CRN 74021

Duration

Tue Jan 09 - Tue Mar 26 (12 weeks)

  • 12 weeks
  • CRN 74021
  • Domestic fees $725.62
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 26 Tue 18:30 - 21:30 Online
Jan 09 - Mar 26 N/A N/A Online
Instructor

Alexander Volkov

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$725.62

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  4. This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

CRN 74443

Duration

Tue Jan 09 - Tue Mar 26 (12 weeks)

  • 12 weeks
  • CRN 74443
  • Domestic fees $752.73
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 26 Tue 18:30 - 21:30 Downtown DTC Rm. 374
Jan 09 - Mar 26 N/A N/A Online
Instructor

Frederic Guo

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$752.73

Important information
  1. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  2. This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours on campus and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours on campus and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

CRN 89886

Duration

Thu Jan 11 - Thu Mar 28 (12 weeks)

  • 12 weeks
  • CRN 89886
  • Domestic fees $725.62
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 11 - Mar 28 Thu 18:30 - 21:30 Online
Jan 11 - Mar 28 N/A N/A Online
Instructor

Ashok Pamu

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$725.62

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  4. This course is 5.0 credits and has the workload of two courses. Course is 60 contact hours - 36 hours synchronous online classes and 24 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 2 hours per week online asynchronously for 5 contact hours per week. Reading, homework and assignments may require an additional 8-10+ hours per week outside of class. The typical total commitment for this course may be 13 -15+ hours each week. Late registration is not permitted.
Status

Full

This course offering is full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

Learning Outcomes

Upon successful completion of this course, the student will be able to:

  • Describe the database approach, its environment, and database application life cycle.
  • Explain the functions and characteristics of the relational model.
  • Describe and work through the normalization process.
  • Apply UML techniques of database design including:
    • Enhanced entity-relationship modeling using UML
    • Functional dependencies
    • Derivation of relations schema from EER model.
    • Use Crow's foot notation to represent relationship among entities in a database system.
  • Apply database design process to implement a database application.
  • Describe security issues, improve query performance, and data protection techniques in a database environment.
  • Explain the use of databases in data warehousing and OLAP.
  • Use SQL - DDL to implement a relational database.
  • Use SQL for data manipulation with the basic statements: INSERT, UPDATE, DELETE and SELECT.
  • Use SQL for advanced manipulation such as Group BY, Having, Correlated subqueries.
  • Create stored procedures and triggers.
  • Discuss techniques for transaction management and concurrency control.
  • Discuss provisioning a Relational Database Management System (RDBMS) in the Cloud.

Effective as of Fall 2023

Related Programs

Relational Database Design and SQL (COMP 1630) is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Agile Development
    Associate Certificate Part-time
  2. Applied Computer Information Systems (ACIS)
    Associate Certificate Part-time
  3. Applied Data Analytics
    Certificate Part-time
  4. Applied Database Administration and Design
    Associate Certificate Part-time
  5. Applied Web Development
    Associate Certificate Part-time
  6. Computer Systems
    Certificate 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 Relational Database Design and SQL (COMP 1630)? 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.