| COURSE DESCRIPTION |
|
The main objective of this
course is to provide students with an in-depth understanding of the
design and implementation of database systems. Topics include overview
of DBMSs, relational data model, integrity constraints, SQL,
normalization, multidimensional and bitmap indexes, query evaluation and
optimization, transaction management, object-relational and
object-oriented data models. Upon successful completion of this course, students will have advanced theoretical and hands-on skills to effectively develop, implement and manage database management systems. Download PDF version of the course syllabus: [PDF] Instructor: Dr. Mustafa Sert, Assistant Professor Assistants: TBA |
| GRADING POLICY (Tentative) |
| Assignments: 20%, Research Paper: 15%, Midterm: 25%, Final: 40% |
| MAIN and RECOMMENDED TEXTs |
| There is no specific text for this course. Class notes, chapters from the reference books and research papers should be used as the primary reference. |
| Recommended Texts: |
|
|
|
|
|
|
|
|
| ASSIGNMENTS |
| Assigned homeworks will be posted here... |
| ... |
| SCHEDULE |
| Week | Topic | Resources |
| 1 | An Overview of Database Management Systems | |
| 2 | Relational DB Model and Integrity Constraints | |
| 3 | Relational Algebra | |
| 4 | Structured Query Language (SQL) | Research paper assignment due |
| 5 | Design Theory for Relational DBs: FDs & Normalization | |
| 6 | Indexing techniques | |
| 7 | Multidimensional and Bitmap Indexes | |
| 8 | Midterm Exam | Subject to change according to Institute regulations |
| 9 | Query Evaluation and Optimization | |
| 10 | Transaction Management | |
| 11 | Object-Relational and Object-Oriented Data Models | |
| 12 | Research paper presentations | |
| 13 | Research paper presentations | |
| 14 | Research paper presentations |