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/24 | Course Overview and Introduction to Databases | Chapter 1 | --- | |
8/29 | The Relational Model | Chapter 4 | ||
8/31, 9/5 | SQL: Data Manipulation |
|
|
|
9/7 | SQL: Data Definition | Chapter 7 | 1) DDL Slides 2) Subquery Slides 3) Lecture 9/7 |
|
9/12 | Relational Algebra and Calculus | Chapter 5 | 1) Slides 2) Lecture | --- |
9/14 | Relational Algebra and Calculus | Chapter 5 | 1) Slides 2) Lecture |
hw3 (Due Fri. 9/22 at 6am) |
9/19, 21 | Entity-Relationship Modeling |
| ||
9/26, 9/28 | Normalization |
|
1) Slides 2) 9/26 Lecture 3) 9/28 Lecture |
hw5 (Due Fri. 10/13 at 6am--no late acceptance) |
10/3, 10/10 | Physical Database Design |
|
10/3 Lecture 10/10 Lecture |
--- |
10/5 | Fall Break | None | --- | --- |
10/12 | Extendible Hashing and Exam Review Session | Extendible Hashing handouts on Canvas. Go to Modules and then Course Materials. | Review Notes Lecture |
--- |
10/17 | Midterm Exam | None | --- | --- |
10/19 | Introduction to Scripting Languages | Lecture |
|
|
10/24 | Perl Control Constructs and Introduction to Regular Expressions |
|
Perl Lecture Midterm Exam Lecture |
--- |
10/26 (Engineering Day)--No class but online video | Finishing Regular Expressions | perl 2 | Online video on Regular Expressions | --- |
10/31 | Perl Functions, Files, and Sorting | perl 2 | 1) Lecture 2) Homework 6 Discussion |
|
11/2 | Perl Modules and Object-Oriented Programming | perl 2 | Lecture | --- |
11/7 | PHP Basics |
|
Lecture | hw8 (Due Fri. Nov 17 at 6am) |
11/9 | XHTML forms | Creating xhtml forms | Lecture | --- |
11/14 | Handling Forms and Session Management in PHP |
|
Lecture | --- |
11/16 | XML and PHP interface to mySQL |
|
Lecture | hw9 (Due Wed. Nov 29 at 6am) |
11/21 | Introduction to JavaScript |
|
Lecture | --- |
11/23 | Thanksgiving | --- | --- | |
11/28 | HTML DOM and Javascript DOM API |
|
Lecture | hw10 (Due Wed. 12/6 at 6am--no late submissions accepted) |
11/30 | Forms, Events, and Regular Expressions | Lecture | --- | |
12/5 | Ajax | Lecture | --- |