Course Program:
- Introduction to and basic concepts of database and database management systems
- The physical level of databases
- An overview of relational databases
- Relational algebra and relational calculus
- SQL data definition and manipulation language
- Logical design of relational databases
- Views
- Relational integrity rules
- Query optimization
- Recovery and concurrency in database
- Introduction to XML
- Introduction to deductive and object-oriented databases
Reference Books:
- "Fundamentals of Database Systems", Elmasri and Navathe, Addison Wesley
- "Database Management Systems", Ramakrishnan and Gehrke, McGraw Hill
- "Systems (The Complete Book)", Garcia-Molina, Ullman & Widom, Prentice Hall
Grading:
| Midterm 1 | %20 |
| Midterm 2 | %20 |
| Projects | %30 |
| Final | %30 |
Additional Material:
Projects:
- Design of a simple storage manager.
- Implementation of the simple storage manager.
- Design and implementation of a web based relational database using a commercialdatabase management system.
A grade of 50 from each project is required to pass the course.