Dersin Adı Dersin Seviyesi Dersin Kodu Dersin Tipi Dersin Dönemi Yerel Kredi AKTS Kredisi Ders Bilgileri
DATABASE MANAGEMENT SYTEMS Birinci Düzey YZ 305 Zorunlu 5 5.00 5.00 Yazdır
   
Dersin Tanımı
Ön Koşul Dersleri -
Eğitimin Dili English
Koordinatör PROF. DR. CELAL ÖZTÜRK
Dersi Veren Öğretim Eleman(lar)ı PROF. DR. CELAL ÖZTÜRK
Yardımcı Öğretim Eleman(lar)ı -
Dersin Veriliş Şekli Formal education
Dersin Amacı The primary objective of this course is to provide students with the engineering competencies required to design, implement, and manage modern database systems.
Dersin Tanımı This course covers the fundamental and advanced aspects of Database Management Systems, starting from conceptual modeling with Entity-Relationship (ER) diagrams and relational design through normalization. It provides practical experience in SQL implementation and explores critical system topics such as transaction management, concurrency control, and query optimization.

Dersin İçeriği
1 Introduction to database management systems
2 Relational databases
3 Relational algebra
4 Entity-relationship diagrams
5 Normalization
6 SQL
7 SQL applications
8 SQL applications
9 Database administration
10 Transactions
11 Consistency and concurrency controls
12 Recovery Management
13 Index and hash operations
14 NoSQL databases
15
16
17
18
19
20

Dersin Öğrenme Çıktıları
1 Explains the fundamental components, architecture, and environment of Database Management Systems.
2 Designs conceptual data models using Entity-Relationship Diagrams (ERD) to formulate solutions for complex engineering problems.
3 Applies normalization techniques to relational database designs to ensure data integrity and address realistic constraints.
4 Implements database solutions using SQL (DDL, DML) and modern informatics tools for complex data manipulation tasks.
5 Manages transactions and concurrency control mechanisms to maintain data consistency and system reliability.
6 Evaluates indexing, hashing, and query optimization techniques to enhance database performance.
7 Analyzes advanced database architectures, including NoSQL systems, in the context of emerging technologies.
8
9
10

*Dersin Program Yeterliliklerine Katkı Seviyesi
1 Applies engineering knowledge related to mathematics, science, basic engineering, and computer-based calculations to solve engineering problems.
2 Gains the ability to develop engineering solutions using discipline-specific knowledge and methods.
3 Defines complex engineering problems and formulates them using fundamental science and engineering knowledge.
4 Defines and analyzes solutions to problems, taking into account the UN Sustainable Development Goals.
5 Designs creative solutions to complex engineering problems.
6 Gains the ability to design complex systems, processes, devices, or products by considering realistic constraints in the engineering problem-solving process.
7 For the analysis and solution of complex engineering problems, selects and effectively applies appropriate methods, techniques, resources, and modern engineering and computing tools, including estimation and modeling.
8 Aware of the limitations of the methods, techniques, and IT tools used, it produces and implements appropriate solutions.
9 Conducts literature research to examine complex engineering problems and collects data within the scope of these studies.
10 Using research methods, the student designs and conducts experimental or applied studies, analyze and evaluate the results.
11 Within the scope of the UN Sustainable Development Goals, the student is knowledgeable about the impacts of engineering solutions on society, health and safety, the economy, sustainability, and the environment, and analyze these impacts.
12 Gains awareness of the legal consequences of engineering solutions.
13 The student acts in accordance with professional principles and legal regulations in engineering practice and acquires knowledge about ethical responsibilities.
14 Gains awareness about non-discrimination, impartiality, and inclusiveness of diversity.
15 Gains the ability to work effectively as an individual, team member, or team leader in intra-disciplinary or multi-disciplinary team projects.
16 Gains the ability to communicate effectively in technical matters, both verbally and in writing by taking into account the differences in the target audience''s education, language, and profession.
17 Gains the ability to apply project management principles, perform time and resource planning, and conduct economic feasibility analysis.
18 Gains awareness about entrepreneurship and innovation.
19 Gains the ability to adapt to new and emerging technologies and to evaluate technological changes with a questioning and critical perspective.
20 Gains the ability to independently and continuously learn new knowledge and skills.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Yıldızların sayısı 1’den (en az) 5’e (en fazla) kadar katkı seviyesini ifade eder

Planlanan Öğretim Faaliyetleri, Öğretme Metodları ve AKTS İş Yükü
  Sayısı Süresi (saat) Sayı*Süre (saat)
Yüz yüze eğitim 0 0 0
Sınıf dışı ders çalışma süresi (ön çalışma, pekiştirme) 0 0 0
Ödevler 0 0 0
Sunum / Seminer hazırlama 0 0 0
Kısa sınavlar 0 0 0
Ara sınavlara hazırlık 0 0 0
Ara sınavlar 0 0 0
Proje (Yarıyıl ödevi) 0 0 0
Laboratuvar 0 0 0
Arazi çalışması 0 0 0
Yarıyıl sonu sınavına hazırlık 0 0 0
Yarıyıl sonu sınavı 0 0 0
Araştırma 0 0 0
Toplam iş yükü     0
AKTS     0.00

Değerlendirme yöntemleri ve kriterler
Yarıyıl içi değerlendirme Sayısı Katkı Yüzdesi
Ara sınav 0 0
Kısa sınav 0 0
Ödev 0 0
Yarıyıl içi toplam   0
Yarıyıl içi değerlendirmelerin başarıya katkı oranı   0
Yarıyıl sonu sınavının başarıya katkı oranı   0
Genel toplam   0

Önerilen Veya Zorunlu Okuma Materyalleri
Ders kitabı
Yardımcı Kaynaklar

Ders İle İlgili Dosyalar