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 |