Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS Credits
-1BLP209Database Management Systems2+2+035

 
Course Details
Language of Instruction Turkish
Level of Course Unit Associate Degree
Department / Program Informatics Security Technology
Type of Program Formal Education
Type of Course Unit Elective
Course Delivery Method Face To Face
Objectives of the Course To provide an understanding of relational database management systems. Students will be able to perform analysis, design and implementation processes while developing a relational database management system.
Course Content Data modeling using database, E-R diagrams, conceptual, logical and physical database design, database architectures, SQL: querying, DML, DCL, DDL operations stored procedures/functions and application development fundamentals.
Course Methods and Techniques
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Asist Prof. Turgut PURA turgut.pura@gedik.edu.tr
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources David M. Kroenke(2004). Database Processing: Fundamentals, Design, and Implementation (9th Edition). International edition. Prentice Hall: Upper Saddle River, NJ.
VURAL, Y., & SAĞIROĞLU, Ş. (2010). Veritabanı yönetim sistemleri güvenliği: tehditler ve korunma yöntemleri. Politeknik Dergisi, 13(2), 71-81.
Öğretim elemanı ders notları
Lecture Presentations, Project, Notes, Group Work
Ders Notları
Ödev, Uygulama

Course Category
Mathematics and Basic Sciences %10
Field %90

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 % 30
Assignment 1 % 10
Final examination 1 % 60
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
Assignments 1 10 10
Mid-terms 1 15 15
Final examination 1 20 20
Total Work Load   Number of ECTS Credits 5 129

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 To understand the concept of database management system, its components and its importance in the IT world.
2 To be able to design a conceptual database (ER diagram) including constraints by analyzing a given job description.
3 To be able to convert conceptual database design to logical table design.
4 To be able to make necessary queries and other operations in business processes using SQL.
5 Being able to design and develop a database for a specific job.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Database Introduction Lecture Notes and Internet Research
2 Introduction to SQL Lecture Notes and Internet Research
3 Data Types Lecture Notes and Internet Research
4 Table Creation I Lecture Notes and Internet Research
5 Table Creation II Lecture Notes and Internet Research
6 Relational Database Sample Applications I Lecture Notes and Internet Research
7 Relational Database Sample Applications II Lecture Notes and Internet Research
8 Data Grouping I Lecture Notes and Internet Research
9 Genel Tekrar ve Uygulamalar
10 Data Grouping II Lecture Notes and Internet Research
11 Data Filtering Lecture Notes and Internet Research
12 Table Update Operations Lecture Notes and Internet Research
13 General Review and Application Development Lecture Notes and Internet Research
14 Application Development (continued) Lecture Notes and Internet Research

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

  bbb

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