| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Database Management | BLM208 | Compulsory | Bachelor's degree | 2 | Spring | 3 |
Name of Lecturer(s)
Prof. Dr. Sevinç İLHAN OMURCA
Associate Prof. Dr. Alev MUTLU
Assistant Prof. Dr. Alpaslan Burak İNNER
Assistant Prof. Dr. Süleyman ÖZARSLAN
Assistant Prof. Dr. Hikmetcan ÖZCAN
Learning Outcomes of the Course Unit
1) Explaindatabase and DBMS usage need
2) Apply Entity-Relationship model
3) Compose a relational database system
4) Use SQL query language
5) Develop object oriented databases
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||
| Learning Outcomes | ||||||||||||||||
| 1 | Middle | Middle | No relation | High | No relation | High | Middle | High | High | High | Middle | Low | High | No relation | No relation | |
| 2 | High | Middle | High | Middle | No relation | Middle | Low | Low | No relation | No relation | Middle | No relation | High | High | No relation | |
| 3 | High | Middle | High | Middle | No relation | High | Low | Low | No relation | No relation | Middle | No relation | High | No relation | No relation | |
| 4 | High | High | Middle | Middle | No relation | High | Low | Low | No relation | No relation | Middle | High | High | No relation | No relation | |
| 5 | Middle | High | Middle | Low | No relation | High | Low | Middle | No relation | No relation | Middle | Low | High | No relation | No relation | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Discrete mathematics
Course Contents
Database concepts, functions in database systems. Entity-Relationship Model, The relational model, relational algebra, normalization, SQL query language, Application development using a DBMS, Object-Oriented database.
Weekly Schedule
1) Introduction - Fundemental Concepts2) Entity-Relationship model
3) Implementing Entity-Relationship Model
4) Relational Model - 1
5) Relational model - 2
6) Relational Model -3
7) Relational Algebra
8) Midterm examination/Assessment
9) Introduction to SQL
10) SQL - Database, table operations
11) SQL - SELECT procedures
12) SQL - JOIN Procedures (Inner Join, Left Join, Right Join)
13) Normalization
14) Transaction Processing, Concurrency Control, and Recovery
15) Object-oriented databases
16) Final examination
Recommended or Required Reading
1- Database System Concepts, Avi Silberschatz Henry F. Korth S. Sudarshan McGraw-Hill ISBN 9780078022159
Planned Learning Activities and Teaching Methods
1) Lecture
2) Simulation
3) Case Study
4) Problem Solving
5) Project Based Learning
Assessment Methods and Criteria
Contribution of Midterm Examination to Course Grade |
50% |
|---|---|
Contribution of Final Examination to Course Grade |
50% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required