Quick Links

• General:
  
  Course Information/Syllabus (PDF)
  Guidelines for All Assignments (PDF)
  An approximate schedule of lectures
  
  
• Practise exercises:
  
  Practise 1 (PDF) (PS)
  Practise 2 (PDF) (PS)
  Practise 3 (PDF) (PS)
  Practise 4 (PDF) (PS)
  
  
• Book web page:
  
  A Web home page for the book is available here.
  
  
• Lecture notes:
  
  

  Lectures			2-3-4/4 per page			Sections in book
  Num/Name	HTML	PDF	PDF	PS	PPT	Readings
  Presentation of the course		PDF
  1 - Introduction (slides of the book)		PDF	2PDF		PPT	Ch 1 - Introduction
  1 - Introduction (new slides)		PDF	4PDF			Ch 1 - Introduction
  2 - Sets and relations		PDF	4PDF
  3 - E-R model		PDF	4PDF			Ch 2 - pages 25-62
  4 - To be continued		PDF	4PDF	4PS
  5 - Relational model		PDF	4PDF	4PS		Ch 3 - pages 79-117
  6 - SQL		PDF	4PDF	4PS		Chapter on SQL in the book
  7 - How to use Borland Interbase?		PDF		PS
  8 - Aggregates in SQL					PPT

  
  
  

  
  
  References for the lecture notes: Professor Art Bernstein (Suny Stony Brook).
  
  
• Additional books:
  
  
  • Database and Transaction Processing: An Application-Oriented Approach - Philip M. Lewis, Arthur Bernstein, Michael Kifer (Addison-Wesley)
  • Database Management Systems - Ramakrishnan (McGraw-Hill) Fundamentals of Database Management Systems - Elmasri and Navathe (Addison Wesley)

• Software references:
  
  
  • Databases
    • Interbase
  • SQL
    • SQL tutorial
  • JAVA
    • Python Reference Manual
    • Java Class Hierarchy
    • THE JAVA Language Specification
    • http://www.javasoft.com/
    • Java Books on Line
    • The Java Tutorial
  • JDBC
    • Sunsoft JDBC Homepage
    • JDBC Enhancements
    • The JDBC Specification
    • JavaSoft's JDBC API specification