Ders Adı Kodu Yarıyıl T+U Saat Kredi AKTS
Database Desıgn and Applıcatıons BSM 436 8 3 + 0 3 5
Ön Koşul Dersleri
Önerilen Seçmeli Dersler
Dersin Dili Türkçe
Dersin Seviyesi Lisans
Dersin Türü Seçmeli
Dersin Koordinatörü Dr.Öğr.Üyesi İSMAİL ÖZTEL
Dersi Verenler
Dersin Yardımcıları
Dersin Kategorisi Diğer
Dersin Amacı The aim of the course is to teach the usage, design and applications of database management systems with practices.
Dersin İçeriği Basic concepts of database, database management systems, SQL, Oracle
# Ders Öğrenme Çıktıları Öğretim Yöntemleri Ölçme Yöntemleri
1 Recognize database management systems Lecture, Testing,
2 Use Oracle Lecture, Drilland Practice, Testing, Homework,
3 Use Sql Server Lecture, Drilland Practice, Project Based Learning, Testing, Homework, Project / Design,
4 Use DB2 Lecture, Drilland Practice, Testing, Homework,
5 Lecture, Discussion, Drilland Practice, Motivations to Show, Testing, Homework, Project / Design,
Hafta Ders Konuları Ön Hazırlık
1 Basics of database (installation, uninstallation)
2 Design, modelling and management systems in databases
3 Oracle database and properties
4 Oracle database and using tools
5 Creating tables and recording procedures in Oracle
6 Functions in Oracle
7 Ordering, getting records, updating and deleting procedures in Oracle
8 Table design examples and query tecnics in Oracle
9 Oracle APEX
10 Oracle APEX
11 Oracle APEX
12 Oracle APEX
13 Oracle APEX
14 Oracle APEX
Kaynaklar
Ders Notu Lecture Notes
Ders Kaynakları orcale docs
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, 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, X
12 An understanding universal and local effects of engineering solutions; awareness of entrepreneurial and innovation and to have knowledge about contemporary problems. X
13
Değerlendirme Sistemi
Yarıyıl Çalışmaları Katkı Oranı
1. Ara Sınav 55
1. Ödev 15
2. Ödev 15
3. Ödev 15
Toplam 100
1. Yıl İçinin Başarıya 50
1. Final 50
Toplam 100
AKTS - İş Yükü Etkinlik Sayı Süre (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 1 16
Mid-terms 1 15 15
Assignment 3 10 30
Final examination 1 20 20
Toplam İş Yükü 129
Toplam İş Yükü / 25 (Saat) 5,16
Dersin AKTS Kredisi 5