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
VTK152	VERİTABANI YÖNETİM SİSTEMLERİ	2	3	3	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 NACİYE MACİT SEZİKLİ
Instructor(s) of the Course Unit
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	The aim is to enable students to organize data in a computer environment, design structured database models, and acquire the skills to securely and efficiently accept, process, and report data.
Contents of the Course Unit:	- Data and organization - Understanding current database technologies - Designing data models - Database normalization - Data entry, modification, deletion, and reporting operations - Batch processing

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Designing, Creating, and Querying Databases
Veritabanını Oluşturmak
Veritabanında Sorgulama Yapmak

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	Researching the topic online	Filing Systems, Data, Information, and Database Concepts	Presentation, Application
2	Researching the topic online	Database Management Systems, Database Models, Models, Database Architectures	Presentation, Application
3	Researching the topic online	Data Modeling Stages, Entity Relationship Diagram	Presentation, Application
4	Researching the topic online	Normalization	Presentation, Application
5	Researching the topic online	Creating Tables, Defining Their Properties, and Entering Data into Tables	Presentation, Application
6	Researching the topic online	Using DDL Queries	Presentation, Application
7	Researching the topic online	Installing Database Tools, Creating Tables, and Defining Their Properties	Presentation, Application
8	Researching the topic online	Using DDL Queries	Presentation, Application
9	Researching the topic online	Using DDL Queries	Presentation, Application
10	-	MID-TERM EXAM	-
11	Researching the topic online	Using DDL Queries	Presentation, Application
12	Researching the topic online	Using DDL Queries	Presentation, Application
13	Researching the topic online	Using DDL Queries	Presentation, Application
14	Researching the topic online	Subprogram Queries, Transaction Operations	Presentation, Application
15	Researching the topic online	Database Backup and Export	Presentation, Application
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
SQL Server 2012 and Database Programming for Software Developers, Yaşar Gözüdeli, Seçkin Publishing

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	Bilgisayarın temel kavram ve yazılımlarına hâkim olur.						5

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Have a command of the concepts commonly used in web design.						5

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Planning the code part of a website by having knowledge of algorithms It does.						5

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Visualization of the visual part of Web sites using visual design principles makes the planning.						5

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Observes ethical, health and safety measures related to the profession.						5

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Knows different methods of preparing a website.						5

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Can run web sites integrated with database management systems.						5

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	It may collect information about user experiences. Target with the information it collects can manage a website suitable for the audience. Can ensure basic security of websites.						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	3	42
Preliminary & Further Study	0	0	0
Land Surveying	0	0	0
Group Work	5	3	15
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	0	0	0
Project Work	14	3	42
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	1	1	1
Preparation for the Mid-Term Exam	0	0	0
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	35	0	101