Akademik Dersler - Tanıtım


Code - Course Title	BİL551 - Advanced Database Management Systems
Course Type	Required Courses
Language of Instruction	Türkçe
Laboratory + Practice	3+0
ECTS	7.5
Course Instructor(s)	DOKTOR ÖĞRETİM ÜYESİ BURCU YILMAZEL
Mode of Delivery	Formal.
Prerequisites	There is no prerequisite or co-requisite for this course.
Courses Recomended	None.
Required or Recommended Resources	None.
Recommended Reading List
Assessment methods and criteria	Exam, Homework and Project.
Work Placement	None.
Sustainability Development Goals

Weeks	Topics
Week - 1	Introduction: Basic consepts of DBMS.
Week - 2	Data models, schemas, and instances. DBMS architecture.
Week - 3	Data modeling using Entity-Relationship model. Examples.
Week - 4	Record storage and file organization methods.
Week - 5	Operations on files. Hashing techniques.
Week - 6	Operations on files. Hashing techniques.
Week - 7	Relational model concepts and Relationel algebra.
Week - 8	The structure of SQL. Data definition, constrains, and schema changes in SQL.
Week - 9	Creating queries in SQL. Examples.
Week - 10	Functional dependecies and normalization for relational DBs.
Week - 11	Functional dependecies and normalization for relational DBs.
Week - 12	Query processing and transaction processing concepts.
Week - 13	Query processing.
Week - 14	Distributed databases and Client-Server architecture.

Assessment Method and Passing Requirements
	Quamtity	Percentage (%)
Toplam (%)		0