TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF EDUCATION |
| COMPUTER EDUCATION AND INSTRUCTIONAL TECHNOLOGY PR. | |
| Code | BTEZ206 |
| Name | Database Management Systems |
| Term | 2020-2021 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 |
| Label | FE Field Education Courses C Compulsory |
| Mode of study | Uzaktan Öğretim |
| Catalog Information Coordinator | Prof. Dr. OZAN ŞENKAL |
| Course Instructor |
Prof. Dr. OZAN ŞENKAL
(Bahar)
(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
Resources
Notes
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 | - | Explain sub-fields of instructional technologies and integral structure of its process and also its relation to the other fields.Explain the integral structure of instructional technologies and information technologies or computer science applications.Explain concepts that constitutes the basis for scientific thinking in the scope of the field and the related fields. | 1 |
| PLO02 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies.Utilize information technologies and computer science applications in order to create an effective and productive learning environment.Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. | 2 |
| PLO03 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies.Utilize information technologies and computer science applications in order to create an effective and productive learning environment.Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. | 3 |
| PLO04 | - | Develop a plan, apply the plan and assess the results based on scientific view for the solution of the problems presented in the scope of the field or related fields.Put forward new products or processes on the basis of components of instructional technologies, computer science, for the related situations. | 3 |
| PLO05 | - | Develop a personal proposal, a product or a group of processes for the solution of a problem related to the field as an indicator of the skills of working independently and taking responsibility.Take responsibility of an individual or group projects and accomplishing his/her undertaken missions. | 4 |
| PLO06 | - | Follow current problems and applications and determining information and skills to undertake learning missions for the following stage.Apply the solution for the problem on the basis of scientific and ethical values when she/he confronts a learning problem. | 5 |
| PLO07 | - | Build a healthy communication with students, teachers, school administration, and the individuals in the study group. Comprehend a foreign language in order to follow the international resources that can be utilized for the solution of problems related to the field. Take responsibilities for the distribution and dissemination of the developments in the field on local or national range. | 5 |
| PLO08 | - | Act on the basis of scientific and ethical values in her/his works and also support preservation and learning of these values. Develop and evaluate strategic views on topic related to the future of the field. Transfer related progresses in other related fields to the field of instructional technologies. Create and maintain a cooperative and productive working environment by developing an insight related to the behaviors of the shareholders. | 5 |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Introduction to the database | Examination of relevant sources. | |
| 2 | Database management systems (DBMS) functions | Examination of relevant sources. | |
| 3 | Relational model, Relational data structures, Database relations, Relational keys | Examination of relevant sources. | |
| 4 | Structured Query Language, SQL | Examination of relevant sources. | |
| 5 | Structured Query Language, SQL | Examination of relevant sources. | |
| 6 | SQL: Data definition, Query examples | Examination of relevant sources. | |
| 7 | Database planning, Design and management, Asset relationship modeling | Examination of relevant sources. | |
| 8 | Mid-Term Exam | Examination of relevant sources. | |
| 9 | Normalization | Examination of relevant sources. | |
| 10 | Advanced normalization | Examination of relevant sources. | |
| 11 | Conceptual and logical database design, physical database design | Examination of relevant sources. | |
| 12 | Database security | Examination of relevant sources. | |
| 13 | Query processing | Examination of relevant sources. | |
| 14 | Scattered database concept and design | Examination of relevant sources. | |
| 15 | Scattered database concept and design | Examination of relevant sources. | |
| 16 | Term Exams | Examination of relevant sources. | |
| 17 | Term Exams | Examination of relevant sources. |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |
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 | ||