General Information about the Course

Course Code:	BGP103
Course Title:	Database Management Systems 1
Course Semester:	1. Semester / Fall
Course Credits:	Theoretical Practical Credit ECTS 1 2 2 5
Language of instruction:	TR
Prerequisite of the course:	No
Ders İş Deneyimini Gerektiriyor mu?:	No
Type of course:	Necessary
Level of course:	Associate TR-NQF-HE:5. Master`s Degree QF-EHEA:Short Cycle EQF-LLL:5. Master`s Degree
Course Lecturer(s):	Öğr.Gör. Volkan AKSOY Öğr.Gör. Begüm AL
Course Assistants:

Purpose and content of the course

Course Objectives:	To teach students the basic principles and structure of database management systems.
Course Objective:	To enable students to gain skills in database design and management and to create effective databases.
Mode of Delivery:	Face to face

Learning Outcomes

Knowledge (Described as Theoritical and/or Factual Knowledge.)

1) Have knowledge and skills at the knowledge and comprehension levels about the basic concepts related to database

2) Have the knowledge and skills at the levels of knowledge, comprehension and application about Information System Development Life Cycle Stages, Database Design Stages

3) Have knowledge and skills about Relational Data Models and Data Transformations at the knowledge, comprehension and application levels

Skills (Describe as Cognitive and/or Practical Skills.)

1) Gains knowledge, comprehension and application level knowledge and skills about SQL, Data Definition Language, Data Manipulation Language and related commands.

Competences (Described as "Ability of the learner to apply knowledge and skills autonomously with responsibility", "Learning to learn"," Communication and social" and "Field specific" competences.)

Course Topics

Week	Subject
Related Preparation	Pekiştirme
1)	BASIC CONCEPTS
2)	RELATIONAL DATABASE DESIGN AND NORMALIZATION
3)	SAMPLE LIBRARY DATABASE
4)	RELATIONAL ALGEBRA
5)	SQL STRUCTURED QUERY LANGUAGE
6)	QUERIES IN A SINGLE TABLE
7)	ARITHMETIC OPERATORS AND FUNCTIONS
8)	MIDTERM
9)	QUERY BY GROUPING
10)	QUERY ON MORE THAN ONE TABLE
11)	SUBQUESTIONS
12)	VIEWS
13)	INDEX USAGE
14)	GENERAL REVIEW AND APPLICATIONS
References: Özseven, T. (2020). Veritabanı Yönetim Sistemleri I ÖZKAN, Ö. Ü. B. (2020). Veritabanı Yönetimi. YARIMAĞAN, Ü. (2016). VERİ TABANI SİSTEMLERİ. 3D YAYINEVİ.

Ders - Program Öğrenme Kazanım İlişkisi

No Effect	1 Lowest	2 Average	3 Highest

Ders Öğrenme Kazanımları	1	2	3	4
Program Outcomes
1) Understand the basic concepts and terminology of computer science.
2) Ability to write code in widely used programming languages such as C, C++, Java, Python.
3) In-depth knowledge of algorithms and data structures.
4) To have knowledge about planning, execution and management of software projects.
5) To have knowledge about database design, management and SQL querying.
6) To have knowledge about computer networks, internet technologies and communication protocols.
7) Ability to write effective code in various programming languages and platforms.
8) Ability to solve complex problems with algorithmic thinking.
9) Ability to develop software solutions using mathematical and logical thinking skills.
10) Database creation, management and querying skills.
11) Ability to develop web applications with HTML, CSS, JavaScript and related frameworks.
12) Mobile application development skills for Android and iOS platforms.
13) To be able to work effectively in a team in software development processes.
14) Skills to plan, execute and manage software projects.
15) Continuous learning competence by following the innovations and current developments in technology.
16) Ability to communicate effectively with technical and non-technical stakeholders.
17) Adopting innovative approaches in software projects with creative thinking.
18) Having the necessary motivation for self-learning and professional development.
19) To bring the ideas and designs produced in the field of graphic design to the level of being able to apply them correctly within team work, to have the knowledge and to work harmoniously with the team in the field of design and production.
20) Plans the creation, application and production stages of graphic design. Visualizes designs using graphic programs on the computer.

Course Teaching, Learning Methods

Q & A
Case Problem Solving/ Drama- Role/ Case Management
Laboratory
Quantitative Problem Solving
Fieldwork
Group Study / Assignment
Individual Assignment
WEB-based Learning
Internship
Practice in Field
Project Preparation
Report Writing
Seminar
Supervision
Social Activity
Occupational Activity
Occupational Trip
Application (Modelling, Design, Model, Simulation, Experiment et.)
Reading
Thesis Preparation
Field Study
Student Club and Council Activities
Other
Logbook
Interview and Oral Conversation
Research
Watching a movie
Bibliography preparation
Oral, inscribed and visual knowledge production
Taking photographs
Sketching
Mapping and marking
Reading maps
Copying textures
Creating a library of materials
Presentation

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Attendance		% 0
Laboratory		% 0
Application		% 0
Practice Exam		% 0
Quizzes		% 0
Homework Assignments		% 0
Presentation		% 0
Project		% 0
Special Course Internship (Work Placement)		% 0
Field Study		% 0
Article Critical		% 0
Article Writing		% 0
Module Group Study		% 0
Brainstorming		% 0
Role Playing + Dramatizing		% 0
Out of Class Study		% 0
Preliminary Work, Reinforcement		% 0
Application Repetition etc.		% 0
Homework (reading, writing, watching movies, etc.)		% 0
Project Preparation + Presentation		% 0
Report Preparation + Presentation		% 0
Presentation / Seminar Preparation + Presenting		% 0
Oral examination		% 0
Midterms	1	% 40
Final	1	% 60
Report Submission		% 0
Bütünleme		% 0
Kanaat Notu		% 0
Committee		% 0
Yazma Ödev Dosyası		% 0
Portfolio		% 0
Take-Home Exam		% 0
Logbook		% 0
Discussion		% 0
Participation		% 0
total		% 100
PERCENTAGE OF SEMESTER WORK		% 40
PERCENTAGE OF FINAL WORK		% 60
total		% 100

Calculation of Workload and ECTS Credits

Activities	Number of Activities	Workload
Course Hours	14	56
Laboratory	14	28
Application
Practice Exam
Special Course Internship (Work Placement)
Field Work
Study Hours Out of Class	11	11
Article Critical
Article Writing
Module Group Study
Brainstorming
Role Playing + Dramatizing
Out-of-Class Study (Pre-study, Reinforcement, Practice Review, etc.)
Homework (reading, writing, watching movies, etc.)	4	8
Project Preparation + Presentation
Report Preparation + Presentation
Presentation / Seminar Preparation + Presenting
Oral examination
Preparing for Midterm Exams	6	12
MIDTERM EXAM (Visa)	1	1
Preparing for the General Exam	6	18
GENERAL EXAM (Final)	1	1
Participation
Discussion
Portfolio
Take-Home Exam
Logbook
Total Workload		135
ECTS (30 saat = 1 AKTS )		4