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.
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