Course Schedule and Materials
Last updated on Sept 18, 2008
| Week | Topic/Lecture* |
Class Activities |
Reminder |
|---|---|---|---|
Part 1: Basic Concepts |
|||
| 1. 08/18/2008 | - Course overview Reading: - Chapter 1 |
- Attendance checking |
|
| 2. 08/25/2008 | -
Relational database
concepts Reading: - Chapter 2 up to page 64 |
- Database project overview |
|
| 3. 09/01/2008 | - Labor day holiday (Monday) Reading: - Page 64-73, 240-241 |
- Finalizing student groups and project selection |
- Assignment #1 Due |
| 4. 09/08/2008 | - Database query and SQL (updated on 9/9/2008) Reading: - Page 99-103, 117-130, 134-140 |
- Query in SQL Server 2005 |
- Assignment #2 Due |
Part 2: Database Design |
|||
| 5. 09/15/2008 | -
Database development Reading: -
Database development life cycle (read section 2 to 6) |
- MS Visio 2007 demo |
- Assignment #3 Due |
| 6. 09/22/2008 | - Conceptual modeling/design with ERD Reading: - Chapter 4 |
- Quiz #1 | |
| 7. 09/29/2008 |
Reading: - Chapter 5 |
- Work on database project conceptual design |
- Assignment #4 Due |
| 8. 10/06/2008 | - SQL DDL Reading: - Chapter 3 page 104-116,145-147 |
- Database project presentations #1: conceptual models |
- Database project conceptual design due - Deliverable #1 |
| 9. 10/13/2008 | - Catch-up |
- Work on database project: feedback on conceptual models |
|
| 10. 10/20/2008 | - Test summary |
- Research project meeting |
- Database project logical design
due - Deliverable #2 |
Part 3: Advanced Concepts and Practices in Database Management and Applications | |||
| 11. 10/27/2008 |
- Database systems and applications Reading: - Chapter 7 |
- Work on database project: feedback on logical models; final implementations |
|
| 12. 11/03/2008 |
Reading: - Chapter 6 |
- Research project presentation #1: DBA
(Monday) |
|
| 13. 11/10/2008 | -
Advanced database query Reading: - Chapter 3 page 130-133, 141-145, Chapter 7 |
- Quiz #2 (Monday) - Research project presentation #3:
Database Programmability (Wednesday) |
|
| 14. 11/17/2008 | -
XML
Basics; XML
Schema Reading: - Chapter 7 |
- Research project presentation #4: XML and Database (Monday) |
|
| 15. 11/24/2008 | - Thanksgiving week |
- Work on database project |
|
| 16. 12/01/2008 | - Student presentations (All presenting groups should prepare for Monday presentations, unless we cannot finish them on Monday. All students are required to be present otherwise will be penalized.) | - Database project presentations #3:
database implementations and applications - Research project presentation #6: Database Implementation with Oracle - Research project presentation #7: Database Implementation with MySQL |
- Database project final report due |
News and Updates
12/1 - evaluation form for database project is posted.
Research Project
- Overview (PDF)
- References (PDF)
- Evaluation Form (PDF)
Topics (group # in parentheses; click on the topic to view presentation files):
- DBA (4)
- Database Security (5)
- Database Programmability (8)
- XML and Database (3)
- Data Warehouse (6)
- Database Implementation with Oracle (1)
- Database Implementation with MySQL (7)
Database Project
- Overview
- Business scenario
- Group assignment
Functional Area A: 1, 6
Functional Area B: 3, 7
Functional Area C: 5, 8, 4 - Deliverable #1
- Deliverable #2
- Deliverable #3 (final report)
- Evaluation form
Downloads
- Syllabus
- All databases used in this course
- Visio templates
- SQL Server 2005 AdventureWorks sample
- MSDNAA (for required software)
Web Learning Resources
- Database processing (Kroenke) online companion: here you can find some online quizzes and presentation files.
- SQL Server 2005 books online
- SQL Server online tutorials
- SQL online course
- Database Journal
University Resources
Design by Minimalistic Design