Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Database Management Systems BSM 211 3 3 + 0 3 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü Zorunlu
Dersin Koordinatörü Prof.Dr. CELAL ÇEKEN
Dersi Verenler Prof.Dr. CELAL ÇEKEN, Dr.Öğr.Üyesi İSMAİL ÖZTEL,
Dersin Yardımcıları

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

Dersin Kategorisi Diğer
Dersin Amacı

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

Dersin İçeriği

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

# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
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,
Hafta Ders Konuları Ön Hazırlık
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
Kaynaklar
Ders Notu

1. https://github.com/celalceken/DatabaseManagementSystems

Ders Kaynakları

1. Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation, and Management, Cengage Learning.
2. http://www.postgresql.org/docs/manuals/
3. https://www.valentina-db.com/en/valentina-studio-overview
4. https://www.lucidchart.com/

Sıra Program Çıktıları Katkı Düzeyi
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.
13
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 50
1. Ödev 10
2. Ödev 10
1. Proje / Tasarım 30
Toplam 100
1. Yıl İçinin Başarıya 55
1. Final 45
Toplam 100
AKTS - İş Yükü Etkinlik Sayı Süre (Saat) Toplam İş Yükü (Saat)
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
Toplam İş Yükü 126
Toplam İş Yükü / 25 (Saat) 5,04
Dersin AKTS Kredisi 5