Course Name Code Semester T+U Hours Credit ECTS
Database Management Systems BSM 211 3 3 + 0 3 5
Precondition Courses
Recommended Optional Courses
Course Language Turkish
Course Level Bachelor's Degree
Course Type Compulsory
Course Coordinator Prof.Dr. CELAL ÇEKEN
Course Lecturers Prof.Dr. CELAL ÇEKEN, Dr.Öğr.Üyesi İSMAİL ÖZTEL,
Course Assistants

Res.Asst.Erman Özer - Res.Asst. İsmail Öztel

Course Category
Course Objective

In this information age, data management is a core activity for any organization. Accurate, relevant, and timely information is the key to good decision making and good decision making is the key to organizational survival. The main goal of this course is to teach the students how database management systems can be designed and managed

Course Content

Database Systems, Data Models, Entity Relationship Model, Relational Database Model, Extended Entity Relationship Model, Relational Algebra, Structured Query Language (SQL), Advanced SQL, Normalization and Performance Tuning, SQL Programming, Database Security, Other Database Models

# Course Learning Outcomes Teaching Methods Assessment Methods
1 Introduces database management systems Lecture, Question-Answer, Discussion, Testing,
2 Models any database using entity-relationship diagrams. Lecture, Question-Answer, Discussion, Drilland Practice, Testing, Homework,
3 Introduces Relational Database Model Lecture, Discussion, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
4 Queries database using SQL Lecture, Drilland Practice, Motivations to Show, Testing, Homework, Project / Design,
5 Enhances database design Lecture, Question-Answer, Drilland Practice, Testing, Homework, Project / Design,
6 Designes and manages databases Lecture, Question-Answer, Drilland Practice, Testing, Homework, Project / Design,
7 Introduces various database management systems Lecture, Question-Answer, Project / Design,
Week Course Topics Preliminary Preparation
1 Introduction, Database Systems
2 Data Models, Entity Relationship Model
3 Entity Relationship Model Examples
4 Relational Database Model
5 Extended Entity Relationship Model
6 Relational Algebra
7 Structured Query Language (SQL)
8 Advanced SQL
9 Visa Exam
10 Normalization and Performance Tuning
11 SQL Programming
12 SQL Programming
13 Database Security, Other Database Models
14 Project Study
Course Notes <p> 1.&nbsp;</p>
Course Resources

1. Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation, and Management, Cengage Learning.

Order Program Outcomes Level of Contribution
1 2 3 4 5
1 To have sufficient foundations on engineering subjects such as science and discrete mathematics, probability/statistics; an ability to use theoretical and applied knowledge of these subjects together for engineering solutions, X
2 An ability to determine, describe, formulate and solve engineering problems; for this purpose, an ability to select and apply proper analytic and modeling methods,al background in describing, formulating, modeling and analyzing the engineering problem, with a consideration for appropriate analytical solutions in all necessary situations X
3 An ability to select and use modern techniques and tools for engineering applications; an ability to use information technologies efficiently, X
4 An ability to analyze a system, a component or a process and design a system under real limits to meet desired needs; in this direction, an ability to apply modern design methods, X
5 An ability to design, conduct experiment, collect data, analyze and comment on the results and consciousness of becoming a volunteer on research, X
6 Understanding, awareness of administration, control, development and security/reliability issues about information technologies, X
7 An ability to work efficiently in multidisciplinary teams, self confidence to take responsibility, X
8 An ability to present himself/herself or a problem with oral/written techniques and have efficient communication skills; know at least one extra language,
9 An awareness about importance of lifelong learning; an ability to update his/her knowledge continuously by means of following advances in science and technology,
10 Understanding, practicing of professional and ethical responsibilities, an ability to disseminate this responsibility on society,
11 An understanding of project management, workplace applications, health issues of laborers, environment and job safety; an awareness about legal consequences of engineering applications,
12 An understanding universal and local effects of engineering solutions; awareness of entrepreneurial and innovation and to have knowledge about contemporary problems.
Evaluation System
Semester Studies Contribution Rate
1. Ara Sınav 50
1. Ödev 10
2. Ödev 10
1. Proje / Tasarım 30
Total 100
1. Yıl İçinin Başarıya 55
1. Final 45
Total 100
ECTS - Workload Activity Quantity Time (Hours) Total Workload (Hours)
Course Duration (Including the exam week: 16x Total course hours) 16 4 64
Hours for off-the-classroom study (Pre-study, practice) 16 1 16
Mid-terms 1 15 15
Assignment 2 8 16
Final examination 1 15 15
Total Workload 126
Total Workload / 25 (Hours) 5.04
dersAKTSKredisi 5