TYPE OF COURSE UNIT	Elective Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	-
SEMESTER	-
NUMBER OF ECTS CREDITS ALLOCATED	5
NAME OF LECTURER(S)	Assistant Professor Serdar Engin Koç
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Will be able to understand the concept of database and its' main features, 2) Will be able to understand and schematize the entity-relations model, 3) Will be able to transfer the schematized the entity-relations model into SQL environment, 4) Will be able to understand SQL comments, complex inquires an relationships, 5) Will be able to design and develop complex database systems.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	BÖTE354 Database Management Systems
COURSE DEFINITION	Learning the structure and implementation of most common languages in the field of database programming ORACLE, DB2, SQL Server and My SQL. File concept and the storage units of modern computers. Hashing, sequential files, query system, relational discreet mathematics, relational calculations, entity-relation data model, administration of database systems
COURSE CONTENTS	WEEK TOPICS 1st Week Introduction and Hardware Parameters 2nd Week Hardware Parameters 3rd Week Fundamental File Structure Concepts: Sequential Files 4th Week Fundamental File Structure Concepts: Sequential Files 5th Week External Sorting 6th Week External Sorting 7th Week Project 8th Week Midterm 9th Week Direk Erişim: Hassing 10th Week Direk Erişim: Hassing 11th Week Dosya İndeksleme Teknikleri: B-Trees 12th Week Dosya İndeksleme Teknikleri: B-Trees 13th Week Proje 14th Week Proje
RECOMENDED OR REQUIRED READING	1) Bety Salzberg, file Structures: An Analytic Approach, prentice Hall, 1988 2) Alan Tharp, File Organizations and Processing, John Wiley, 1988
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Practice,Project
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 20 Practice 2 15 Project 2 30 Other 1 15 Total(%) 80 Contribution of In-term Studies to Overall Grade(%) 80 Contribution of Final Examination to Overall Grade(%) 20 Total(%) 100
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No