DATABASE APPLICATIONS PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
BGT207	DATABASE APPLICATIONS	3	3	2	4

GENERAL INFORMATION
Language of Instruction :	Turkish
Level of the Course Unit :	ASSOCIATE DEGREE, TYY: + 5.Level, EQF-LLL: 5.Level, QF-EHEA: Short Cycle
Type of the Course :	Compulsory
Mode of Delivery of the Course Unit	-
Coordinator of the Course Unit	Lecturer TUĞÇE YÜKSEL
Instructor(s) of the Course Unit	Lecturer NAZMİYE İNAM
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	In today's world, data is one of the most important and vital corporate assets. Database management is one of the main topics of information technology strategy and information resource management. Based on these reasons, the aim of the course is to equip students with the most up-to-date knowledge and skills in analysis, design and application areas.
Contents of the Course Unit:	Data modeling and logical design of databases in the course; data description, processing and control languages; physical design of databases; Programming with SQL; data access standards; transaction management and client-server systems are discussed. In the field of database management, some advanced topics such as object oriented databases, distributed databases and data warehouses are also mentioned.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Prepares a relational database.
Implements a relational database.
Uses queries in a relational database using SQL language.
Designs multidimensional databases and data warehouses.
Designs object-relational and object oriented databases.
Creates users using SQL language.
Edits existing user roles using SQL language.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	-	Database Systems and Data Models	Instruction
2	Research	Relational Database Model	Instruction
3	Research	Entity-Relationship Model	Instruction
4	Research	Normalization of Database Tables	Demonstration
5	Research	Introduction to SQL Programming Language	Demonstration
6	Research	Functions Used in SQL Language	Demonstration
7	Research	Functions Used in SQL Language	Demonstration
8	-	MID-TERM EXAM	-
9	-	Database Problem Solutions	Demonstration
10	Research	Advanced SQL Programming	Demonstration
11	Research	Database Design	Demonstration
12	Research	Transaction Management and Concurrency Control (Dynamic T-SQL)	Demonstration
13	Research	Database Performance Settings and Query Optimization	Demonstration
14	Research	Query and Access Security	Demonstration
15	Research	Backup and Restoring from Backup	Demonstration
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Projeler ile SQL Server 2016, Süleyman Uzunköprü, Kodlab

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	Knows the necessary terms and information in the computer field.			2
2	Gains knowledge of the concept of information security.			2

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Gains the ability to learn the necessary concepts in the computer field.			2

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to identify, define, formulate and solve complex Information Security problems; for this purpose, the ability to select and apply appropriate analysis and modeling methods				3

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design a complex computer-based system, process, security to meet specific requirements under realistic constraints and conditions; for this purpose, the ability to apply modern design methods.		1

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to design, conduct experiments, collect data, analyze and interpret results for examining Information Security problems					4
2	Ability to work effectively within the discipline of Information Security and in multi-disciplinary teams; individual study skills		1
3	Professional and ethical responsibility awareness		1
4	Knowledge of project management and business practices such as risk management and change management; awareness of entrepreneurship, innovation and sustainable development			2

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to develop, select and use modern techniques and tools required for Information Security applications		1
2	Awareness of the necessity of lifelong learning; ability to access information, follow developments in science and technology, and constantly renew oneself		1

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Ability to communicate effectively in Turkish orally and in writing, foreign language knowledge		1

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Information about the effects of Information Security practices on health, environment and security in universal and social dimensions and the problems of the age; Awareness of the legal consequences of Information Security solutions		1

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	0	0	0
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	14	3	42
Reading	0	0	0
Assignment (Homework)	1	5	5
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	1	8	8
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	1	8	8
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	33	0	107