CS448: Introduction to Database Systems

Home | Syllabus | Schedule | Homework, Projects, & Handouts | Announcements
_______________________________________________________________________________________________________________________

Schedule

Important Dates

• Midterm exam: Oct.5 (Wednesday) 2016, 8pm - 9:30pm (20:00 - 21:30) LWSN B155 .

• Final exam:   TBD  

Slides (PDF of all PPT slides is here )

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)

• Hierarchial model-chapter

  • Hierarchical model-slides

•  Network model-chapter

  •  Network model-slides

Chapter 5 - The Relational Data Model Relational Database Constraints (ppt)

• Handout on Natural and Outer Joins & Relational Calculus

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

• PL/SQL Tutorial

Chapter 10 - Functional Dependencies and Normalization for Relational Databases (ppt)

Chapter 11 - Relational Database Design Algorithms and Further Dependencies (ppt)

• Example of proving loss less join

•  Normalization and lossless joins and FD preservations

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)

• Concurrency Control in Database Systems Bharat Bhargava, IEEE Trans on Knowledge and Data Engineering,11(1), Jan.-Feb. 1999

• The Transaction Concept: Virtues and Limitations , Jim Gray, VLDB, 1981.

Chapter 18 - Concurrency Control Techniques (ppt)

Chapter 19 - Database Recovery Techniques (ppt)

Chapter 23 - Database Security and Authorization (ppt)

• Secure_data_warehouse-Privacy

Chapter 24 - Enhanced Data Models for Advanced Applications (ppt)

Chapter 25 - Distributed Databases and Client-Server Architectures (ppt)

•  Introduction to Cloud Computing

• Privacy and Identity Management in Cloud Computing

• Complete Tutorial

Chapter 26 - Web Database Programming using PHP (ppt)

Chapter 27 – XML-Extensible Markup Language (ppt)

Chapter 29 - Overview of Data Warehousing and OLAP (ppt)

Chapter 30 - Emerging Database Technologies and Applications (ppt)