|
Week - 1 |
Introduction to Databases and Database Management Systems
|
|
Week - 2 |
The Relational Model of Data & Database Design Process |
|
Week - 3 |
The Entity-Relationship (E/R) Model |
|
Week - 4 |
Advanced E/R Concepts |
|
Week - 5 |
From E/R Diagrams to Relational Schema
|
|
Week - 6 |
Schema Refinement - Functional Dependencies |
|
Week - 7 |
Schema Refinement - Normalization & Normal Forms
|
|
Week - 8 |
SQL Basics: Part I |
|
Week - 9 |
SQL Basics: Part II |
|
Week - 10 |
Relational Algebra & Query Optimization |
|
Week - 11 |
More on SQL: View, Trigger, Index, Authorization & Security Design |
|
Week - 12 |
Physical Schema: Storage & File Organization |
|
Week - 13 |
Transactions |
|
Week - 14 |
Term Project Presentations |
Eskisehir Technical University Info Package 
Turkish 
English