TÜRKÇE
ENGLISH
Information
| Code | BTEZ206 |
| Name | Database Management Systems |
| Term | 2023-2024 Academic Year |
| Semester | 4. Semester |
| Duration (T+A) | 3-0 (T-A) (17 Week) |
| ECTS | 3 ECTS |
| National Credit | 3 National Credit |
| Teaching Language | Türkçe |
| Level | Lisans Dersi |
| Type | Normal |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Prof. Dr. OZAN ŞENKAL |
| Course Instructor |
Prof. Dr. OZAN ŞENKAL
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
This course focuses on ethics in information technologies. In addition, in the course, the ethics of information is dealt with with the moral, legal and social aspects related to information technologies.
Course Content
Introduction to ethics and information technologies; ethical values and concepts, structure of ethical theories. Professional ethics and responsibility. Security and network ethics. Personality and Internet environments, personality and security. Intellectual property and waste. Copyright patent protection methods, copyrights and professional responsibility, and license agreements. Security issues; hacking and cracking. Trial problems in Internet and IT environments. Internet and criminals. Electronic trade. Awareness and informatics about entrepreneurship, innovation and sustainable development.
Course Precondition
None
Resources
Savaş Özdemir, Selçuk Alp, Arzu Kilitçi. Veri tabanı Yönetim Sistemleri, 2022
Notes
Lecture notes/presentations prepared by the instructor of the course
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Understands the basic concepts of database systems. |
| LO02 | Understands the functions of database management systems. |
| LO03 | Applies database system design and methods. |
| LO04 | Uses current database system technologies. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | Bilgi - Kuramsal, Olgusal | Knows and acts in accordance with the basic values, principles, laws, regulations and ethical rules required by the field of Computer and Instructional Technologies. | 2 |
| PLO02 | Beceriler - Bilişsel, Uygulamalı | Knows the basic principles of Mainstream theories, methods and techniques related to Learning and Teaching, Instructional Technologies, Information Technologies. | |
| PLO03 | Beceriler - Bilişsel, Uygulamalı | Selects and uses instructional technologies required by educational problems or activities. | 3 |
| PLO04 | Yetkinlikler - Alana Özgü Yetkinlik | Organizes activities for teaching the field of information technologies and develops appropriate teaching materials. | 4 |
| PLO05 | Beceriler - Bilişsel, Uygulamalı | Uses theoretical knowledge in computer and educational sciences for solution purposes in learning environments . | 3 |
| PLO06 | Yetkinlikler - Alana Özgü Yetkinlik | Identifies learning and teaching problems and designs solutions, selects and applies appropriate methods for this design. | |
| PLO07 | Yetkinlikler - Alana Özgü Yetkinlik | Develops an individual proposal, a product or a set of processes for solving a problem in the field as an indicator of independent working skills and the ability to take responsibility. Takes responsibility in individual or team projects and effectively fulfills the task. | 5 |
| PLO08 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | It engages in learning and self-development activities in order to follow current problems and changes in our country and in the world, and to acquire the knowledge and skills that the society in the near future will require.. | 5 |
| PLO09 | Yetkinlikler - Öğrenme Yetkinliği | She undertakes new learning tasks in new situations and, when faced with a learning problem, applies problem solving that will lead her and her team to success on the basis of scientific and ethical values. | |
| PLO10 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Establishes effective and healthy communication with students, teachers, school management, families and individuals in the study group. It takes responsibility for the dissemination and distribution of developments in the field at the local or national level. | 3 |
| PLO11 | Bilgi - Kuramsal, Olgusal | Acting on the basis of scientific and ethical values in its works, it supports the protection and learning of these values. | 2 |
| PLO12 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | It carries the relevant developments in other fields to the field of instructional technologies. It creates and maintains an efficient collaborative working environment in cooperation with stakeholders. | |
| PLO13 | Yetkinlikler - Alana Özgü Yetkinlik | Has the knowledge of software and hardware to teach Information and Communication Technologies courses and support other teachers; uses information and communication technologies and communicates using these technologies. | |
| PLO14 | Beceriler - Bilişsel, Uygulamalı | Within the scope of instructional technologies, it produces individual and group projects to solve the current problems of society. | |
| PLO15 | Yetkinlikler - Öğrenme Yetkinliği | In order to access information, it conducts resource research and uses up-to-date information sources, evaluates the accuracy and timeliness of the information obtained from different sources. | |
| PLO16 | Yetkinlikler - Öğrenme Yetkinliği | He has the skills of learning to learn, critical thinking and creative thinking. | |
| PLO17 | Yetkinlikler - Bağımsız Çalışabilme ve Sorumluluk Alabilme Yetkinliği | Works effectively individually and in interdisciplinary groups. | |
| PLO18 | Yetkinlikler - Alana Özgü Yetkinlik | Learns and uses emerging new technologies; In accordance with the basics of instructional technologies, it prepares content compatible with these new environments and presents it in a way that is effective in learning. | |
| PLO19 | Yetkinlikler - Alana Özgü Yetkinlik | Knows distance learning theories and uses mainstream distance learning applications, media, tools, platforms and technologies for learning and teaching purposes. | |
| PLO20 | Yetkinlikler - İletişim ve Sosyal Yetkinlik | Follows the information in the field and communicates with colleagues by using a foreign language at least at the European Language portfolio B1 level. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to the database | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım |
| 2 | Database management systems (DBMS) functions | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım |
| 3 | Relational model, Relational data structures, Database relations, Relational keys | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım, Rol Oynama |
| 4 | Structured Query Language, SQL | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım, Gösteri |
| 5 | Structured Query Language (SQL) applications | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım |
| 6 | SQL: Data definition, Query examples | Examination of relevant sources. | Öğretim Yöntemleri: Grup Çalışması |
| 7 | Database planning, Design and management, Asset relationship modeling | Examination of relevant sources. | Öğretim Yöntemleri: Gösterip Yaptırma |
| 8 | Mid-Term Exam | Examination of relevant sources. | Ölçme Yöntemleri: Yazılı Sınav |
| 9 | Normalization | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım, Gösterip Yaptırma |
| 10 | Advanced normalization | Examination of relevant sources. | Öğretim Yöntemleri: Gösteri |
| 11 | Conceptual and logical database design, physical database design | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım |
| 12 | Database security | Examination of relevant sources. | Öğretim Yöntemleri: Örnek Olay |
| 13 | Query processing | Examination of relevant sources. | Öğretim Yöntemleri: Soru-Cevap, Gösterip Yaptırma |
| 14 | Scattered database concept and design | Examination of relevant sources. | Öğretim Yöntemleri: Tartışma |
| 15 | Distributed database concept and design practices | Examination of relevant sources. | Öğretim Yöntemleri: Anlatım |
| 16 | Term Exams | Examination of relevant sources. | Öğretim Yöntemleri: Rol Oynama |
| 17 | Term Exams | Examination of relevant sources. | Ölçme Yöntemleri: Yazılı Sınav |
Student Workload - ECTS
| Works | Number | Time (Hour) | Workload (Hour) |
|---|---|---|---|
| Course Related Works | |||
| Class Time (Exam weeks are excluded) | 14 | 3 | 42 |
| Out of Class Study (Preliminary Work, Practice) | 14 | 2 | 28 |
| Assesment Related Works | |||
| Homeworks, Projects, Others | 0 | 0 | 0 |
| Mid-term Exams (Written, Oral, etc.) | 1 | 6 | 6 |
| Final Exam | 1 | 10 | 10 |
| Total Workload (Hour) | 86 | ||
| Total Workload / 25 (h) | 3,44 | ||
| ECTS | 3 ECTS | ||