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)