CSC 8490-001: Database Systems

Fall, 2009

Tentative Calendar for the Semester

Date	Lecture Coverage (Chapter(s) in Text)	Homework (H) and Project Phase (P) Due	Presentation Materials
Aug 25	Introduction (1, 2)	Due Saturday, Aug 29: P00 (status of progress towards a group)	Intro and History Databases and Database Users Database System Concepts and Architecture
Sep 1	Entity-Relationship Model (3)	H01 (report on article) P01 (teams, topics and roles)	The ER Model Classifying Cardinalities of Relationships Ternary Relationships
Sep 8	Relational Data Model (5) ER->RDM mapping (7.1)	H02 (ERD) P02 (miniworld) P03 (ER model)	Intro to Relational Model The Relational Data Model Mapping ER to RDM
Sep 15	Relational Algebra (6)	H03 (ER -> RDM)	Intro to Relational Algebra Relational Algebra More Relational Algebra
Sep 22	SQL (7)	H04 (r alg) P04 (rdb schema diagram)	Intro to SQL SQL More SQL
Sep 29	Database Programming (9)	H05 (SQL1) H06 (SQL2) P05 (schema implementation)	Here're the presentations I gave in the past. There may be some updates for this term, but most of the information is still pretty current. Here's a roadmap to the other presentation files. If the technology works, this file will have (my) audio narration. sqlplus Chapter 9 from our text, some general principles of database programming More details about JDBC, from the Dietrich and Urban materials Sample code that works for using JDBC to connect to ORACLE on csdb Using JDBC on your Windows system to connect to a local MS-Access database PL/SQL as described in an earlier edition of our text PL/SQL presentation by Dr. Dullea PL/SQL sample on csdb a practice lab on MySQL
Oct 6	EER and UML (4) EER/UML->RDM mappings (7.2)	H07 (JDBC) H08 (PL/SQL) P06 (db instance) Due Oct 14 (during break): H09 (EER) H10 (UML) H11 (EERD->RDM)	Enhanced ER Modeling UML More EER More UML Mapping EER and UML to RDM More Mapping
Oct 20	Midterm Exam	Due Thursday, Oct 22: P07 (midterm report of group meetings) P08 (midterm report of individuals)
Oct 27	Relational Design Theory (10)	P09 (query implementations)	Intro to Relational Design Theory Functional Dependencies and Normal Forms
Nov 3	Relational Design Theory (11)	H12 (FD's) H13 (NF's) P10 (other conceptual schemas)	Decompositions
Nov 10	Transaction Processing (17)	H14-15 (decompositions) P11 (database programming)	Transaction Processing TP Definitions and Exercises
Nov 17	Concurrency Control (18)	H16 (TP1) P12 (FD's and NF's)	Concurrency Control Techniques
Nov 24	Object Data Model (21)	H17 (TP2)	Note: Most of the Elmasri/Navathe presentations for the ODM are from the Fourth Edition, but the fifth is essentially the same. Introduction to the Object Data Model The Object Data Model More on the Object Data Model Mapping to the ODM Object Diagram and ODL for the UNIVERSITY Example More on the Mapping
Dec 1	Object Data Model (21)	H18 (ODL) P13 (ODM) Due Saturday, Dec 5: H19 (OQL)	OQL Other important stuff More on OQL
Dec 8	Final Examination
Dec 15	Project Presentations	P14 (presentation materials) Due Wednesday, Dec 16: P15 (final report of group meetings) P16 (final report of individuals)