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: |
|
| 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.
