COMPUTER PROGRAMMING (TURKISH)
Associate	TR-NQF-HE: Level 5	QF-EHEA: Short Cycle	EQF-LLL: Level 5

Course Introduction and Application Information

Course Code	Course Name	Semester	Theoretical	Practical	Credit	ECTS
BPR1009	Database I	Fall	1	2	2	5

Basic information

Language of instruction:	Turkish
Type of course:	Must Course
Course Level:	Associate (Short Cycle)
Mode of Delivery:	Face to face
Course Coordinator :	Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN
Course Lecturer(s):	Dr. Öğr. Üyesi ÖZGÜR ERKUT ŞAHİN Instructor BARIŞ ERDOĞAN Instructor DOĞAN AYDIN Instructor KEMAL YILDIRIM
Recommended Optional Program Components:	There is no Recommended Optional Program Components
Course Objectives:	This course covers fundamentals of database design and architecture, database queries, and database management systems. Principles and methodologies of database design, and techniques for database application development.

Learning Outcomes

The students who have succeeded in this course;
1)Database Design
2)Database Table Design
3)Database Queries
4)Database Management Functions

Course Content

The administrator of a database should be able to fullfil database inner operations, setup a full database using MySQL ,designing and planning a database using SQL commands/applications.

Weekly Detailed Course Contents

Week	Subject	Related Preparation
1)	Database Needs Analysis
2)	Entity Relationship Diagrams
3)	Entity Relationship Diagrams
4)	Normalization
5)	Installation of Database Tools Construct Tables and identify properties of tables
6)	Construct Tables and identify properties of tables
7)	Construct Queries
8)	Construct Queries. Relational Tables and Queries
9)	Construct Queries
10)	DML Queries
11)	DML Queries and User queries
12)	View Queries Triger Queries
13)	Triger Queries and subqueries
14)	Transaction Operations Index queries

Sources

Course Notes / Textbooks:	Yaşar DEMİR. Veri Tabanı Yönetim Sistemleri. Türkmen Kitabevi, 2004
References:	Dr.Yalçın Özkan.Veri Tabanı Sistemleri. ALFA. 2006

Evaluation System

Semester Requirements	Number of Activities	Level of Contribution
Quizzes	1	% 20
Midterms	1	% 25
Final	1	% 55
Total		% 100
PERCENTAGE OF SEMESTER WORK		% 45
PERCENTAGE OF FINAL WORK		% 55
Total		% 100

ECTS / Workload Table

Activities	Number of Activities	Duration (Hours)	Workload
Course Hours	14	4	56
Application	14	2	28
Study Hours Out of Class	14	3	42
Quizzes	1	1	1
Midterms	1	1	1
Final	1	1	1
Total Workload			129

Contribution of Learning Outcomes to Programme Outcomes

No Effect	1 Lowest	2 Low	3 Average	4 High	5 Highest

	Program Outcomes	Level of Contribution
1)	Students will have knowledge of fundemantals of mathemetaics and phsics	5
2)	Students will have konowledge of relevant software and hardware requirements in the office environment	4
3)	Having the ability to define and explain the fundemental concepts, principles and essentilas of software and having the ability to develop software.	5
4)	Having the ability to use tools, machines and having the ability to recognize and diagnose problems in the related computer fields.	1
5)	Having the ability to communicate efficiently in verbal and written Turkish, to know at least one foreign language in order to communicate with the colleagues and customers.	4
6)	Having the ability to setup,diagnose and maintanance of databases	5
7)	Having the ability to design graphical animations for desktop applications and internet programming.
8)	Having the ability to develop and control internet projects	5
9)	Having the ability to develop group projects, team work, software and hardware projects	3
10)	Having the ability to set up,diagnose operating systems and network systems	3