B.C.'s Energy College


Apply Now
ICT 214 - Database Design
This course will provide a practical foundation of database design and implementation. The course will cover relational modelling, relational design, normalization, functional dependencies, requirements gathering to design a solid database and SQL. The SQL component will introduce the student to inserting, editing, deleting and retrieving data from the database. There will be a strong hands-on component that includes real-world examples and exercises.

Credits: 3

Hours: 45 (Lecture Hours)

Total Weeks: 15

This course is offered online: Yes

Pre-Requisites: NONE

Non-Course Pre-Requisites: NONE

Co-Requisites: NONE

Course Content:
Introduction to Databases, Database Environment
The Relational Model
ER Modeling
Normalization, Functional Dependencies
SQL: Data definition
Creating databases, tables
Constraints, Data integrity, Introducing Scripting
Database Life Cycle
SQL Basics
SQL: Update, Delete, Insert
Views

Learning Outcomes:
Upon successful completion of this course the student has reliably demonstrated the ability to:
- Understanding of the role of database systems in organizations
- Perform data modeling using the entity-relationship data model
- Use the principles of systems analysis, analyze business process to construct a database solution
- Gain hands-on experience with MS Access, MYSQL, or SQL Server
- Apply stochastic methods to model real world situations

Grading System: Letters

Passing Grade:  D (50%)

Textbooks: Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists
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