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 |
---|---|---|
8/22 | Course Overview and Introduction to Databases | Chapter 1 |
8/27 | Introduction to Data Modeling | Chapter 2 |
8/29 | The Relational Model | Chapter 4 |
9/3, 5 | SQL: Data Manipulation |
|
9/10 | SQL: Data Definition | Chapter 7 |
9/12 | Relational Algebra | Chapter 5.1 |
9/17 | Catchup Day | None |
9/19, 24 | Entity-Relationship Modeling | Chapter 12 |
9/26, 10/1 | Normalization | Chapter 14 |
10/3 | Physical Database Design |
|
10/8 | Midterm Exam | None |
10/10 | Introduction to Scripting Languages |
|
10/15 | Perl Basics |
|
10/17 | Fall Break | None |
10/22 | Regular Expressions, Functions, and Files | perl 2 | 10/24 (Engineering Day)--No class but online video | regular expression introduction and regular expression wrapup | --- |
10/29 | Perl Sorting, Modules, and Object-Oriented Programming | perl 2 |
10/31 |
|
PHP Basics |
11/5 | Creating xhtml forms | XHTML forms |
11/7 |
|
Handling Forms and Session Management in PHP |
11/12 |
|
XML and PHP interface to mySQL |
11/14 |
|
Introduction to JavaScript |
11/19 |
|
HTML DOM and Javascript DOM API |
11/21 | Forms, Events, and Regular Expressions | |
11/26 | Ajax | |
11/28 | Thanksgiving | |
12/3 | AJAX in-class exercise | Attendance is mandatory |