Information Systems Topics
The course will cover two main topics
- Relational Databases
- Implementation of Database Systems
You should read the designated chapters concurrent with the lecture schedule. I recommend reading the chapter in advance of class.
Some topics link to lecture slides. Please keep in mind that lecture slides are not a substitute for class notes because slides are intended to provide illustrations of certain topics discussed in class, but not provide comprehensive coverage of the lecture. Your responsibility is to take notes in class as needed to supplement the text.
| Topic | Date | Text |
|---|
| Key Concepts | Jan 30 | Ch 1 |
| SQL Intro, Relational Model More SQL | Feb 1, 6, 8 | Ch 3 The Relational Data Model, Ch5 Relational Algebra |
| Relational Algebra | Feb 13, 15 | Ch 5 Relational Algebra |
| Entity-Relationship Modeling | Feb 20, 22 | Ch 4 Conceptual Modeling |
| Normalization Theory Part Two | Feb 27, Mar 1, 6 | Ch 6 Database Design with the Relational Normalization Theory |
| Midterm Review | Mar 13 | |
| Midterm | Mar 15 | |
| Database Security | Mar 27 | |
| Triggers and SQL in Apps (supplementary) | Mar 29 | Ch 7-8 Triggers, Active Databases, SQL in Applications |
| Indexing | Apr 3,5 | Ch 9 Physical Data Organization and Indexing |
| Query Processing | Apr 10,12,17 | Ch 10 The Basics of Query Processing, Ch 11 Query Optimization |
| Transactions (old notes) | Apr 24, 26 | Ch 13 An Overview of Transaction Processing |
| Object Databases | May 1 | Ch 16 Object Databases |
| XML | May 3 | Ch 17 XML |
| Class Project Presentations | May 10 | Groups 1 2 3 4 5 |
| Class Project Presentation Wrap-up and Final Review | May 15 | |
