ISE 303: Database Design and Administration |
| Lecture Slides and Notes |
| Lecture | Lecture Topic |
| Week 1 |
Introduction: Databases and Database Users by Elmasri- Ch 1 (ppt)
Database System Concepts and Architecture by Elmasri- Ch 2 (ppt)
Introduction by Silberschatz, Korth and Sudarshan - Ch 1 (ppt)
|
| Week 2 |
The Relational
Data Model and Relational Database Constraints by Elmasri - Ch5 (ppt) The Relational Algebra and Calculus by Elmasri - Ch6 (ppt) - Examples 1: http://www.cs.helsinki.fi/u/laine/tkpv/algebra/buildingqueries.html - Example 2: http://cisnet.baruch.cuny.edu/holowczak/classes/3400/relationalalgebra/ Introduction to the Relational Model by Silberschatz, Korth and Sudarshan - Ch 2 (ppt) Other Relational Languages by Silberschatz, Korth and Sudarshan - Appen C (ppt) - Example 1 QBE : http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter5/node2.html - Example 2 QBE : http://www.ceng.metu.edu.tr/~nihan/ceng302/QBE.ppt |
| Week 3 |
SQL-99: SchemaDefinition, Constraints, and Queries and
Views by Elmasri -Ch8 (ppt) - Example 1 : http://www.w3schools.com/sql/default.asp - Example 2 : http://www.firstsql.com/tutor.htm - Example 3 : http://sqlzoo.net/ - Example 4: http://www.learn-sql-tutorial.com/ - Example 5: http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm - Example 6: http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html - Example 7: http://www.fianga.com/ Introduction to SQL by Silberschatz, Korth and Sudarshan - Ch3 (ppt) |
| Week 4 |
Introduction to SQL Programming Techniques by Elmasri -
Ch9 (ppt) Intermediate SQL by Silberschatz, Korth and Sudarshan - Ch4 (ppt) Advanced SQL by Silberschatz, Korth and Sudarshan - Ch5 (ppt) |
| Week 5 |
- Database Design: The Entity-Relationship
Approach
by
Silberschatz and at al - Ch 7 (ppt)
- ER model (ppt), Transforming ER (ppt) Data Modeling Using the Entity-Relationship (ER) Model by Elmasri- Ch3 (ppt) Enhanced Entity-Relationship (EER) Modeling by Elmasri - Ch4(ppt) Relational Database Design by ER- and EERR-to-Relational Mapping by Elmasri- Ch 7(ppt) |
| Week 6 |
Normalization (ppt) Relational Database Design Silberschatz and at al - Ch 8 (ppt), Functional Dependencies and Normalization for Relational Databases by Elmasri- Ch10 (ppt) Relational Database Design Algorithms and Further Dependencies by Elmasri- Ch11 (ppt) |
| Week 7 | Application Design and Development - Ch 9 (ppt) |
| Week 8 |
Storage and File Structure - Ch 10 (ppt) Indexing and Hashing - Ch 11 (ppt) |
| Week 9 |
Query Processing - Ch 12 (ppt) Query Optimization - Ch 13 (ppt) |
| Week 10 |
Transactions - Ch 14 - (ppt) Concurrency Control - Ch 15 (ppt) Recovery System - Ch 16 (ppt) sample q (txt) |
| Week 11 |
Data Mining - Ch 20 (ppt) Information Retrieval - Ch 21 (ppt) |
| Week 12 |
Object-Based Databases - Ch22 (ppt) XML - Ch23 (ppt) |
| Week 13 | Midterm |
| Week 14 | Review and Presentations |