Yazdır

Ders Tanımı

Ders Kodu Yarıyıl T+U Saat Kredi AKTS
DATABASE MANAGEMENT SYSTEMS ENF 532 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ü Doç.Dr. İHSAN HAKAN SELVİ
Dersi Verenler Doç.Dr. İHSAN HAKAN SELVİ
Dersin Yardımcıları
Dersin Kategorisi
Dersin Amacı
As computers becoming indispensable parts of our lives, data and databases gathers more importance everyday. The main goal of the course is to teach the basics of database(data storage), how to use, design and make sample applications. In addition to teach students about the concepts of a database, data modeling and logical design which enables them to store and efficiently manage the relational data that can be encountered in many areas of daily life; to teach students about Structured Query Language (SQL) which allows them to define and manipulate data in a database and to provide students to develop database applications using Microsoft Access, Microsoft SQL Server or MYSQL, the three relational database management systems which have widespread use.
Dersin İçeriği
Definitions and basic concepts, entity-relation model, Relational Data Model, Relational Algebra and Calculation, Structural Query Language, Functional dependence and normalization, Database Recovery, Database Security, Object Oriented Database,
Dersin Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 - Recognize database management systems 1 - A -
2 - Make the models of database with entity-relation diagrams. 1 - 4 - A - C -
3 - Structured Query Language (SQL) to learn the structure and codes 1 - 4 - 6 - 13 - 16 - A - C - D -
4 - SQL codes with the create database, create tables and queries 12 - 13 - 16 - A - C - D -
5 - Apply the rules of Database Normalization 1 - 2 - 12 - A - C - D -
6 - Install and use the database management systems 1 - 13 - A - C - D -
Öğretim Yöntemleri: 1:Lecture 4:Drilland Practice 6:Motivations to Show 13:Lab / Workshop 16:Project Based Learning 2:Question-Answer 12:Case Study
Ölçme Yöntemleri: A:Testing C:Homework D:Project / Design

Ders Akışı

Hafta Konular ÖnHazırlık
1 Historical Evolution of Database Management Systems
2 Data Modeling, The Entity-Relationship Model (ER Model)
3 Relational Data Model and Relational Database Constraints, Relationship Types : 1-1, 1-N, N-M Relationships
4 Relational Algebra and Calculation
5 Rules of Database Normalization
6 Introduction to Structured Query Language (SQL) and Data Definition Language (DDL)
7 Create Queries with SQL Data Manipulation Languages (DML)
8 Create Queries with SQL Data Manipulation Languages (DML)
9 Complex Queries
10 Complex Queries
11 Application Development with Database Management Systems
12 Application Development with Database Management Systems
13 Distributed Databases
14 Object Oriented Databases and Database Connection Through User Applications

Kaynaklar

Ders Notu
Ders Kaynakları

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 X
2 X
3 X
4 X
5 X
6 X
7 X
8 X
9 X

Değerlendirme Sistemi

YARIYIL İÇİ ÇALIŞMALARI SIRA KATKI YÜZDESİ
AraSinav 1 25
Odev 1 37
Odev 2 38
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 2 32
Mid-terms 1 10 10
Assignment 2 15 30
Final examination 1 20 20
Toplam İş Yükü 140
Toplam İş Yükü /25(s) 5.6
Dersin AKTS Kredisi 5.6
; ;