Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems ISE 305 5 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Compulsory
Course Coordinator Arş.Gör.Dr. MUHAMMED KOTAN
Course Lecturers Arş.Gör.Dr. MUHAMMED KOTAN,
Course Assistants
Course Category
Course Objective As computers becoming indispensable parts of our lives, data and databases gathers more importance everyday. The main goal of the course is to teach the basics of database(data storage), how to use, design and make sample applications.
Course Content Definitions and basic concepts, entity-relation model, Relational Data Model, Relational Algebra and Calculation, Structural Query Language, Functional dependence and normalization, Transaction Management, Synchronism Control, Database Recovery, Database Security, Object Oriented Database, Database Programming and Internet Applications, Data Warehouse and Data Mining
# Course Learning Outcomes Teaching Methods Assessment Methods
1 Recognizes database management systems Lecture, Drilland Practice, Role Playing, Testing, Homework,
2 Makes the models of database with entity-relation diagrams. Lecture, Drilland Practice, Role Playing, Project Based Learning, Testing, Homework,
3 Query databases with SQL Lecture, Question-Answer, Drilland Practice, Project Based Learning, Testing, Homework,
4 Understands database normalization steps Lecture, Drilland Practice, Role Playing, Project Based Learning, Testing, Project / Design,
Week Course Topics Preliminary Preparation
1 Introduction to Database Management Systems
2 Entity-relation model
3 Relational Data Model
4 Relational Algebra and Calculation
5 SQL
6 SQL
7 SQL
8 Normalization
9 Database Management System
10 Database Management System
11 Database Management System
12 Web Database Applications
13 Web Database Applications
14 Web Database Applications
Resources
Course Notes Ramakrishnan . Gehrke,Database Management Systems, Third Edition, McGraw-Hill,2003.
Course Resources 1.Yarımağan, Ü.,Veritabanı Sistemleri, Ankara, 2000.
2. C. J. Date, "An Introduction to Database Systems", Eight Edition, Addison-Wesley, 2004.
Order Program Outcomes Level of Contribution
1 2 3 4 5
1 X
2 X
3 X
4 X
5 X
6
7 X
8
9 X
10
11
12
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Kısa Sınav 20
1. Ödev 15
2. Ödev 15
Total 100
1. Yıl İçinin Başarıya 40
1. Final 60
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 4 64
Mid-terms 1 5 5
Quiz 1 5 5
Assignment 2 5 10
Final examination 1 15 15
Total Workload 147
Total Workload / 25 (Hours) 5.88
dersAKTSKredisi 5