BTEZ206 Database Management Systems

3 ECTS - 3-0 Duration (T+A)- 4. Semester- 3 National Credit

Information

Code BTEZ206
Name Database Management Systems
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 Goal

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