ISE 305 DATABASE SYSTEMS
2006-2007 SPRING TERM
Contact Information:
| CRN | 23322 |
| Instructor: | Asst. Prof. Dr. Şule Gündüz Öğüdücü |
| Office: | EEB 3305 |
| e-mail: | sgunduz at itu.edu.tr |
| TA: | Sanem Sarıel |
| Class Room: | EEB 1305 |
| Class Hours: | Monday 10:00-12:59 |
Textbook:
Chris J. Date
An Introduction to Database SystemsAddison-Wesley, 2004, ISBN 0-321-19784-4
Other References:
Database Management
Systems
, Raghu Ramakrishnan, Johannes Gehrke, McGraw-Hill,
2002, ISBN 0072465638.
Practical
PostgreSQL
, John Worsley, Joshua Drake, O'Reilly, 2002, ISBN
1565928466.
Theory and Practice
of Relational Databases
, Stefan Stanczyk, Bob Champion, Richard Leyton,
Taylor & Francis, 2001, ISBN 0415247020.
A
First Course in Database Systems
, Jeffrey D. Ullman, Jennifer Widom,
Prentice-Hall, 2001, ISBN 0130353000.
Topics: The following table gives a tentative lecture schedule for the course.
| Week | Date | Topic | Exercise |
| 1 | Feb. 05,2007 | Introduction | PHP - 1 |
| 2 | Feb. 12,2007 | Relational Model | PHP - 2 |
| 3 | Feb. 19,2007 | Integrity | PHP - 3 |
| 4 | Feb. 26,2007 | Relational Algebra | PHP -4 |
| 5 | Mar. 05,2007 | SQL | SQL |
| 6 | Mar. 12,2007 | Database Design | Project Meeting |
| 7 | Mar. 19,2007 |
Exercise |
|
| 8 | Mar. 26,2007 |
Midterm Exam |
|
| 9 | Apr. 02,2007 | Concurrency | Concurrency |
| 10 | Apr. 09,2007 | Application Development | Application Development |
| 11 | Apr. 16,2007 | Query Optimization | Project Meeting |
| 12 | Apr. 23,2007 |
Holiday |
|
| 13 | Apr. 30,2007 | Object Oriented Databases | Object Oriented Databases |
| 14 | May 07,2007 |
Project Presentation - Project Demo |
|
Lecture Notes:
Project:
Develop a small real-world relational database application using MySQL and PHP. For detailed information: http://www.ninova.itu.edu.tr/
Other Resouces:
Grading:
| Midterm Exam |
25% |
| Project |
30% |
| Final Exam |
45% |