Türkçe | English
FACULTY of ECONOMICS and ADMINISTRATIVE SCIENCES / DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS

Course Catalog
Web: http://www.ktu.edu.tr/ybs
Phone: +90 0462 0462 377 29 64
İİBF
FACULTY of ECONOMICS and ADMINISTRATIVE SCIENCES / DEPARTMENT of MANAGEMENT INFORMATION SYSTEMS /
Katalog Ana Sayfa
  Katalog Ana Sayfa  KTÜ Ana Sayfa   Katalog Ana Sayfa
 
 

YBS1006Introduction to Database Systems2+1+0ECTS:5
Year / SemesterSpring Semester
Level of CourseFirst Cycle
Status Compulsory
DepartmentDEPARTMENT of MANAGEMENT INFORMATION SYSTEMS
Prerequisites and co-requisitesNone
Mode of Delivery
Contact Hours14 weeks - 2 hours of lectures and 1 hour of practicals per week
LecturerDr. Öğr. Üyesi Mustafa Bilgehan İMAMOĞLU
Co-Lecturer
Language of instructionTurkish
Professional practise ( internship ) None
 
The aim of the course:
In this course, practical applications are included alongside theoretical knowledge related to database systems. The course covers the fundamentals of database systems, the SQL language, the MsSQL database system, and advanced topics related to database systems.
 
Learning OutcomesCTPOTOA
Upon successful completion of the course, the students will be able to :
LO - 1 : Know database systems2,4,61,3,
LO - 2 : Design and create a relational database2,4,61,3,
LO - 3 : With the SQL language, can select data from the database.2,4,6
LO - 4 : To be able to add, delete and update data in the database with SQL language.2,4,61,3,
LO - 5 : Prepare raw data for suitable a database system.2,4,6
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
Database Systems, Relational Database Model, MS SQL Server and SQL Server Management Studio, SQL Language, SQL Data Operations (selecting, inserting, deleting, updating data), SQL Table Operations (creating and modifying tables)
 
Course Syllabus
 WeekSubjectRelated Notes / Files
 Week 1Introduction to Database Systems
 Week 2Basic Concepts
 Week 3Relational Database Model
 Week 4Database Systems and MsSQL
 Week 5SQL(Select)
 Week 6SQL(Insert)
 Week 7SQL(Delete and Update)
 Week 8SQL(select data with conditional statements)
 Week 9Midterm exam
 Week 10SQL(Create table)
 Week 11SQL(Alter table)
 Week 12Open data sources
 Week 13Project (Defining the data and designing the database)
 Week 14Project (Creating database and adding data)
 Week 15Project (Query applications and reporting on database)
 Week 16Final exam
 
Textbook / Material
1Veritabanı Yönetim Sistemleri-1, Ekin Yayınevi, Turgut ÖZSEVEN, 6. Baskı
 
Recommended Reading
 
Method of Assessment
Type of assessmentWeek NoDate

Duration (hours)Weight (%)
Mid-term exam 9 04/2024 1 50
End-of-term exam 16 06/2024 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 1 14 14
Laboratuar çalışması 0 0 0
Arasınav için hazırlık 1 8 8
Arasınav 1 1 1
Uygulama 0 0 0
Klinik Uygulama 0 0 0
Ödev 0 0 0
Proje 0 0 0
Kısa sınav 0 0 0
Dönem sonu sınavı için hazırlık 3 6 18
Dönem sonu sınavı 1 1 1
Diğer 1 0 0 0
Diğer 2 0 0 0
Total work load84