Program Overview

ITEC210 Database Design

Course Description

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.

Prerequisites

• CPSC 101 or ITEC 150, or permission of Chair

Lecture Hours

• 45

Program Details

Areas of Study

• Business
• Education
• Health & Human Services
• University Arts & Science
• Trades & Apprenticeships
• Upgrading
• Information Technology
• Explore all Programs

Regulations

• Academic Regulations and Policies
• Admissions Regulations
• Graduation Regulations
• Registration Regulations
• Student Financial Support
• Student Records Regulations

Tuition Rates

• Available upon request

Academic Schedule

• Available upon request

Continuing Education

• CE at NLC
• Careers
• Courses
• StrongerBC future skills grant

Admissions

• Applying to NLC
  • Domestic Students
  • International Students
  • Dates & Deadlines
  • Transfer Credits & PLAR
• Course Registration
  • Register for Courses
  • Make a Payment
• Funding Your Education
  • Student Loans & Grants
  • Former Youth in Care

On Campus

• Locations
  • Chetwynd
  • Dawson Creek
  • Tumbler Ridge
  • Fort Nelson
  • Fort St. John
  • Atlin & Dease Lake
  • Industry Training Centres
• Student Services
• Health & Safety
• Explore the North

About Northern Lights College

• Who We Are
• History
• Governance
• Education Council
• Reports

Policies & Admin

• Policies
• Registrar’s Office
• Academic Calendar

Careers

• Careers at NLC
• Living in Northern BC
• Job Postings

Quick Links

• Systems Status
• MyApps
• Dates & Deadlines
• News
• Events
• Library
• Staff

Northern Lights College serves the communities of Northern British Columbia that are located on the territories of the Cree, Dene, Dunne-Za, Kaska, Saulteau, Tse’khene, Tahltan, and Tlingit. We also recognize Metis Nation BC members who live in this area of our beautiful province. We acknowledge our hosts and honour their gracious welcome to those seeking knowledge.