Akademik Dersler - Tanıtım


Code - Course Title	BİM216 - Database Management Systems
Course Type	Required Courses
Language of Instruction	İngilizce
Laboratory + Practice	2+2
ECTS	5.0
Course Instructor(s)	DOKTOR ÖĞRETİM ÜYESİ BURCU YILMAZEL
Mode of Delivery	The mode of delivery of this course is Face to face.
Prerequisites	There is no prerequisite or co-requisite for this course.
Courses Recomended	None.
Required or Recommended Resources	Fundamentals of Database Systems by Ramez Elmasri and Shamkant B. Navathe, Sixth Edition.
Recommended Reading List	* Database Systems: The Complete Book by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom.* Database Management Systems by Raghu Ramakrishnan, and Johannes Gehrke
Assessment methods and criteria	1 Midterm exam (test), Quizzes (classic), 1 Term-Project, and 1 Final (test)
Work Placement	Students as a group are expected to design and implement a database project that they can come across in many areas of daily life.
Sustainability Development Goals	Quality Education , Industry, Innovation and Infrastructure

Weeks	Topics
Week - 1	Introduction to Databases and Database Management Systems
Week - 2	The Relational Model of Data & Database Design Process
Week - 3	The Entity-Relationship (E/R) Model
Week - 4	Advanced E/R Concepts
Week - 5	From E/R Diagrams to Relational Schema
Week - 6	Schema Refinement - Functional Dependencies
Week - 7	Schema Refinement - Normalization & Normal Forms
Week - 8	SQL Basics: Part I
Week - 9	SQL Basics: Part II
Week - 10	Relational Algebra & Query Optimization
Week - 11	More on SQL: View, Trigger, Index, Authorization & Security Design
Week - 12	Physical Schema: Storage & File Organization
Week - 13	Transactions
Week - 14	Term Project Presentations

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