bbm471 - database management systems

“ You may not be interested in databases, but databases are interested in you. ” - Trotsky

course description

This is a course on database systems that is intended for advanced (3rd or 4th year) undergraduates in computer science. The course offers an introduction to database system concepts in general, particularly relational database design, terminology and techniques to create and modify database management systems(DBMS). Relational algebra, use of SQL query language and transaction management will be covered in detail.

In the end of the course, the students are expected to gain an in-depth understanding on how the databases are designed, queried and maintained.

Prerequisites: While not mandatory, it is recommended that the students take BBM 371 prior to BBM 471. In addition, the students are expected to have a sound knowledge of data structures and algorithms.

course logistics

Instructor: Nazli Ikizler Cinbis , nazli -at- cs.hacettepe.edu.tr

Office: 112, Office Hours: Wednesdays 13:30-14:30

Lecture Hours: Wednesdays 09:30-12:15

Lecture Room: D8

textbooks

Main textbook

Database Management Systems, by Raghu Ramakrishnan and Johannes Gehrke, 3rd Edition, 2002.

Not required, but strongly suggested

Database System Concepts, A. SilberSchatz, H. Korth and S. Sudarshan, 6th edition, 2010.
Database Systems, The Complete Book, by H. Garcia Molina, J. Ullman, J Widom, 2nd edition, 2008.
Veritabani Sistemleri, Unal Yarimagan, 2000.

grading policy

Quizzes and class participation : %10
Midterm exam 1 : %25
Midterm exam 2 : %25
Final exam : %40

Communication:

The course webpage will be updated regularly throughout the semester with important deadlines. All other communications, including the lecture notes will be carried out through Piazza system:
Piazza website for bbm471 course

schedule (tentative)

Date	Topic	Slides	Readings
October 2nd	Introduction to databases and database management systems	.ppt
October 9th	Entity-Relationship Model	.ppt
October 16th	No class - Religious Holiday
October 23rd	Relational Model	.ppt
October 30th	Relational Algebra	.ppt
November 6th	SQL	.ppt
November 13th	Midterm Exam - 1
November 20th	Advanced SQL	.ppt
November 27th	Normalization	.ppt
December 4th	Transaction Management	.ppt
December 11th	Midterm Exam - 2
December 18th	Concurrency Control	.ppt
December 25th	Recovery	.ppt
January 1st	No Class

useful links

Academic Integrity: The students are expected to strictly adhere to the academic integrity policy of the Department, act honestly and respect the rights of the others in carrying out all academic assignments. Academic dishonesty, including cheating, fabrication and plagiarism will not be tolerated. Unless stated otherwise, all the work on the assignments must be carried out individually. While the discussions over the general concepts about the course are allowed, discussions related to a particular solution to a specific problem, (actual or pseudo) code sharing are strictly forbidden. Using assistance from the internet without providing proper citation is also considered as violation of the academic integrity. Note that, all the aforementioned violations to academic integrity policy are subject to disciplinary action.