Ders Adı | Kodu | Yarıyıl | T+U Saat | Kredi | AKTS |
---|---|---|---|---|---|
Industrıal Applıcatıons Of Computer Software | ENM 216 | 4 | 3 + 0 | 3 | 5 |
Ön Koşul Dersleri | |
Önerilen Seçmeli Dersler | |
Dersin Dili | Türkçe |
Dersin Seviyesi | Lisans |
Dersin Türü | Zorunlu |
Dersin Koordinatörü | Prof.Dr. İBRAHİM ÇİL |
Dersi Verenler | Prof.Dr. İBRAHİM ÇİL, Dr.Öğr.Üyesi MÜMTAZ İPEK, |
Dersin Yardımcıları | |
Dersin Kategorisi | Alanına Uygun Temel Öğretim |
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, |
# | Ders Öğrenme Çıktıları | Öğretim Yöntemleri | Ölçme Yöntemleri |
---|---|---|---|
1 | Recognize database management systems | Lecture, | Testing, |
2 | Make the models of database with entity-relation diagrams. | Lecture, Drilland Practice, | Testing, Homework, |
3 | Structured Query Language (SQL) to learn the structure and codes | Lecture, Drilland Practice, Motivations to Show, Lab / Workshop, Project Based Learning, | Testing, Homework, Project / Design, |
4 | SQL codes with the create database, create tables and queries | Case Study, Lab / Workshop, Project Based Learning, | Testing, Homework, Project / Design, |
5 | Apply the rules of Database Normalization | Lecture, Question-Answer, Case Study, | Testing, Homework, Project / Design, |
6 | Install and use the database management systems | Lecture, Lab / Workshop, | Testing, Homework, Project / Design, |
Hafta | Ders Konuları | Ön Hazı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 | Midterm Exam | |
11 | Application Development with Database Management Systems | |
12 | Application Development with Database Management Systems | |
13 | Application Development with Database Management Systems | |
14 | Object Oriented Databases and Database Connection Through User Applications |
Kaynaklar | |
---|---|
Ders Notu | |
Ders Kaynakları |
Sıra | Program Çıktıları | Katkı Düzeyi | |||||
---|---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | |||
1 | Engineering graduates with sufficient knowledge background on science and engineering subjects of their related area, and who are skillful in implementing theoretical and practical knowledge for modelling and solving engineering problems. | ||||||
2 | Engineering graduates with skills in identifying, describing, formulating and solving complex engineering problems, and thus,deciding and implementing appropriate methods for analyzing and modelling. | X | |||||
3 | Engineering graduates with skills in designing a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; for this purpose, skills in implementing modern design methods. | X | |||||
4 | Engineering graduates with skills in developing, selecting and implementing modern techniques and tools required for engineering applications as well as with skills in using information technologies effectively. | X | |||||
5 | Engineering graduates with skills in designing and conducting experiments, collecting data, analyzing and interpreting the results in order to evaluate engineering problems. | X | |||||
6 | Engineering graduates who are able to work within a one discipline or multi-discipline team,as well as who are able to work individually | ||||||
7 | Engineering graduates who are able to effectively communicate orally and officially in Turkish Language as well as who knows at least one foreign language | ||||||
8 | Engineering graduates with motivation to life-long learning and having known significance of continuous education beyond undergraduate studies for science and technology | X | |||||
9 | Engineering graduates with well-structured responsibilities in profession and ethics | ||||||
10 | Engineering graduates having knowledge about practices in professional life such as project management, risk management and change management, and who are aware of innovation and sustainable development. | X | |||||
11 | Engineering graduates having knowledge about universal and social effects of engineering applications on health, environment and safety, as well as having awareness for juridical consequences of engineering solutions. |
Değerlendirme Sistemi | |
---|---|
Yarıyıl Çalışmaları | Katkı Oranı |
1. Ara Sınav | 50 |
1. Kısa Sınav | 10 |
2. Kısa Sınav | 10 |
1. Ödev | 30 |
Toplam | 100 |
1. Final | 50 |
1. Yıl İçinin Başarıya | 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 | 10 | 10 |
Assignment | 1 | 15 | 15 |
Performance Task (Laboratory) | 2 | 5 | 10 |
Final examination | 1 | 15 | 15 |
Toplam İş Yükü | 114 | ||
Toplam İş Yükü / 25 (Saat) | 4,56 | ||
Dersin AKTS Kredisi | 5 |