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/18 | Course Overview and Introduction to Databases |
|
8/23 | SQL: Data Manipulation |
|
8/25 | SQL: Data Definition | Chapter 7 |
8/30 | The Relational Model | Chapter 4 |
9/1 | Relational Algebra | Chapter 5.1 |
9/6 | Catchup Day | None |
9/8 | Introduction to Data Modeling | Chapter 2 |
9/13, 15 | Entity-Relationship Modeling | Chapter 12 |
9/20, 22 | Normalization | Chapter 14 |
9/27, 10/4, 10/6 | Conceptual, Logical, and Physical Database Design | Chapters 16, 17, 18, 19, 23 |
10/11 | Catch up day | None |
10/13 | Introduction to Scripting Languages | perl 1 |
10/18 | Perl Basics |
|
10/20 | Midterm | None |
10/25, 10/27 (Engineers Day), 11/1 | Regular Expressions |
| 11/3 | Manipulating File Systems with Perl |
11/8 | Web Scripting with Perl |
|
11/10, 15, 17 | The Python Language | |
11/22 | Python and Graphical User Interfaces | TBA |
11/24 | Thanksgiving | None |
11/29 | Catch up | None |