Relational Database Design and Indexing
Database models covering ER design, relational mapping, normalization, SQL querying, hashing, file structures, and B+ tree indexes.
SQLDatabase Design
Coursework in database design, covering the full path from modeling to implementation. Built with a teammate, Bora Bedirhan Uyar.
ER modeling
Chen-notation entity-relationship diagrams for four systems: a course registration platform, a festival management system, a ride-sharing service, and an online tutoring platform. Each design works through assumptions, attributes, relationships, cardinalities, and participation constraints.
EER design and logical mapping
Extends the ER models with specialization and generalization, then maps the EER designs into relational schemas with clearly identified primary and foreign keys.
Normalization and relational algebra
Step-by-step normalization to 3NF and BCNF using functional dependencies, plus relational-algebra queries over the course registration schema.
SQL
Oracle SQL practice across two case studies: schema creation, constraints, data loading, filtering, joins, and aggregation.
File structures and indexing
Static hashing with chained overflow, extendible hashing, B+ tree search and deletion, and clustering and secondary indexes.