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 8 programs:
- ACS 4-YEAR BA IN APPLIED COMPUTER SCIENCE
- ACS 3-YEAR BA/BSc IN APPLIED COMPUTER SCIENCE
- ACS 3-YEAR BA/BSc (INFORMATION SYSTEMS STREAM)
- ACS 3-YEAR BA/BSc (HEALTH INFORMATICS STREAM)
- 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)
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 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.
From the 2026-27 undergraduate calendar. Always verify details on WebAdvisor or with an academic advisor before registering.