ACS-28143 credit hours

Applications of Database Systems

Applied Computer Science · 3 hrs Lecture | 1 hrs Lab

Offered: Fall and Winter Both, Every Year

ACS-2814 prerequisites

Taking ACS-2814 is a prerequisite for 7 courses directly, and opens 11 once their own follow-ons are counted.

Where ACS-2814 counts

Required by 4 programs:

  • ACS 3-YEAR BA/BSc IN APPLIED COMPUTER SCIENCE
  • ACS 4-YEAR BSc IN APPLIED COMPUTER SCIENCE
  • ACS BSc (HONOURS) IN
  • STAT 4-YEAR BA/BSc IN STATISTICS

Read from the departments' own calendar pages, where 71 of 141 programs are only partly machine-readable, so treat these as a minimum rather than the full list. Confirm with an academic advisor.

Description

This course introduces students with limited computing experience to the principles of data management. The emphasis is on practical database experience reinforced through assignments and weekly laboratory work. Students learn first to work with a workstation-based database system and subsequently they are introduced to the design of databases and their implementation in relational systems. Topics include tables, queries, forms, reports, importing and exporting data, structured query language, entity relationship models, the relational data model, and normalization of databases. Examples, assignments, and laboratory work are drawn from a variety of different disciplines.

Requisite courses

ACS-2814L (lab) (must be taken concurrently).

Restrictions

Students may not hold credit for this course and ACS-2914.

LectureLab

From the 2026-27 undergraduate calendar. Always verify details on WebAdvisor or with an academic advisor before registering.