DATABASE MANAGEMENT SYSTEMS I PROGRAMME COURSE DESCRIPTION

Code	Name of the Course Unit	Semester	In-Class Hours (T+P)	Credit	ECTS Credit
CMP151	DATABASE MANAGEMENT SYSTEMS I	1	3	3	5

GENERAL INFORMATION
Language of Instruction :	English
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 ADNAN KÜRŞAT TEKE
Instructor(s) of the Course Unit	Assist.Prof. DENİZ DAHMAN
Course Prerequisite	No

OBJECTIVES AND CONTENTS
Objectives of the Course Unit:	It aims to be able to organize data in a computer environment, design structural database models, secure and effective acceptance of data, processing of data and providing competence in reporting data.
Contents of the Course Unit:	Data and organization - Recognition of existing database technologies - Data model design - Database normalization - Data entry, Modification, Destruction, Reporting operations and batch operations.

KEY LEARNING OUTCOMES OF THE COURSE UNIT (On successful completion of this course unit, students/learners will or will be able to)
Designing a Database
Creating a Database
Querying a Database
Using Database Administrative Functions

WEEKLY COURSE CONTENTS AND STUDY MATERIALS FOR PRELIMINARY & FURTHER STUDY
Week	Preparatory	Topics(Subjects)	Method
1	Literature research	Data and Database Concepts, Needs Analysis	Expression
2	Research	Data Models, Entity Relationship Diagram	Expression
3	Research	Normalization	Application
4	Research	Installing Database Tools, Creating Tables and Specifying Properties	Application
5	Research	Creating Tables and Specifying Properties	Application
6	Research	Create Query and Using The Type	Application
7	Research	Creating Query and Using Its Types, Preparing Query with Related Tables	Application
8	-	MID-TERM EXAM	-
9	Research	Preparing Query with Related Tables	Application
10	Research	Using DML Queries	Application
11	Research	Using DML Queries, Writing User Queries	Application
12	Research	Writing View Queries, Writing Trigger Queries	Application
13	Research	Writing Subprogram Queries, Making Transactions	Application
14	Research	Writing Index Queries	Application
15	Research	Database Security and Backup	Application
16	-	FINAL EXAM	-
17	-	FINAL EXAM	-

SOURCE MATERIALS & RECOMMENDED READING
Yazılımcılar İçin SQL Server 2012 ve Veritabanı Programlama, Yaşar Gözüdeli, Seçkin Yayıncılık

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	Computer concepts, methods and the software would dominate.				3
2	Recognizes the basic functions of hardware.	0
3	Recognize personal and network operating systems.	0
4	Ethics related to the profession, oversees the health and safety measures.			2
5	Have adopted the philosophy of total quality and technical elements that could support institutional processes become.			2

KNOWLEDGE
Factual
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Hardware makes the process of discovery and establishment.	0
2	Explains data management processes.			2
3	Explains different areas where software languages are used.			2

SKILLS
Cognitive
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Software (PC, network and Internet environment) are involved in planning and design.				3
2	Professional in the field of algorithmic thinking to find solutions to deal with problems that will arise.				3
3	Use math skills in vocational areas.				3

SKILLS
Practical
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Word processor, spreadsheet, presentation, database, and graphics-based design of programs you install and use.						5
2	Are given the chance to apply theoretical issues.					4

OCCUPATIONAL
Autonomy & Responsibility
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Detects common software and hardware failures, produce solutions to problems.			2
2	Measures related to data security and storage space and become individuals find appropriate solutions.					4
3	Fault finding, problem solving, decision-making and planning processes become competent in the subjects.				3

OCCUPATIONAL
Learning to Learn
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	They can learn and put into practice what they learned fast.			2
2	With the basic knowledge learned in the training process of learning and innovation that exists will have the ability to develop them.					4

OCCUPATIONAL
Communication & Social
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Except of course in the section related to their field of study clubs that exist in the industry to meet and communicate with the companies they have a chance.	0

OCCUPATIONAL
Occupational and/or Vocational
	Programme Learning Outcomes	Level of Contribution
		0	1	2	3	4	5
1	Department students and programming, web design and technical courses will increase their chances to opt for.				3
2	Programming courses enables students to develop new programs and projects that they produce their own applications gain competence.					4
3	Some small or medium-sized companies take the role of management and leadership.		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	14	3	42
Land Surveying	0	0	0
Group Work	0	0	0
Laboratory	0	0	0
Reading	0	0	0
Assignment (Homework)	3	5	15
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	14	1	14
Mid-Term Exam	1	1	1
Preparation for the Mid-Term Exam	7	1	7
Short Exam	0	0	0
Preparation for the Short Exam	0	0	0
TOTAL	54	0	122