• Syllabus   < pdf >
• Part 1: Introduction and Conceptual Modeling  
  • Databaes and Database Users   < ppt >
  • Databaes System Concepts and Architecture   < ppt >
  • Data Modeling Using the Entity-Relationship (ER) Model   < ppt >
  • The Enchanced Entity-Relationship (EER) Model   < ppt >

• Part 2: Relational Model: Concepts, Constraints, Languages, Design, and Programming  
  • The Relational Data Model and Relational Database Constraints   < ppt >
  • The Relational Algebra and Relational Calculus   < ppt >
  • Relational Database Design by ER- and EER-to-Relational Mapping   < ppt >
  • SQL-99: Schema Definition, Constraints, Queries, and Views   < ppt >
  • Introduction to SQL Programming Techniques   < ppt >

• Part 3: Database Design Theory and Methodology  
  • Functional Dependencies and Normalization for Relational Databases   < ppt >
  • Relational Databases Design Algorithms and Further Dependencies   < ppt >
  • Practical Database Design Methodology and Use of UML Diagrams   < ppt >

• Part 4: Database Storage, Indexing, Query Processing and Physical Design  
  • Disk Storage, Basic File Structures, and Hashing   < ppt >
  • Indexing Structures for Files   < ppt >
  • Algorithms for Query Processing and Optimzation   < ppt >
  • Physical Database Design and Tuning   < ppt >

• Part 5: Transaction Processing Concepts  
  • Introduction to Transaction Processing Concepts and Theory   < ppt >
  • Concurrency Control Techniques   < ppt >
  • Database Recovery Techniques   < ppt >

• Part 6: Object and Object-Relational Databases  
  • Concepts for Object Databases   < ppt >
  • Object Database Standards, Languages, and Design   < ppt >
  • Object-Relational and Extended-Relational Systems   < ppt >

• Part 7: Further Topics: Security, Advanced Modeling and Distribution  
  • Further Topics: Security, Advanced Modeling, and Distribution   < ppt >
  • Enhanced Data Models for Advanced Applications   < ppt >
  • Distributed Databases and Client-Server Arechitectures   < ppt >

• Part 8: Emerging Technologies  
  • Web Database Programming using PHP   < ppt >
  • XML: Extensible Markup Language   < ppt >
  • Data Mining Concepts   < ppt >
  • Overview of Data Warehousing and OLAP   < ppt >
  • Emerging Database Technologies and Applications   < ppt >

• Homework
  • Program 1 < Description >
  • Exercise 1 < Chapters 1-2, 13 exercises >
  • Program 2 < Description >

• Term project

• Announcements for Fall 2008
  • September 2, 2008
  • September 17, 2008
  • September 27, 2008
  • October 6, 2008
  • October 15, 2008
  • October 20, 2008
  • November 3, 2008

• Additional instructor's notes
  • file I/O
  • hash header file,   hash file,   safe input
  • Disk performance parameters
  • Brief Linear Hashing insert algorithm
  • 3-valued logic tables
  • Cross join examples

• MySQL Documents
  • MySQL 5.1 Reference Manual
  • MySQL by Paul DuBois

• To view source programs --> click here

• To view exercise solutions --> click here