1	Course Title:	DATA BASE I
2	Course Code:	BLPZ117
3	Type of Course:	Compulsory
4	Level of Course:	Short Cycle
5	Year of Study:	1
6	Semester:	1
7	ECTS Credits Allocated:	5
8	Theoretical (hour/week):	3
9	Practice (hour/week) :	0
10	Laboratory (hour/week) :	1
11	Prerequisites:
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Öğr.Gör. HATİCE ÇAVUŞ
16	Course Lecturers:	Öğr. Gör. Hatice ÇAVUŞ
17	Contactinformation of the Course Coordinator:
18	Website:
19	Objective of the Course:	Create new databasae and analize data structure and Query , select from a table and relational database and reporting data.
20	Contribution of the Course to Professional Development

21

Learning Outcomes:

1 At the end of this course, students must be able to develop a database application starting with the conceptual design leading to logical and physical designs. ; 2 Students must be competent in relational model and SQL. ; 3 They are also expected to know the internals of the Database ; 4 Management Systems including Concurrency control. ; 5 SQL Parsing and transaction management. ; 6 To supply the students with the theory and practice of database management systems and development. ; 7 Students can write SQL query and parsing. ; 8 Able to run relational database query .; 9 Group and function based query write.;

22	Course Content:

Week	Theoretical	Practical
1	İntroduction to Database. Relational model and algebra Database design: E/R model Database design: E/R and relational translation
2	Relational model and algebra , Database design: E/R model
3	Database design: E/R and Relational database Design
4	Database design: E/R and Database Desing Teory
5	Database Setup and Create Database
6	Sql- CREATE : Basics, l translation subqueries,aggregates.
7	Sql: Constraints, triggera,views
8	Sql: İndexes, transactions Examples
9	Mid Term
10	-NULL, outerjoin, modifications
11	-indexes, transactions Examples
12	SQL:programming
13	Sql:Recursion
14	More database design theory; warehousing and mining

23	Textbooks, References and/or Other Materials:	Database Menagement System Prof. Dr. Zehra Alakoç Burma
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	25
Quiz	1	25
Homeworks, Performances	0	0
Final Exam	1	50
Total	3	100
Contribution of Term (Year) Learning Activities to Success Grade		50
Contribution of Final Exam to Success Grade		50
Total		100
Measurement and Evaluation Techniques Used in the Course
Information

25

ECTS / WORK LOAD TABLE

Activites	NUMBER	TIME [Hour]	Total WorkLoad [Hour]
Theoretical
Practicals/Labs
Self Study and Preparation
Homeworks, Performances	0
Projects
Field Studies
Midtermexams
Others
Final Exams
Total WorkLoad
Total workload/ 30 hr
ECTS Credit of the Course

26	CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High