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
Lecturer Yavuz Selim FATİHOĞLU
Research Assistant Seda BALTA
Learning Outcomes of the Course Unit
1) To define the concepts of database management systems.
2) To classify database management systems.
3) To design the Entity Relationship Model (ER) of the database.
4) To apply normalization rules on the database.
5) To apply SQL commands on the database.
6) To design database
7) To define relational algebra operations.
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | ||
| Learning Outcomes | ||||||||||||
| 1 | No relation | No relation | No relation | No relation | No relation | High | High | No relation | No relation | No relation | No relation | |
| 2 | No relation | No relation | No relation | No relation | No relation | High | High | No relation | No relation | No relation | No relation | |
| 3 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 4 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 5 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 6 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | No relation | |
| 7 | No relation | No relation | No relation | No relation | No relation | 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
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
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