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	6.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.
Recommended Reading List	\"Fundamentals of Database Systems\" by Ramez Elmasri, and Shamkant B. Navathe, Sixth Edition.\"Database Systems: The Complete Book\" by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, 2nd Edition.\"Database Management Systems\" by Raghu Ramakrishnan, and Johannes Gehrke
Assessment methods and criteria	There are 2 Midterms, 1 Final, and a Term-Project.
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

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 (%)
1.Midterm Exam	1	15
Quiz	1	10
Project	1	35
Final Exam	1	40
Toplam (%)		100