Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
Ö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 Dr.Öğr.Üyesi VEYSEL HARUN ŞAHİN
Dersin Yardımcıları

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

Dersin Kategorisi
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

Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 - Introduces database management systems 1 - 2 - 3 - A -
2 - Models any database using entity-relationship diagrams. 1 - 2 - 3 - 4 - A - C -
3 - Introduces Relational Database Model 1 - 3 - 4 - 16 - A - C - D -
4 - Queries database using SQL 1 - 4 - 6 - A - C - D -
5 - Enhances database design 1 - 2 - 4 - A - C - D -
6 - Designes and manages databases 1 - 2 - 4 - A - C - D -
7 - Introduces various database management systems 1 - 2 - 4 - A - C - D -
Öğretim Yöntemleri: 1:Lecture 2:Question-Answer 3:Discussion 4:Drilland Practice 16:Project Based Learning 6:Motivations to Show
Ölçme Yöntemleri: A:Testing C:Homework D:Project / Design

Ders Akışı

Hafta Konular ÖnHazı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


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/

Döküman Paylaşımı


Dersin Program Çıktılarına Katkısı

No Program Öğrenme Çı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, X
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, X
10 Understanding, practicing of professional and ethical responsibilities, an ability to disseminate this responsibility on society, X
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. X

Değerlendirme Sistemi

AraSinav 1 50
Odev 1 15
Odev 2 15
ProjeTasarim 1 20
Toplam 100
Yıliçinin Başarıya Oranı 55
Finalin Başarıya Oranı 45
Toplam 100

AKTS - İş Yükü

Etkinlik Sayısı Süresi(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(s) 5.04
Dersin AKTS Kredisi 5.04
; ;