VERİ TABANI YÖNETİM SİSTEMLERİ PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
TSP254	VERİ TABANI YÖNETİM SİSTEMLERİ	4	4	2	7

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 PINAR GENÇ
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	The aim of this course is to teach students database concepts, the structure and operating principles of database management systems; and to equip them with the theoretical knowledge and practical skills necessary for the efficient, secure, and consistent storage, management, and querying of data.
Contents of the Course Unit:	The course content includes: Introduction to Database Concepts, Database Management Systems (DBMS) and their Types, Relational Database Model, Non-Relational Database Model, Database Diagrams, Introduction to SQL Language, Data Selection (Select) with SQL, Data Update (Update) with SQL, Data Deletion (Delete) with SQL, Detailed Queries (JOIN, GROUP BY) with SQL, Database Design and Normalization, Database Security and Authorization, and Application Development.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
It explains database concepts.
It performs basic data querying operations using SQL.
It applies normalization techniques.
Develops a mid-level database application for healthcare purposes.

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	Written and Visual Resources	Introduction to the Concept of Databases	Lecture / Question - Answer
2	Written and Visual Resources	Database Management Systems (DBMS) and Their Types	Explanation / Video / Question - Answer
3	Written and Visual Resources	Relational Database Model	Explanation / Video / Question - Answer
4	Written and Visual Resources	Non-Relational Database Model – Quiz	Explanation / Video / Question - Answer
5	Written and Visual Resources	Database Diagrams	Explanation / Video / Question - Answer
6	Written and Visual Resources	Introduction to SQL Language	Explanation / Video / Practice / Question - Answer
7	Written and Visual Resources	Data Selection using SQL Language	Explanation / Video / Practice / Question - Answer
8	Written and Visual Resources	Updating Data Using SQL Language	Explanation / Video / Practice / Question - Answer
9	Written and Visual Resources	Deleting Data Using SQL – Quiz	Explanation / Video / Practice / Question - Answer
10	-	MID-TERM EXAM	-
11	Written and Visual Resources	Detailed Queries (JOIN, GROUP BY) in SQL Language	Explanation / Video / Practice / Question - Answer
12	Written and Visual Resources	Database Design and Normalization	Explanation / Video / Practice / Question - Answer
13	Written and Visual Resources	Database Security and Authorization – Practical Exam	Explanation / Video / Practice / Question - Answer
14	Written and Visual Resources	Application Development 1	Explanation / Video / Practice / Question - Answer
15	Written and Visual Resources	Application Development 2	Explanation / Video / Practice / Question - Answer
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems (7th ed.). Pearson.
Alp, S., Kilitci, A., & Özdemir, S. (2022). Veritabanı yönetim sistemleri (2. bs.). Türkmen Kitabevi.

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

Level of Contribution
0	1	2	3	4	5

KNOWLEDGE
Theoretical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	It explains the basic medical terminology, communication protocols, and health informatics concepts used in the field.						5
2	It explains the operating principles of fundamental information technologies, video communication tools, sensor systems, and remote monitoring equipment that form the basis of the profession.						5

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	This document explains the legislation regulating telehealth applications in Turkey, patient rights, data security, and legal requirements regarding the protection of personal data.						5
2	This document describes the scope, application areas, and clinical workflows of teleconsulting, telemedicine, telecare, and remote patient monitoring models.						5
3	It describes the functions, data types, information flow, and integration processes of electronic health record systems used in the field.						5

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	It collects data from software and devices used in its field and analyzes key metrics.						5
2	It describes technical problems that arise during remote patient monitoring.						5
3	It securely transmits patient data during tele-consulting and tele-care processes.						5

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	It applies basic triage, status assessment, and prioritization procedures for the services in its area according to relevant protocols.						5
2	It ensures that data is entered into electronic health record systems used in the practice of the profession accurately, completely, and in accordance with standards.						5
3	The student identifies potential occupational health and safety risks in work environments.						5

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	It offers solutions to increase the efficiency and workflow of the field and contributes to improvements in implementation processes.						5

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	By analyzing clinical and technical situations encountered in field applications, it determines appropriate procedural steps.						5

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	They use a foreign language to keep up with developments in their field and communicate with colleagues.						5

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	By evaluating remote patient monitoring data, it informs healthcare professionals when necessary if there are risky situations.						5
2	It offers solutions to increase the efficiency and workflow of the field and contributes to improvements in implementation processes.						5
3	It identifies data transfer errors, connection problems, or user-caused issues occurring in the devices and software of its field, and applies appropriate solutions.						5
4	In addition to checking the accuracy of measuring devices and digital monitoring tools used in professional services within their field, they also apply calibration or remeasurement processes when necessary.						5

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	4	56
Preliminary & Further Study	14	4	56
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	9	4	36
Reading	1	4	4
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	0	0	0
Mid-Term Exam	0	0	0
Preparation for the Mid-Term Exam	0	0	0
Short Exam	2	2	4
Preparation for the Short Exam	4	4	16
TOTAL	45	0	173