DATABASE MANAGEMENT PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
IBY216	DATABASE MANAGEMENT	4	4	2	6

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	BACHELOR'S DEGREE, TYY: + 6.Level, EQF-LLL: 6.Level, QF-EHEA: First Cycle
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Assoc.Prof. MUSTAFA ÇANAKÇIOĞLU
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	This course aims to enable the student to access the data using the SQL language, to analyze the query results, and also to recognize the Oracle relational database systems and develop advanced data processing tools with PL/SQL.
Contents of the Course Unit:	Contents of the course include the subjects such as concepts of database systems, transaction processing, synchrony control and database recovery, object-oriented and object-relational databases, semi-structured data and XML, parallel and distributed databases, advanced distributed databases concepts, access to big data, and temporary databases.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Evaluate the role of database management systems in the organization.
Use current and logical design methods for databases.
Produce a physical database design from its logical design.
Apply a database solution to the information technology problem.
Use the SQL query language.
Determine alternative design techniques for management and reporting applications.
Prepare queries for big data sets.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Introduction	Lecture, Discussion, Practice
2	Literature Review	Transaction processing concepts	Lecture, Discussion, Practice
3	Literature Review	Transaction processing concepts	Lecture, Discussion, Practice
4	Literature Review	Synchrony control techniques	Lecture, Discussion, Practice
5	Literature Review	Synchrony control techniques	Lecture, Discussion, Practice
6	Literature Review	Database recovery systems	Lecture, Discussion, Practice
7	Literature Review	Object-oriented and object-relational databases	Lecture, Discussion, Practice
8	-	MID-TERM EXAM	-
9	Literature Review	semi-structured data and XML	Lecture, Discussion, Practice
10	Literature Review	Parallel and Distributed databases	Lecture, Discussion, Practice
11	Literature Review	Distributed databases – advanced concepts	Lecture, Discussion, Practice
12	Literature Review	Distributed databases – advanced concepts	Lecture, Discussion, Practice
13	Literature Review	Big data - Apache Hadoop, MapReduce & Pig Latin	Lecture, Discussion, Practice
14	Literature Review	Temporary Databases	Lecture, Discussion, Practice
15	Literature Review	General Revision	Lecture, Discussion, Practice
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Ozseven, T. (2015). Veritabani Yonetim Sistemleri II, Beta Publications, Istanbul.
Tan, P., Steinbach, M. Kumar, V. (2005). Introduction to Data Mining.

ASSESSMENT
Assessment & Grading of In-Term Activities	Number of Activities	Degree of Contribution (%)	Description

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Learns the basic information about electronic commerce.				3
2	Gains awareness about project and risk management skills and the importance of entrepreneurship, innovation and sustainable development.			2

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Follows new generation marketing strategies by learning digital marketing.		1

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Correctly relates the relationship between electronic commerce and information and communication technologies.					4

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Applies the knowledge and skills related to the field, taking into account its social and ethical responsibilities.		1

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Researches developments in science and technology and understands the importance of constantly renewing themselves adopting lifelong learning as a principle.					4

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains skills in web and graphic design.			2
2	Has the ability to produce innovative works by learning to use digital tools effectively.						5

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Evaluates the developments in the world from an intellectual perspective in the light of the joint faculty courses taken.		1

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Analyzes the current e-commerce environment.				3

WORKLOAD & ECTS CREDITS OF THE COURSE UNIT
Workload for Learning & Teaching Activities
Type of the Learning Activites	Learning Activities (# of week)	Duration (hours, h)	Workload (h)
Lecture & In-Class Activities	14	3	42
Preliminary & Further Study	13	3	39
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	0	0	0
Seminar	0	0	0
Internship	0	0	0
Technical Visit	0	0	0
Web Based Learning	0	0	0
Implementation/Application/Practice	0	0	0
Practice at a workplace	0	0	0
Occupational Activity	0	0	0
Social Activity	0	0	0
Thesis Work	0	0	0
Field Study	0	0	0
Report Writing	0	0	0
Final Exam	1	1	1
Preparation for the Final Exam	6	5	30
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	6	42
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	42	0	155