INLS 258: Database Systems II - Fall 2005
Schedule

This week

Week #	Tuesday	Thursday
1	Aug. 30 Intro. to class, logistics, Overview Slides: (HTML, PPT)	Sep. 1 SQL review Read: Elmasri, R. & Navathe, S. (2004). Fundamentals of Database Systems. Ch. 8. (OPTIONAL)SQL tutorials on class resources page Slides: (HTML, PPT)
2	Sep. 6 Modeling and evaluation Read: Elmasri and Navathe (Ch. 7, 12-12.3.3). (Optional)Teorey, Yang, Fry. (1986). A logical design methodology for relational databases using the extended entity-relationship model Slides: (HTML, PPT) Group By and Having examples	Sep. 8 SQL and MySQL Slides: (HTML, PPT) Notes: MySQL demo
3	Sep. 13 Modeling and evaluation Slides: (HTML, PPT) Notes Individual db design and implementation assigned	Sep. 15 Intro to SQL*Plus Due: Project groups and ideas Schedule class presentations Notes: Oracle demo Oracle documentation library - for release 9.2 and available as a web db implementation from Oracle Slides: (HTML, PPT)
4	Sep. 20 Transactions Read: Elmasri and Navathe (Ch. 17). Slides: (HTML, PPT)	Sep. 22 Transactions Read: Elmasri and Navathe (Ch. 18).
5	Sep. 27 Recovery Read: Elmasri and Navathe (Ch. 19). Slides: (HTML, PPT)	Sep. 29 Oracle Architecture Read: Morrison and Morrison. (2002). Enhanced Guide to Oracle 9i. (Ch. 2, 3). Notes: Oracle data dictionary lab Slides: (HTML, PPT) Due: Individual db design and implementation (ER and DDL)
6	Oct. 4 Current Issue Presentations	Oct. 6 Current Issue Presentations
7	Oct. 11 Current Issue Presentations Notes: Marathon ER diagram (Visio, PNG)	Oct. 13 Oracle database objects Slides: (HTML, PPT) Due: Individual db assignment (queries)
8	Oct. 18 More Oracle Due: Project database design and specifications Notes: TOAD lab Notes: Sample interval calculations	Oct. 20 No class (Fall break)
9	Oct. 25 Query Optimization Read: Elmasri and Navathe (Ch. 15, 16). Slides: (HTML, PPT) Notes: explain plan lab cut and paste document and utlxplan.sql script - for use with explain plan lab	Oct. 27 More optimization
10	Nov. 1 Class Cancelled Read: Morrison and Morrison. (Ch. 5, 6).	Nov. 3 more Oracle Forms Due: Project table DDL and DML Notes: Oracle Forms lab
11	Nov. 8 Reports Read: Morrison and Morrison. (Ch. 7). Notes: Oracle reports lab	Nov. 10 PL/SQL Read: Morrison and Morrison. (Ch. 9). Elmasri and Navathe (Ch. 24-24.1.2). Slides: (HTML, PPT) Notes: PLSQL examples and a PLSQL package example Quiz 4 - due by Tuesday's class
12	Nov. 15 Advanced SQL Slides: (HTML, PPT) Notes: Advanced SQL query answers Due: Project sample form and report	Nov. 17 Distributed databases Read: Elmasri and Navathe (Ch. 25). Kossman. (2000). The state of the art in distributed query processing Slides: (HTML, PPT)
13	Nov. 22 No class	Nov. 24 No class
14	Nov. 29 Distributed and federated databases	Dec. 1 Non-relational data models Read: Elmasri and Navathe (Ch. 2.6, 20). Slides: (HTML, PPT)
15	Dec. 6 Project demos	Dec. 8 Wrap up
	Dec. 17 Final project documentation due by 4 pm. Notes: Don't forget your individual (and confidential) project feedback form