BIL344 - DATABASE SYSTEMS
2024 Spring

Course Description
The main objective of this course is to provide students with an in-depth understanding of the concepts and techniques of database systems. The topics include history and motivation for database systems, components of database systems, database architecture and data independence, the relational model, mapping conceptual schema to a relational schema, referential integrity, relational algebra and relational calculus, database query languages (SQL), database design, functional dependency and normal forms, transaction management, and query evaluation.

Attendance: A minimum of 70% attendance to the lecture and laboratory hours is compulsory. Violation of this rule will result in an F2 grade.
 Download 1-page version of the course syllabus

Instructor: Mustafa Sert
Assistant: Begum Erkal, Elif Nur Haner, Halise Nur Aydin

Grading Policy

  • Midterm Exam: 25%
  • Final Exam: 35%
  • Quizzes: 20% (in-class)
  • Practice: 20% (Practice performance: 10%, HW1: 3%, HW2: 7%)

Main and Recommended Texts

  • Database Management Systems, Ramakrishnan & Gehrke, Mc Graw Hill. (textbook)
    Main Text Book
  • Database System Concepts, 6/e, A. Silberschatz et al., Mc Graw Hill [LECTURE SLIDES] (optional)

    • Main Text Book
  • Database Systems: The Complete Book, Garcia-Molina et al., Prentice Hall.  (optional)
  • Fundamentals of Database Systems, Elmasri & Navathe, Addison Wesley. (optional)

Resources
We will be using the following CASE tool for modeling issues through the course:

Başkent University is provided with the use of VP for educational purpose by the Academic Partner Program from Visual Paradigm.

Download and install VP from  [BIL344@oys.baskent.edu.tr]

Weekly Course Schedule

You can download lecture slides from [HERE]
Week Topic LAB/HW
Schedule		 Resources
(Use the BIL344@OYS for detailed and updated version of this schedule..)
1 Introduction to database systems concepts and principles Follow the BIL344@OYS for details..
2 Entity Relationship (ER) and Enhanced ER Model LAB1: database design (EER)
HW1: You will be given a database design problem		  
3 Relational Data Model and Integrity Constraints LAB2: SQL-DDL (CRUD operations)  
4 Relational Algebra LAB3: SQL-DML (data insert, update, delete, data loading)
5 Structured Query Language (SQL) – DDL subset of SQL LAB4: SQL-DML (basic select queries)
6 Structured Query Language (SQL) – DML subset of SQL LAB5: SQL-DML (select queries w/joins)
7 View, Triggers, Stored Procedures LAB6: SQL-DML (select queries w/group-by/having/aggregate operators )
8 Midterm Exam Week (subject to change according to Faculty regulations)
9 Dependency theory and normalization LAB QUIZ: SQL DDL&DML
10 Normal Forms and decomposition LAB7: Views & Triggers & Stored Procedures
11 Storage and file structures HW2: Programming
12 Indexing  
13 Overview of transaction management  
14 Course summary