TR EN

DATABASE MANAGEMENT COURSE IDENTIFICATION AND APPLICATION INFORMATION

Code Name of the Course Unit Semester In-Class Hours (T+P) Credit ECTS Credit
BIL309 DATABASE MANAGEMENT 5 4 3 6

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY

Week Preparatory Topics(Subjects) Method
1 - Importance of data, data management, and data management systems -
2 - Defining the problem and gathering data -
3 - Introduction to relational databases -
4 - Relational database management systems -
5 - Data Models -
6 - Entity - Relationship Diagrams -
7 - Data Modeling and Normalization -
8 - MID-TERM EXAM -
9 - SQL: Data Definition Language -
10 - Simple SQL queries -
11 - Built-in SQL functions -
12 - Complex SQL queries -
13 - Triggers -
14 - Indexes and how to use them -
15 - Other data models: XML, Text, and multimedia -
16 - FINAL EXAM -
17 - FINAL EXAM -