Yazdır

Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
DATABASE DESIGN AND MANAGEMENT EBT 514 0 3 + 0 3 6
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Yüksek Lisans
Dersin Türü SECMELI
Dersin Koordinatörü Prof.Dr. CELAL ÇEKEN
Dersi Verenler Prof.Dr. CELAL ÇEKEN
Dersin Yardımcıları
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, 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 - Recognize database management systems 1 - 2 - 3 - A -
2 - Make the models of database with entity-relation diagrams. 1 - 2 - 3 - 4 - A - C -
3 - Query databases with SQL 1 - 3 - 4 - 16 - A - C - D -
4 - Understand normalization steps 1 - 4 - 6 - 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 to Database Management Systems
2 Data Models, Entity Relationship Model
3 Entity Relationship Model Examples
4 Relational Database Model
5 Extended Entity Relationship Model
6 Structured Query Language (SQL)
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 Exercises

Kaynaklar

Ders Notu Lecture Notes
Ders Kaynakları 1. Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation, and Management, Cengage Learning.
2. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, Mc Graw Hill
3. http://www.postgresql.org/docs/manuals/
4. https://www.valentina-db.com/en/valentina-studio-overview
5. 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 ability to access wide and deep information with scientific researches in the field of Engineering, evaluate, interpret and implement the knowledge gained in his/her field of study X
2 ability to complete and implement limited or incomplete data by using the scientific methods. X
3 ability to consolidate engineering problems, develop proper method(s) to solve and apply the innovative solutions to them X
4 ability to develop new and original ideas and method(s), to develop new innovative solutions at design of system, component or process X
5 gain comprehensive information on modern techniques, methods and their borders which are being applied to engineering X
6 ability to design and apply analytical, modelling and experimental based research, analyze and interpret the faced complex issues during the design and apply process X
7 gain high level ability to define the required information and data X
8 ability to work in multi-disciplinary teams and to take responsibility to define approaches for complex situations
9 systematic and clear verbal or written transfer of the process and results of studies at national and international environments
10 aware of social, scientific and ethical values guarding adequacy at all professional activities and at the stage of data collection, interpretation and announcement
11 aware of new and developing application of profession and ability to analyze and study on those applications X
12 ability to interpret engineering applications social and environmental dimensions and its compliance with the social environment

Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 30
Odev 1 35
Odev 2 35
Toplam 100
Yıliçinin Başarıya Oranı 40
Finalin Başarıya Oranı 60
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 3 48
Hours for off-the-classroom study (Pre-study, practice) 16 3 48
Mid-terms 1 15 15
Assignment 2 10 20
Final examination 1 20 20
Toplam İş Yükü 151
Toplam İş Yükü /25(s) 6.04
Dersin AKTS Kredisi 6.04
; ;