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.