Date	Event	Reading Topic	Harrington	Fehily
Aug 23		Introduction, Architecture: External, Conceptual, and Internal Levels	Chapter 1; pp. 52-54; page 138. Also see pp. 375-385
The Relational Model of Data
Aug 23-28		Domains, Attributes, Tables, and Relations	pp. 20; 22-top 23; 73-77	pp. 21- top 24
Aug 28 - Sept 4		Predicates and Queries http://en.wikipedia.org/wiki/First-order_predicate_calculus (skip Peano Axioms) http://www.it.jcu.edu.au/Subjects/cp3020/1995/3/node6.html (In class, we will formulate queries C1-C11 in a more intuitive SQL-like syntax developed by C.J. Date. Then, later in the term, we will translate these queries into standard SQL.)
Database Design
Sept 6	Project Presentation I (5 min or less, no visual aids, just say a few sentences to the class.) Identify the real-world system you'll be working on, and who is in the group that will be working on this project.
Sept 6-11		First Normal Form; Functional Dependencies; Second Normal Form	Chapter 2 to page 17; pp. 95- top 106	pp. 33-36
Sept 11		Primary Keys and their Entity Integrity Rules; Choosing Primary Keys	pp. 77-82; 191	pp. 26-27
Sept 13		Foreign Keys and their Referential Integrity Rules; Choosing Foreign Keys	pp. 82-86; 191-194	pp. 28-32
Sept 18		Third Normal Form	pp. 106-top 108	pp. 32-33
Sept 20	Project Presentation II: Condition-response table and Data dictionary which define the structure and composition of your user's input & output user views (Project Steps 1 and 2: External Level). The purpose here is to capture the data attributes in your original user views before doing any normalization of that data.
Sept 25		SQL (Database Definition, Manipulation & Query Language)	pp. 177-180; mid 184 -190	Chapter 3 (skip ``Interval Types`` )
Sept 27		Specifying Integrity Constraints	pp. 194-197	pp. 331-380
Oct 2		Review
Oct 4	Midterm Exam
Oct 9		Boyce-Codd Normal Form	pp. 108-109
Oct 11	No class (Fall Break)
Implementation
Oct 16		Expressing Queries in SQL http://www.postgresql.org/docs/7.3/interactive/queries.html (But feel free to defer section 4.2.1.1. ``Joined Tables`` until we need it Oct 31)		Chapter 4; pp. 109-115; 134-136; 139-141; 278-top 281
Oct 18	Project Presentation III: The Boyce-Codd Normal Form (BCNF) tables in the database you have designed for your project. Present your final BCNF tables only. Do not present the 1NF, 2NF, 3NF tables that led up to it.
Oct23		Data Manipulation in SQL		Chapter 10
Oct 25		Basic User Interfaces	http://www.php.net/, especially http://pgsql.designmagick.com/tutorial.php If you have a home page or directory on the CS web site, then you can ignore the installation sections in the tutorial above. Just put your .php pages in your directory on the CS web server, and it should handle them. For reference, the PHP manual is at http://www.php.net/manual, other documentation is at http://www.php.net/docs.php, and the section on PostgreSQL php functions is at http://www.php.net/manual/en/ref.pgsql.php
Oct 30		Queries on Multiple Tables	bottom 112 - 119	Chapter 7; pp. 237-245; 285-286; 287-293
Nov 1		Summarizing and Grouping Data; Views	pp. 86 - top 88; 198-200	Chapter 6; Chapter 13
		The following readings on transactions, concurrency, and recovery, are links to CP3020 ``Advanced Database Management'' by H. Ghodosi et al., at http://www.it.jcu.edu.au/Subjects/cp3020/2003-1/CP3020.HTML
Nov 6		Transactions http://www.it.jcu.edu.au/Subjects/cp3020/2002-1/Cns/lectureNotes/chapter19/chapter19.html (skip ``Characterizing Schedules Based on Recoverability'')
Nov 8		Concurrency http://www.it.jcu.edu.au/Subjects/cp3020/2002-1/Cns/lectureNotes/chapter20/chapter20.html up to and including ``Downgrading'' (of Locks); then ``Concurrency Control Based on Timestamp Ordering`` to end of chapter.
Nov 13	Project Presentation IV: Demonstration of a working PostgreSQL implementation and user interface for your project.
Nov 15		Recovery http://www.it.jcu.edu.au/Subjects/cp3020/2002-1/Cns/lectureNotes/chapter21/chapter21.html up to and including ``Recovery Techniques Based on Immediate Update''
Nov 20		Entity-Relationship Modeling	Rest of Chapter 2; pp. 94-95
Nov 22		No class: Thanksgiving holiday
Nov 27		Object/Relational Mapping ``Mapping Objects to Relational Databases: O/R Mapping In Detail'' by Scott W. Ambler. http://www.agiledata.org/essays/mappingObjects.html
Nov 29- Dec 4		Catch-up if needed; Review
	Final Exam: 2:45 - 4:45 pm Eastern Time, Monday December 10