School of Computational Arts & Sciences Undergraduate 6 ECTS
CS240 · Databases & Data Modeling
Model real domains in relational databases: schema design, normalization, SQL querying, indexing, and integrity constraints. Includes a mini project with audits and migrations, emphasizing data quality, reproducibility, and reasoning about consistency.
- databases
- sql
- data-modeling
| Overview | Details | Notes |
|---|---|---|
| Code | CS240 | — |
| Title | Databases & Data Modeling | — |
| School | School of Computational Arts & Sciences | — |
| Level | Undergraduate | — |
| Credits | 6 ECTS | — |
What you will learn
- · Design relational schemas with constraints that protect integrity
- · Write non-trivial SQL queries and explain their execution implications
- · Evaluate indexing and normalization trade-offs
Prerequisites
No formal prerequisites (or equivalents are accepted).
Assessment
| Component | Weight |
|---|---|
| Coursework | 60% |
| Final project | 40% |
Weekly outline
Week 1: Week 1
1 topics
- · Relational modeling: entities, relationships, keys
Week 2: Week 2
1 topics
- · SQL essentials: joins, aggregates, and subqueries
Week 3: Week 3
1 topics
- · Integrity: constraints, transactions, and concurrency basics
Week 4: Week 4
1 topics
- · Indexing: when it helps, when it hurts