Database Menagement Systems
Information Systems Engineering
Faculty of Technology
First Cycle (Bachelor's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Database Menagement Systems | TBL206 | Compulsory | Bachelor's degree | 2 | Spring | 6 |
Name of Lecturer(s)
Prof. Dr. Halil YİĞİT
Associate Prof. Dr. Serdar SOLAK
Assistant Prof. Dr. Seda BALTA
Assistant Prof. Dr. Samet DİRİ
Lecturer Yavuz Selim FATİHOĞLU
Learning Outcomes of the Course Unit
1) Explains the concepts of database management systems.
2) Designs the Entity Relationship Model (ERM).
3) Applies normalization rules on the database.
4) Designs a relational database.
5) Employes structured query language (SQL) effectively.
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||
| Learning Outcomes | ||||||||||||
| 1 | No relation | High | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 2 | No relation | No relation | High | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 3 | No relation | No relation | High | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 4 | No relation | No relation | High | High | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 5 | No relation | No relation | No relation | No relation | High | No relation | No relation | No relation | No relation | No relation | No relation | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Not Required
Course Contents
Components of database systems, database management system (DBMS) functions, architecture, data independence, data models, conceptual models, object-oriented models and relational data model. Translating conceptual schemas into relational schemas, relational algebra and relational calculation, links, key types, functional dependency, normal forms, multi-valued dependency and database design. In SQL; data definition, relational query, data organization, using SQL in applications and designed database updating. Creating a transaction using SQL, efficiency characteristics, revealing possibilities, reliability levels, concurrencies, errors and their solutions, protection levels, distributed data storage, distributed data processing, distributed transaction model, concurrent control, homogeneous and heterogeneous solutions. File structures, index files, complex (hash) files, signature files, binary tree, multi-index files, variable compatibility registered files.
Weekly Schedule
1) Database Systems Basics2) Data models, Entity-Relationship Model
3) Entity-Relationship Model Applications
4) Entity-Relationship Model Applications
5) Normalization, Performance Improvement
6) Structured Query Language (SQL), DDL, DML and DCL
7) Structured Query Language (SQL), DML (Select, Insert,Update, Delete)
8) midterm exam
9) DML (Select, Insert,Update, Delete) where, distinct, sum vb. subqueries
10) Relational Algebra Operations
11) Advanced SQL operations
12) Advanced SQL operations
13) Database design applications
14) Database design applications
15) Database creation with SQL commands
16) Final exam
Recommended or Required Reading
1- VERİ TABANI SİSTEMLERİ - Prof. Dr. Ünal YARIMAĞAN
Planned Learning Activities and Teaching Methods
1) Lecture
2) Question-Answer
3) Demonstration
4) Group Study
5) Problem Solving
6) Project Based Learning
Assessment Methods and Criteria
Contribution of Semester Studies to Course Grade |
65% |
||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||
Contribution of Final Examination to Course Grade |
35% |
||||||||||||||
Total | 100% | ||||||||||||||
Language of Instruction
Turkish
Work Placement(s)
Not Required