Course Details

Return to Classes
Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
4COMP210DATABESE MANAGEMENT SYSTEMS3+0+03515.05.2026

 
Course Details
Language of Instruction English
Level of Course Unit Bachelor's Degree
Department / Program COMPUTER ENGINEERING
Type of Program Formal Education
Type of Course Unit Compulsory
Course Delivery Method Face To Face
Objectives of the Course The main objective of this course is to provide students with the skills to design normalized databases, manipulate databases using a database management system, and develop database-driven web applications. Through this course, students will develop a comprehensive understanding of database systems and technologies, while gaining the ability to translate the theoretical knowledge they have learned into practical applications.
Course Content This course provides a comprehensive overview of design and implementation of relational databases with web access for database-driven Web applications. The course aims to teach the essentials and applications of relational database management systems. The students will learn about database management systems (such as MySQL), database administration, and database querying with SQL. The students will also learn how to use databases to construct applications. Relational data modeling, relational algebra and structured query language (SQL) are indispensable components of this course. Then, relational database design and entity-relationship model will be discussed. Later, design for database-driven Web applications will be explained. Later on, data storage medium and formats for databases will be explained. Finally, database transactions will be explained.
Course Methods and Techniques Essentials of database and application design will be taught by giving brief theoretical explanations followed by writing working SQL commands and programs using them in class. First, the instructor will explain the topic using presentations. Then, the instructor will solve some simple exercises using MySQL in-class sessions.
Prerequisites and co-requisities ( COMP112 or COMP114 )
Course Coordinator Asist Prof.Dr. Mehmet Gökhan Bakal gokhan.bakal@agu.edu.tr
Name of Lecturers Asist Prof.Dr. Mehmet Gökhan Bakal gokhan.bakal@agu.edu.tr
Research Assist.Dr. Fatma Çelebi fatma.celebi@agu.edu.tr
Research Assist.Dr. Hilal Hacılar hilal.hacilar@agu.edu.tr
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Relevant Video Reources
Course Notes “Database System Concepts,” Silberschatz, A., Korth, H., F., Sudarshan, S., 7th Edition, McGraw-Hill, 2019, “https://www.db-book.com/db7/”
Documents https://www.db-book.com/db7/
Exams Vize ve Final

Course Category
Mathematics and Basic Sciences %20
Engineering %30
Engineering Design %50
Social Sciences %0
Education %0
Science %0
Health %0
Field %0

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
Yarıl yılSonu Sınavı/Dönem Projesinin Başarı Notuna Katkısı 1 % 25
Ödev 4 % 25
Proje/Çizim 1 % 25
Final examination 1 % 25
Total
7
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Yazılı Sınav 1 2 2
Grup Projesi 1 52 52
Ev Ödevi 4 8 32
Sınıf İçi Aktivitesi 12 1 12
Proje 1 52 52
Yüz Yüze Ders 28 1 28
Final Sınavı 1 2 2
Total Work Load   Number of ECTS Credits 6 180

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Design normalized databases.
2 Use a database management system to manipulate a database.
3 Develop database-driven applications.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Intro to DBMS
2 Introduction to the Relational Models
3 Introduction to SQL and Basic Level SQL
4 Introduction to SQL (cont’d) and Intermediate SQL
5 Intermediate SQL (cont’d) and Advanced SQL
6 Database Design and the E-R Model
7 Relational Database Design
8 Relational Database Design (cont’d) and Application Design
9 Normalization Concept
10 Normalization (cont'd) and Complex Data Types
11 Complex Data Types (cont'd) and Transaction Management
12 Transaction Management (cont'd) and DBMS New Trends
13 DBMS New Trends (cont'd)
14 Overall Semester Recap

 
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 P13 P14 P15
All 4 4 4 5 4 2 2 2 2 2 5 3 5 5 4
C1 2 3 4 5 4 3 2 2 2 2 4 3 5 5 4
C2 4 4 4 4 3 2 2 2 2 2 5 3 5 5 4
C3 5 5 5 5 5 2 2 2 2 2 5 4 5 4 5

  Contribution: 1: Very Slight 2:Slight 3:Moderate 4:Significant 5:Very Significant

  
  https://sis.agu.edu.tr/oibs/bologna/progCourseDetails.aspx?curCourse=78783&lang=en
Return to Classes