SECTION I: GENERAL INFORMATION ABOUT THE COURSE

Course Code	Course Name	Year	Semester	Theoretical	Practical	Credit	ECTS
50612METO-MBT103	Database Design	1	Spring	2	1	3	5

Course Type :	Compulsory
Cycle:	Associate      TQF-HE:5. Master`s Degree      QF-EHEA:Short Cycle      EQF-LLL:5. Master`s Degree
Language of Instruction:	Turkish
Prerequisities and Co-requisities:	N/A
Mode of Delivery:	Face to face
Name of Coordinator:	Instructor GÜLSÜM KAMER
Dersin Öğretim Eleman(lar)ı:
Dersin Kategorisi:	Programme Specific

SECTION II: INTRODUCTION TO THE COURSE

Course Objectives & Content

Course Objectives:	The objective of this course is to introduce the principles of database systems including a comprehensive introduction to data modeling, relational database design, query languages, transaction processing, distributed databases and physical database design.
Course Content:	Database requirements analysis, database definition, installation of database tools , creating tables and determining their characteristics, creating queries and using the types of queries,preparing queries with relational tables,using DML queries,writing user queries, normalization

Course Learning Outcomes (CLOs)

Course Learning Outcomes (CLOs) are those describing the knowledge, skills and competencies that students are expected to achieve upon successful completion of the course. In this context, Course Learning Outcomes defined for this course unit are as follows:

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

1) Know components of a database system.

2) Know the database design.

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

1) Use query language to elicit information from a database.

2) Categorize data models based on the types of concepts that they provide to describe the database structure.

3) Design relational databases in SQL.

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.)

Weekly Course Schedule

Week	Subject	Materials Sharing *
		Related Preparation	Further Study
1)	Setting up and using of the database tools,Creating queries and using the types of them	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
2)	Creating tables and identifying their properties	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
3)	Creating tables and identifying their properties	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
4)	Creating tables and identifying their properties	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
5)	Database requirement analysis, Introduction to relational database design	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
6)	Normalization	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
7)	Normalization	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
8)	Midterm
9)	Creating queries and using the types of them	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
10)	Creating queries and using the types of them	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
11)	Preaparing queries with relational tables	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
12)	Using DML queries	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
13)	Using DML queries,Writing user defined queries	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
14)	Creating views and queries	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
15)	Creating triggers and subprogram queries	Kerem Köseoğlu, Veritabanı Mantığı, Pusula Yayıncılık, 2016. Reading the related chapter and other resources to be obtained
16)	Final Exam

*These fields provides students with course materials for their pre- and further study before and after the course delivered.

Recommended or Required Reading & Other Learning Resources/Tools

Course Notes / Textbooks:	Kerem Köseoğlu, 2016; Veritabanı Mantığı, 10. Baskı, Pusula Yayıncılık
References:	Turgut Özseven, 2019; Veritabanı Yönetim Sistemleri, 4.Baskı, Ekin Yayınevi Coşkun Telciler, 2013; Veritabanı Kavramı ve MS-SQL Uygulamaları, Pusula Yayıncılık Dr. Ali Nizam, 2011; Veritabanı Tasarımı-İlişkisel Veri Modeli ve Uygulamaları, Papatya Bilim Musa Çiçek, 2010; Veritabanı Tasarımı ve SQL Sorgulama Dili, Nirvana Yayınevi

SECTION III: RELATIONSHIP BETWEEN COURSE UNIT AND COURSE LEARNING OUTCOMES (CLOs)

(The matrix below shows how the course learning outcomes (CLOs) associates with programme learning outcomes (both KPLOs & SPLOs) and, if exist, the level of quantitative contribution to them.)

Relationship Between CLOs & PLOs

(KPLOs and SPLOs are the abbreviations for Key & Sub- Programme Learning Outcomes, respectively. )

CLOs/PLOs
CLO1
CLO2
CLO3
CLO4
CLO5

Level of Contribution of the Course to PLOs

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Programme Learning Outcomes	Contribution Level (from 1 to 5)
1)	Are able to use their basic knowledge and skills on mobile network, infrastructure, application solutions and M2M(Machine to Machine Communication) and solve the problems on these fields.
2)	Adopt total quality philosophy and
3)	Dave sufficient numeral knowledge and skills background on their field.
4)	Have the knowledge related to current information technologies and devices, hardware, maintenance/ repairing of mobile devices.
5)	Have the ability to follow current technological knowledge on hardware and especially software.
6)	Have the skills in terms of mobile marketing and innovative thinking.
7)	Use mobile devices professionally.
8)	Use current information technologies and devices and the knowledge on hardware, maintenance/repairing and developing of mobile devices effectively.
9)	Develop mobile solutions fitting to the necessity
10)	Make occupational plans and projects effectively
11)	Have the abilitiy for planning.
12)	Can consult problem solving ways in case of need.
13)	Have the ability to apply software and hardware technologies in industry and service.
14)	Can use simulation programmes referring to the related field.
15)	Have the ability to take responsibilty to work in a team and individually and communicate.
16)	Follw software and hardware technologies in industry and service sectors.
17)	Act according to social, scienticif, cultural and ethical values during the processes of collecting, evaluating, applying and announcing data.
18)	Conduct areal activities in accordance with universality of social rights, social justice, quality culture and preserving cultural values and job safety.
19)	Inform related people and institutions verbally and in writing about ideas and problem-solving solutions.
20)	Share areal ideas and solutions with experts and nonexperts supporting them with quantitive and qualitative data.
21)	Use a foreign language(English) at at least Europe Language Portfolio A2 General Level and follow areal developments and communicate with colloeagues
22)	Use informatic and communicative technologies in accordance with Advanced Level of Europian Computer Driving Licence.
23)	Organize projects and events with social responsibility.
24)	Evaluate areal advanced knowledge and skills critically.
25)	Plan activities for developing performances of themselves and the people whom they are in charge of in direction of learning targets and manage these processes.
26)	Take responsibility individually or as a team member in executing areal complicated or unforseen activities.
27)	Executes an advanced level activity independently.
28)	Manage the activities that they are in charge of
29)	Take risk and responsibility in applying innovative ideas, information and technologies.
30)	Take responsibility in turning areal knowledge and skills into ideas/approaches/technologies/products with high added value considering individual, occupational and areal risks and opportunities.

SECTION IV: TEACHING-LEARNING & ASSESMENT-EVALUATION METHODS OF THE COURSE

Teaching & Learning Methods of the Course

(All teaching and learning methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Teaching and Learning Methods defined at the Programme Level	Teaching and Learning Methods Defined for the Course
Lectures
Discussion
Case Study
Problem Solving
Demonstration
Views
Laboratory
Reading
Homework
Project Preparation
Thesis Preparation
Peer Education
Seminar
Technical Visit
Course Conference
Brain Storming
Questions Answers
Individual and Group Work
Role Playing-Animation-Improvisation
Active Participation in Class

Assessment & Evaluation Methods of the Course

(All assessment and evaluation methods used at the university are managed systematically. Upon proposals of the programme units, they are assessed by the relevant academic boards and, if found appropriate, they are included among the university list. Programmes, then, choose the appropriate methods in line with their programme design from this list. Likewise, appropriate methods to be used for the course units can be chosen among those defined for the programme.)

Aassessment and evaluation Methods defined at the Programme Level	Assessment and Evaluation Methods defined for the Course
Midterm
Presentation
Final Exam
Quiz
Report Evaluation
Homework Evaluation
Oral Exam
Thesis Defense
Jury Evaluation
Practice Exam
Evaluation of Implementation Training in the Workplace
Active Participation in Class
Participation in Discussions

Relationship Between CLOs & Teaching-Learning, Assesment-Evaluation Methods of the Course

(The matrix below shows the teaching-learning and assessment-evaluation methods designated for the course unit in relation to the course learning outcomes.)

Contribution of Assesment & Evalution Activities to Final Grade of the Course

Measurement and Evaluation Methods	# of practice per semester	Level of Contribution
Quizzes	2	% 10.00
Homework Assignments	1	% 10.00
Midterms	1	% 30.00
Semester Final Exam	1	% 50.00
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 50
PERCENTAGE OF FINAL WORK		% 50
Total		% 100

SECTION V: WORKLOAD & ECTS CREDITS ALLOCATED FOR THE COURSE

WORKLOAD OF TEACHING & LEARNING ACTIVITIES
Teaching & Learning Activities	# of Activities per semester	Duration (hour)	Total Workload
Course	14	2	28
Laboratory	14	1	14
Application	0	0	0
Special Course Internship (Work Placement)	0	0	0
Field Work	0	0	0
Study Hours Out of Class	0	0	0
Presentations / Seminar	0	0	0
Project	0	0	0
Homework Assignments	1	10	10
Total Workload of Teaching & Learning Activities	-	-	52
WORKLOAD OF ASSESMENT & EVALUATION ACTIVITIES
Assesment & Evaluation Activities	# of Activities per semester	Duration (hour)	Total Workload
Quizzes	2	15	30
Midterms	1	15	15
Semester Final Exam	1	20	20
Total Workload of Assesment & Evaluation Activities	-	-	65
TOTAL WORKLOAD (Teaching & Learning + Assesment & Evaluation Activities)			117
ECTS CREDITS OF THE COURSE (Total Workload/25.5 h)			5