University Computer Science
Database Systems
Relational database design, data modeling, SQL querying, and the architectural structure of database management systems (DBMS).
Curriculum / Syllabus
- Relational Model and Relational Algebra
- Entity-Relationship (ER) Modeling
- SQL (DDL, DML, Advanced Queries)
- Normalization (1NF, 2NF, 3NF, BCNF)
- Transaction Management and Concurrency Control
- Indexing and Query Optimization
Exam & Course Strategy
Evaluates the ability to write complex SQL queries, translate a given scenario into an ER diagram, and normalize relational database schemas.