B.C.'s Energy College

Apply Now
top menu Current Students Prospective Students Community Faculty & Staff
ICT 214 - Database Design
Course Details
Course Code:
ICT 214


Calendar Description:
This course provides an introduction to Databases, followed by a review of: entity relationships, normalization modeling, Structured Query Language (SQL); along with a systems analysis from a database perspective. Students will complete a business case project where they will analyze a case with a view to constructing a database. They will also have an opportunity to construct a relational database solution (model only – no coding).

Date First Offered:

Total Hours: 45
Lecture Hours: 45

Total Weeks:

This course is offered online:


Non-Course Pre-Requisites:


Rearticulation Submission:

Course Content:
Database Systems in Organizations
Data Modeling with Entity-Relationship Data Model
Principles of System Analysis
Business Process for Constructing a Database Solution
MS Access, PostgreSQL, and MYSQL

Learning Outcomes:
Upon successful completion of this course the student has reliably demonstrated the ability to:
- Describe the role of database systems in organizations
- Perform data modeling using the entity-relationship data model
- Apply the principles of systems analysis,
- Analyze business process to construct a database solution
- Operate MS ACCESS, PostgreSQL or MYSQL

Grading System:

Passing Grade:
C (60%)

Grading Weight:
Final Exam: 30 %
Quizzes and Tests: 20 %
Assignments: 20 %
Other: 30 %

Percentage of Individual Work:

Course Offered in Other Programs:

Additional Comments:
-Policies and Procedures: Students registered in the Information and Communication Technology Program are guided by the policies and procedures of their registering college. You are encouraged to review the policy definitions and guidelines of the college at which you are registered. You can view these policies and procedures by visiting your college's website or by contacting the Program Coordinator.

-Plagiarism Guidelines: The instructor will advise the student in writing if plagiarism is suspected; a copy of this letter should be sent to the coordinator at the registering college; this should be done in a timely manner. If a student commits plagiarism, the policy of the registering college prevails.

-Attendance: As this is an on-line course, attendance requires participation in the course, not time in a classroom. However, students must ensure that they complete their required participation in online discussions and other similar assignments. Online meeting/discussion forums times may be arranged in conjunction with the students availability.

-The student will not successfully complete the course without passing the final exam and completing at least 50% of scheduled quizzes and tests.
Home   |   About NLC   |   Admissions   |   Programs   |   Services   |   Student Life   |   News & Events   |   Contact Us
Northern Lights Facebook Fan Page Northern Lights Twitter Page Northern Lights YouTube Page