Important: The dates and the assigned readings are tentative until a few days before the actual class so you should make sure you check this site regularly. Chapter assignments refer to chapters in the Connolly and Begg textbook.

Date	Topics	Assigned Readings	Lecture Slides	Homework
8/18	Course Overview and Introduction to Databases	Chapter 1	Logistics Slides Database Terminology (Chap 1) Lecture	---
8/23	Introduction to Data Modeling	Chapter 2	Data Modeling Notes Lecture
8/25	The Relational Model	Chapter 4	slides Lecture
8/30, 9/1	SQL: Data Manipulation	Chapter 6 (skim) w3schools SQL Tutorial. Read all the SQL Basic, play with the SQL demo, and read the following topics in the advanced section: SQL Order By SQL and & or SQL In SQL Between SQL Join SQL Create My SQL Notes Getting Started with Your MySql Database	Slides Lecture for 8/30: Select, Project, and Intro to Joins Lecture for 9/1: Joins and Updates	hw1 (Due Fri. 9/9 at 6am) hw1 supplementary files
9/6	SQL: Data Definition	Chapter 7	1) DDL Slides 2) Subquery Slides	Lecture Video From Last Year (but Homework is due at 6am on Friday)
9/8	Relational Algebra and Calculus	Chapter 5	1) Slides 2) Lecture	hw2 (Due Fri. 9/16 at 6am) hw2 supplementary materials-The DreamHome.sql file will create the relations for the Dream Home property management firm and can be used with question 8.
9/13	Relational Algebra and Calculus	Chapter 5	Slides	Lecture
9/15, 20	Entity-Relationship Modeling	Chapter 12 Investment Firm Design Case	1) Slides 2) 9/15 Lecture 3) 9/20 Lecture	hw3 (Due Fri. 9/23 at 6am)
9/22, 9/27	Normalization	Chapter 14 Hotel Case Study	1) Slides 2) 9/22 Lecture 3) 9/27 Lecture	hw4 (Due Fri. 9/30 at 6am)
9/29, 10/4	Physical Database Design	physical design Chapter 18 Appendix F or B+-tree and Extendible Hashing handouts under Course Materials on Blackboard B+-Tree Visualization	9/29 Lecture 10/4 Lecture	hw5 (Due Tue. 10/11 at 6am--no late acceptance)
10/6	Fall Break	None	---	---
10/11	Introduction to Scripting Languages	perl 1 Videos: ScriptingLanguageIntro Perl-Introduction	Lecture	hw6 (Due Wed. 10/26 at 6am) hw6 supplementary materials
10/13	Midterm Exam	None	---	---
10/18	Perl Control Constructs and Introduction to Regular Expressions	perl 2 perldoc.perl.org: Introduction to Perl	Lecture	---
10/20 (Engineering Day)--No class but online video	Finishing Regular Expressions	Online video on Regular Expressions perl 2	---	---
10/25	Perl Functions, Files, and Sorting	perl 2	Lecture	hw7 (Due Wed. 11/2 at 6am) hw7 supplementary materials
10/27	Perl Modules and Object-Oriented Programming	perl 2	Lecture	---
11/1	PHP Basics	PHP Tutorial-Read the PHP Basics section through PHP functions Introduction to PHP Getting Started in PHP Brad's Cliff Notes Version of PHP Geoff Mazeroff's Cliff Notes Version of PHP	Lecture	hw8(Due Fri. Nov 11 at 6am)
11/3	XHTML forms	Creating xhtml forms	Lecture	---
11/8	Handling Forms and Session Management in PHP	PHP Tutorial Read the PHP Basics section from PHP Forms to the end PHP Cookies PHP Sessions Handling Forms	Lecture	---
11/10	XML and PHP interface to mySQL	PHP SQL-Read the PHP MySQL Database section my PHP SQL notes XML Introduction XML Schemas PHP XML Parsing	Lecture	hw9(Due Fri. Nov 18 at 6am)
11/15	Introduction to JavaScript	w3 schools JavaScript notes up to, and including, JS Validation. my JavaScript notes Arrays, Functions, and Objects w3 schools JS Objects. First	Lecture	---
11/17	HTML DOM and Javascript DOM API	w3 schools JS HTML DOM. First go to "Learn JavaScript" and then to "JS HTML DOM". Javascript DOM	Lecture	hw10 (Due Wed. 11/30 at 6am--no late submissions accepted)
11/22	Forms, Events, and Regular Expressions	Forms and form validation Regular Expressions	Lecture	---
11/24	Thanksgiving		---	---
11/29	Ajax	w3schools Ajax tutorial My Ajax notes	Lecture	---