| Lectures (MS PowerPoint) |
|
Introduction to Database Management The Relational Model: Concepts The Relational Model: Query-by-Example (QBE) |
| Exercises | |
| Exercise | Due Date |
| Exercise #1 (QBE) - pg. 67, Ex 1 - 18 (Henry Books) | |
| Exercise #2 (Relational Algebra) - pg. 67, Ex 1 - 7 (Premiere Products) | |
| Exercise #3 (SQL Workbook Ch. 4) - pg. 133, Ex 1 - 23 (Henry Books) | |
| Exercise #4 (SQL Workbook Ch. 5) - pg. 168, Ex 1 - 17 (Henry Books) | |
| Exercise #5 (SQL Workbook Ch. 6) - pg. 192, Ex 1 - 11 (Henry Books) | |
| Exercise #6 (SQL Workbook Ch. 7) - pg. 229, Ex 1 - 7, 9, 10 (Henry Books) | |
| Tests & Exams | ||
| Tests/Exams | Coverage | Date |
| Test #1 | Chapters 1 & 2 | Thursday, February 2, 2012 |
| Test #2 | SQL Workbook Chapters 3 - 5 | Tuesday, March 6, 2012 |
| Midterm Exam | Tests 1 & 2 | Tuesday, March 20, 2012 |
| Group Presentations | Thursday, April 26, 2012 | |
| Final Exam | Comprehensive Practical | Thursday, May 3, 2012 (6:00pm - 7:55pm) |
Some Relational Database Management Systems.