ACS-39023 credit hours

Database Systems

Applied Computer Science · 3 hrs Lecture

Offered: Fall and Winter Both, Every Year

ACS-3902 prerequisites

2 courses appear in this chain, up to 1 level deep. Every route through it involves a choice, so nothing is forced.

Show the chain

any one of

ACS-2814Applications of Database Systemsmin C
ACS-2914not in the 2026-27 calendarmin C

Add your completed courses to see which of these you've already done and what you could take next. They stay on this device.

Taking ACS-3902 is a prerequisite for 5 courses directly.

Where ACS-3902 counts

Required by 6 programs:

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

Counts toward 2 more as one option among several, not as a course you must take:

  • ACS 3-YEAR BA/BSc (INFORMATION SYSTEMS STREAM)
  • ACS 3-YEAR BA/BSc (HEALTH INFORMATICS STREAM)

Read from the departments' own calendar pages, where 50 of 208 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 the theory of relational, network, and hierarchical models. It covers in detail the techniques utilized in various stages of a relational database software development life cycle. These techniques include ERDs, relational models, functional dependencies, normalization, and physical data storage mechanisms. Query language fundamentals including relational algebra and SQL are also covered. A project involving the design and implementation of a database is required.

Requisite courses

ACS-2814 (or the former ACS-2914) with a minimum grade of C [prerequisite(s)].

Lecture

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