CS348: Information Systems
Home | Syllabus | Schedule & Lecture Slides | Homework, Projects, & Handouts | Announcements
________________________________________

Schedule
Important Dates
      Midterm exam: Oct 7 at 8:00-10:00pm in WTHR 172.
      Final exam: Tue 12/15 10:30a - 12:30p WTHR 104

Slides
The index of each slide corresponds with the associated chapter in the textbook.
Chapter 1 - Introduction (ppt)
Chapter 2 -Database System Concepts and Architecture (ppt)
Chapter 3 - Data Modeling Using the Entity Relationship (ER) Model (ppt)
Chapter 4 - Enhanced Entity-Relationship (EER) Modeling (ppt)
Chapter 5 - The Relational Data Model Relational Database Constraints (ppt)
Chapter 6 - The Relational Algebra and Calculus (ppt)
Chapter 7 - Relational Database Design by ER-and EERR-to-Relational Mapping (ppt)
Chapter 8 - SQL-99: Schema Definition, Constraints, and Queries and Views (ppt)
Chapter 9 - Introduction to SQL Programming Techniques (ppt)  (JDBC Tutorial) )  (SQL Tutorial)   (PL/SQL Tutorial)
Chapter 10 - Functional Dependencies and Normalization for Relational Databases (ppt)
Chapter 11 - Relational Database Design Algorithms and Further Dependencies (ppt)
Chapter 12 - Practical Database Design Methodology and Use of UML Diagrams(ppt)
Chapter 13 - Disk Storage, Basic File Structures and Hashing (ppt)
Chapter 14 - Indexing Structures for Files (ppt)
Chapter 15 - Algorithms for Query Processing and Optimization (ppt)
Chapter 16 - Practical Database Design and Tuning (ppt)
Chapter 17 - Introduction to Transaction Processing Concepts and Theory (ppt)
Chapter 18 - Concurrency Control Techniques (ppt)
Chapter 19 - Database Recovery Techniques (ppt)
Chapter 20 - Concepts for Object Databases (ppt)
Chapter 21 - Object Database Standards, Languages, and Design (ppt)
Chapter 22 - Object-Relational and Extended-Relational Systems (ppt)
Chapter 23 - Database Security and Authorization (ppt)
Chapter 24 - Enhanced Data Models for Advanced Applications (ppt)
Chapter 25 - Distributed Databases and Client-Server Architectures (ppt)
Chapter 26 - Web Database Programming using PHP (ppt)
Chapter 27 – XML-Extensible Markup Language (ppt)
Chapter 28 -
Chapter 29 - Overview of Data Warehousing and OLAP (ppt)
Chapter 30 - Emerging Database Technologies and Applications (ppt)