Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
4YBS244Database Management Systems3+2+04617.04.2026

 
Course Details
Language of Instruction Turkish
Level of Course Unit Bachelor's Degree
Department / Program Management Information Systems
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course The aim of this course is to teach students the basic concepts and technologies related to databases and to provide them with the knowledge and skills to design, implement and manage database systems.
Course Content The database management systems course will teach students the fundamentals of databases and provide an in-depth understanding of the relational data model, SQL queries, database design and management. This course teaches students how database systems work, how databases are created, updated and queried, while also addressing important issues such as data integrity, security and performance optimization.
Students will develop their database management skills by practicing with examples based on real-world scenarios. In addition, this course will partly follow Project Based Learning (PBL). Each student will do a project on a different topic. Students will be assigned projects from a project list. Projects will be done alone.
Course Methods and Techniques Lecture Method, 3. Problem-Solving Method, 5. Project-Based Learning Model, 7. Individual Study Method, 8. Question-and-Answer Technique
Prerequisites and co-requisities None
Course Coordinator Asist Prof. Halime Suvay Eker
Name of Lecturers Asist Prof. HALİME SUVAY EKER
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Post, G. V. (2009). Database management systems. PHI Learning Pvt. Limited.
Codd, E. F. (1990). The relational model for database management: version 2. Addison-Wesley Longman Publishing Co., Inc..
https://www.w3schools.com/sql/default.asp
https://books.google.com.tr/books?hl=tr&lr=&id=pDUREQAAQBAJ&oi=fnd&pg=PA1&dq=SQL+kitap&ots=65eIzMJhzJ&sig=o9MiHvMm0sSQLnQbInOrLX2N1WU&redir_esc=y#v=onepage&q=SQL%20kitap&f=false
https://learn.microsoft.com/en-us/ssms/install/install
Course Notes Özseven, T. (2012). Veri tabanı yönetim sistemleri-2. Murathan Yayınevi.
Assignments Bir grup projesi
Exams Vize ve Final Sınavları

Course Category
Mathematics and Basic Sciences %0
Engineering %10
Engineering Design %10
Social Sciences %0
Education %0
Science %0
Health %0
Field %80

Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Project 1 % 15
Final examination 1 % 45
Total
3
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 3 42
Hours for off-the-c.r.stud 14 3 42
Mid-terms 1 20 20
Project 1 20 20
Final examination 1 30 30
Total Work Load   Number of ECTS Credits 6 154

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Students will be able to explain the concepts of data, information, knowledge and database.
2 They can apply DML operations in database management.
3 They can perform DDL operations in database management.
4 Students will be able to perform Order By and Group By operations in SQL query language.
5 They can set up and manage relational and non-relational database models.
6 They can write subqueries in the SQL query language.
7 Students can use Views in SQL.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Syllabus discussion, concepts of data, information and knowledge
2 Creating, deleting and updating databases (create, alter, drop operations) Identification of Projects
3 Creating, deleting and updating databases (Create, Alter, Drop operations)
4 Basic SQL queries (Select, Where)
5 Basic SQL queries (Insert, Update, Del
6 Data Grouping Operations (Group By: Avg, Sum)
7 Subject Review Review of Projects
8 Data Grouping Operations (Group By: Count, Min, Max)
9 Data Sorting Operations (Order By: Asc, Desc)
10 Linking Tables (JOIN Rules: Inner, Left Outer, Right Outer, Full Outer)
11 Linking Tables (JOIN Rules: Inner, Left Outer, Right Outer, Full Outer)
12 Subqueries
13 Views
14 Project Delivery

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8
All 3 5 4 1 3 1 3 1
C1 5 2 1 1 4 1 1 1
C2 2 5 5 1 3 1 3 1
C3 2 5 5 1 3 1 3 1
C4 2 5 5 1 3 1 2 1
C5 2 5 5 1 3 1 4 1
C6 3 5 5 1 3 1 2 1
C7 2 5 5 1 3 1 4 1

  bbb

  
  https://obs.gedik.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=265073&curProgID=5702&lang=en