Türkçe | English
FACULTY of SCIENCE / DEPARTMENT of STATISTICS and COMPUTER SCIENCES

Course Catalog
http://www.ktu.edu.tr/isbb
Phone: +90 0462 3773112
FENF
FACULTY of SCIENCE / DEPARTMENT of STATISTICS and COMPUTER SCIENCES /
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

IST3012Database Management Systems4+0+0ECTS:6
Year / SemesterSpring Semester
Level of CourseFirst Cycle
Status Elective
DepartmentDEPARTMENT of STATISTICS and COMPUTER SCIENCES
Prerequisites and co-requisitesNone
Mode of Delivery
Contact Hours14 weeks - 4 hours of lectures per week
LecturerDr. Öğr. Üyesi Uğur ŞEVİK
Co-LecturerDOCTOR LECTURER Tolga BERBER
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
The object of this course is to make students to learn Database Management accompanied by file processing and relational data models, query languages and basic relational operators.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : be able to create the Conceptual Model of the database7,91,4
LO - 2 : be able to create the Logical Model of the database7,91,4
LO - 3 : be able to create the Physical Model of the database7,91,4
LO - 4 : be able to manage data with SQL commands7,91,4
CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome

 
Contents of the Course
Basic Concepts, Purpose of DataBase Organization, Database System Structure, and Data Models: Hyra, Network, query and object oriented database models. Data definition, data processing, query languages, SQL, QBE, QUEL. Database design, logical, conceptual and physical models. Normalization. Database Interface and access methods. Database management, Operational necessity, safety integrity and database applications.
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1Introduction to Database Systems
 Week 2Relational database design
 Week 3Relational algebra
 Week 4Introduction to MS. Access
 Week 5SQL structured query language
 Week 6SQL functions
 Week 7Analysis by grouping the data
 Week 8Multiple tables
 Week 9Mid-term exam
 Week 10Complex queries
 Week 11DML Operations
 Week 12Database objects
 Week 13Introduction to MS SQL
 Week 14Introduction to Ado.Net
 Week 15Csharp applications
 Week 16End-of-term exam
 
Textbook / Material
1Çağıltay N. E., Tokdemir G., 2010, Veritabanı Sistemleri Dersi (Teoriden Pratiğe), Seçkin Yayınları
 
Recommended Reading
1Nizam A., 2015, Veritabanı Teorisi ve Uygulamaları, Papatya Yayıncılık
2Rajiv C., 2016, Database Management System (DBMS): A Practical Approach, 5th Edition, S. Chand Publishing
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 25/04/2022 1 20
Project 15 24/05/2022 30
End-of-term exam 16 29/05/2022 1 50
 
Student Work Load and its Distribution
Type of workDuration (hours pw)

No of weeks / Number of activity

Hours in total per term
Yüz yüze eğitim 3 14 42
Sınıf dışı çalışma 3 14 42
Arasınav için hazırlık 4 1 4
Arasınav 1 1 1
Proje 6 4 24
Dönem sonu sınavı için hazırlık 6 1 6
Dönem sonu sınavı 1 1 1
Total work load120