Week 2 : (Aug/28/2012)
Logical Database Design:
Chapter 2 : Database Design 101 : ER Modeling.
(ppt).
Chapter 2 : Discussion/Examples.
(ppt).
Chapter 2 : Some Guidelines.
(ppt).
Week 3 : (Sep/4/2012 and Sep/6/2012)
Database Model and Design:
Chapter 3 : Introduction to Relational Data Model.
(ppt).
Chapter 3 : Mapping from ER to Relational Model.
(ppt).
Week 4 : (Sep/11/2012 and Sep/13/2012)
Database Modeling and Design:
Chapter 3 : ER-to-RDB Mapping for IS-A Hierarchies:
(ppt).
Database Querying:
Chapter 4 : The Relational Algebra.
(ppt).
Information on Oracle 101.
ppt-101
More Information on Oracle 102.
ppt-102.
Week 5 : (Sep/18/2012 and Sep/20/2012)
Database Querying:
Chapter 4 : The Relational Algebra.
(ppt).
Chapter 5. SQL (SPJ Clause).
(ppt)
Week 6 : (Sep/25/2012 and Sep/27/2012)
Chapter 5. SQL (Nested SPJ SubQueries).
(ppt)
Chapter 5. SQL (GroupBy and Joins).
(ppt)
Week 7 : (Oct/2/2012 and Oct/4/2012)
Chapter 5. Constraints and Triggers.
(ppt)
Example code and load files for
ORACLE triggers (tared gzipped file)..
Example code and load files for
ORACLE triggers (directory of files)..
Chapter 6 : Stored Procedures + etc.
(ppt).
Chapter 6 : Views.
(ppt).
Chapter 6 : DB Application Development.
(ppt).
Week 8 : (Oct/9/2012)
Chapter 6 : DB Application Development.
(ppt).
Normalization.
Chapter 19 : Functional Dependencies and Redundancy.
( ppt).
Week 9 : (Oct/16/2012)
Semester Break.
Week 10 : (Oct/23/2012;oct/25/2012)
Functional Dependencies.
Chapter 19 : Functional Dependencies and Inferencing.
( ppt).
Normal Forms.
Chapter 19 : Transforming Relational Schemas Using Normalization.
( ppt).
Week 11: (Oct/31/2012;Nov/2/2012) ;
Tuesday: MIDTERM GIVEN IN CLASS. p
Chapter 9 : Disks, Buffers and Files. ( ppt).
Please read Chapter 9 for background, but only briefly cover in class..
Chapter 8 : File Organizations and Indexing (part 1).
( ppt)
Week 12: (Nov/6/2012;Nov/8/2012) ;
Indexing Techniques.
Chapter 10 : Tree-Based Indexing.
(ppt).
Chapter 11 : Hash Indexing.
(ppt).
Chapter 8 : Indexing and Workloads (part 2).
(ppt).
Week 13: (Nov/13/2012;Nov/15/2012) ;
Chapter 8 : Indexing and Workloads (part 2).
(ppt).
Query Processing.
Chapter 13 : Query Processing Algorithms/Sorting.
(ppt).
Join Query Processing Strategies.
Chapter 14 : Join Query Processing Algorithms.
(ppt).
Chapter 12/14 : Other Query Operators.
(ppt).
Week 14: (Nov/20/2012;Nov/22/2012) ;
Thanksgiving Break.
Week 15: (Nov/27/2012;Nov/29/2012) ;
Chapter 14 : Physical Query Plan Alternatives.
(ppt).
Chapter 15 : Query Optimizer (A Whirlwind).
(ppt).
Week 16: (Dec/4/2012;Dec/6/2012) ;
Transaction Management and Concurrency Control.
Chapter 16 : Concurrency Control Basics.
(ppt).
Chapter 16/17 : Concurrency Control Protocols.
(ppt).
Chapter 16/17 : Deadlocks and Concurrency Control.
(ppt).