CS 3200 — Introduction to Databases
4 semester hoursUndergraduateLectureNUpath ADusually offered: fall, spring, summertypical days: M/W/ThBostonOakland, CAOnlineOnlineTraditional
Studies the design of a database for use in a relational database management system. The entity-relationship model and normalization are used in problems. Relational algebra and then the SQL (structured query language) are presented. Advanced topics include triggers, stored procedures, indexing, elementary query optimization, and fundamentals of concurrency and recovery. Students implement a database schema and short application programs on one or more commercial relational database management systems.
Prerequisites
- one of:
Offering history
| Term | Sections | Enrolled | Capacity | Full | Open seats/section |
|---|---|---|---|---|---|
| Fall 2023 | 3 | 495 | 490 | 101% | 0.0 |
| Spring 2024 | 4 | 386 | 451 | 86% | 16.3 |
| Summer B 2024 | 2 | 108 | 229 | 47% | 60.5 |
| Fall 2024 | 4 | 488 | 516 | 95% | 7.0 |
| Spring 2025 | 7 | 527 | 573 | 92% | 6.6 |
| Summer A 2025 | 2 | 159 | 179 | 89% | 10.0 |
| Summer B 2025 | 2 | 116 | 249 | 47% | 66.5 |
| Fall 2025 | 3 | 377 | 411 | 92% | 11.3 |
| Spring 2026 | 4 | 364 | 420 | 87% | 14.0 |
Snapshots from scheduled scrapes — not live seat availability. "Full" can exceed 100% when sections over-enroll.
Meeting times
Share of recent sections by weekday: M 60% · T 42% · W 53% · Th 62% · F 31%
Common patterns: MWR (44% of sections), TF (30% of sections), MTWR (8% of sections), MR (8% of sections), async (5% of sections), T (2% of sections) — in patterns, R means Thursday
Professors
Fall
- Mark Fontenot (41% of students) · reviews
- John Rachlin (34% of students) · reviews
- Carter Ithier (17% of students) · reviews
- Kathleen Durant (8% of students) · reviews
Spring
- Mark Fontenot (45% of students) · reviews
- John Rachlin (17% of students) · reviews
- Wolfgang Gatterbauer (9% of students) · reviews
- Kathleen Durant (9% of students) · reviews
Summer A
- Martin Schedlbauer (100% of students) · reviews
Summer B
- Mark Fontenot (62% of students) · reviews
- Martin Schedlbauer (38% of students) · reviews
Percentages are each professor's average share of the season's enrolled students in recent terms.
Unlocks
Courses that list CS 3200 in their prerequisites.
Links
Official catalog (CS course descriptions) · Student reviews on RateMyHusky · All CS courses · Plan it at numap.app