Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Database Management Systems SWE 207 3 3 + 0 3 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili İngilizce
Dersin Seviyesi Lisans
Dersin Türü Zorunlu
Dersin Koordinatörü Dr.Öğr.Üyesi GÖZDE YOLCU ÖZTEL
Dersi Verenler Dr.Öğr.Üyesi GÖZDE YOLCU ÖZTEL,
Dersin Yardımcıları
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 Learns database management systems Lecture, Question-Answer, Discussion, Testing, Project / Design,
2 Models by using entity relationship diagram Drilland Practice, Discussion, Question-Answer, Project Based Learning, Lecture, Testing, Homework, Project / Design,
3 Learn realtional database Drilland Practice, Discussion, Project Based Learning, Lecture, Project / Design, Homework, Testing,
4 Queries by using SQL Drilland Practice, Discussion, Project Based Learning, Lecture, Project / Design, Homework, Testing,
5 Manages database management systems Lecture, Discussion, Drilland Practice, Project Based Learning, Testing, Project / Design,
Hafta Ders Konuları Ön Hazırlık
1 Introduction, Database Systems
2 Data Models, Entity Relationship Model
3 Entity Relationship Model applications
4 Relational Data Model
5 Extended Entity Relationship Model, Relational algebra
6 Structured Query Language (SQL), DML
7 DDL
8 advanced SQL
9 Midterm Exam
10 advanced SQL
11 SQL Programming
12 Normalization, Performance Tuning
13 Project Presentations
14 Database Security
Kaynaklar
Ders Notu
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.
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.
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.
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
Toplam 0
Toplam 0
AKTS - İş Yükü Etkinlik Sayı Süre (Saat) Toplam İş Yükü (Saat)
Course Duration (Including the exam week: 16x Total course hours) 14 3 42
Hours for off-the-classroom study (Pre-study, practice) 14 1 14
Mid-terms 1 10 10
Assignment 2 8 16
Project / Design 1 23 23
Final examination 1 15 15
Toplam İş Yükü 120
Toplam İş Yükü / 25 (Saat) 4,8
Dersin AKTS Kredisi 5