Academic Catalog

ION503 DATABASE CONCEPTS AND APPLICATIONS

Course Code: 9040503
METU Credit (Theoretical-Laboratory hours/week): 3(3-0)
ECTS Credit: 8.0
Department: Informatics Online
Language of Instruction: English
Level of Study: Graduate
Course Coordinator: Prof.Dr. ÜNAL ERKAN MUMCUOÐLU
Offered Semester: Spring Semesters.

Course Content

Introduction to database concepts: data abstraction/independence. data models (entity-relationship model. object oriented model. relational/network/hierarchical model). database languages (ddl. dml). database administrator/user. Storage and file structures. Indexing and hashing. Relational model: formal query languages (relational algebra. relational calculus). commercial query languages (sql). Relational database design: integrity constraints. data dependencies. normal forms. Transaction processing and concurrency control.