| Day | Topic | Notes | Readings |
|---|---|---|---|
| Tu: Oct 23 | Introduction, Course Logistics. | ppt ppt | Chapter 1 |
| Th: Oct 25 | Conceptual Modeling: ER | ppt ppt | 2.1-2.3 |
| Fri: Oct 26 | Conceptual Modeling: ER | ppt ppt | Chapter 4.1-4.3 |
| Mo: Oct 29 | Hurricane Day. | Stay Save! | - |
| Tu: Oct 30 | Conceptual Modeling: Constraints | ppt | Chapter 4.1-4.4 |
| Th: Nov 1 | ER Model: Design Guidelines | ppt ppt | Chapter 4.4/ 2.5 / 7.1 - 7.3 |
| Fri: Nov 2 | Rel. Model: Constraints and ER Translation | ppt | Chapter 4.1- 4.4. |
| Mo: Nov 5 | Oracle 101 and ER Mapping (cont) | ppt-101 ppt-102 | Chapter 2.1-2.3/ 2.5 / 7.3. |
| Tu: Nov 6 | ER Mapping: Other Constructs. | ppt ppt | Chapter 7.1, 4.5 |
| Th: Nov 8 | ER -> Relational Translation. | revisited | Chapter 4.5 - 4.6 |
| Fri: Nov 9 | Design Quality and Redundancy | ppt | Chapter 3.1-3.2 |
| Mo: Nov 12 | Normalization Theory | ppt | Chapter 3.3-3.5 |
| Tu: Nov 13 | Normalization Theory | (cont). | Chapter 3.3-3.5 |
| Th: Nov 15 | Review via Examples | examples. | . |
| Fri: Nov 16 | *MID TERM* | BE READY | tba |
| Mo: Nov 19 | Relational Algebra - Equivalences | ppt | Chapter 2.4, 5.1 |
| Tu: Nov 20 | Relational Algebra - Complex Operators/Examples. | ppt | Chapter 5.2 |
| Th: Nov 22 | THANKSGIVING BREAK | TURKEY DAY | . |
| Fri: Nov 23 | THANKSGIVING BREAK | TURKEY DAY | . |
| Mo: Nov 26 | SQL : Select-From-Where | ppt | Chapters 6.1-6.2 |
| Tu: Nov 27 | SQL : Joins + Nested Queries | ppt | Chapter 6.1 - 6.4; 6.6 |
| Th: Nov 29 | SQL : Complex Nested Queries/Examples | ppt | Chapter 6.1 - 6.4; 6.6 |
| Fr: Nov 30 | SQL Constraint Specification/Triggers | ppt ppt | Chapters 7.3 - 7.5/ 9.4 |
| Mo: Dec 3 | Stored Procedures and Triggers |
ppt
ORACLE triggers (gzipped file).. ORACLE triggers (dir of files).. |
Chapter 9.6 |
| Tu: Dec 4 | Examples with Triggers | Examples in class. | ... |
| Th:Dec 6 | Misc and Database Views |
ppt
ppt
ppt |
Chapter 8.1 - 8.2, 8.3 - 8.5 |
| Fri: Dec 7 | Transactions in SQL | ppt | Chapter 8.4 |
| Mo: Dec 10 | Catchup Day | ppt | . |
| Tu: Dec 11 | *FINAL EXAM* | IN CLASS | cumulative |
| Th: Dec 13 | *GIVE DEMOS* | DURING MORNING IN LAB |