MIS 710 Database Management
MIS 710 Database Management
* Home
* Description
* Overview
* Schedule *
* Projects
* Grades
* Discussions *
The following is a tentative list of topics to be covered in the course. Note that this list is subject to changes. In the case of major changes, an announcement will be made in class, and/or a note posted in the discussion boards. If you want to get an email notification when the content of this page changes, you may sign up using the box provided at the bottom of this page. Note that this is an external service that I do not maintain, so I do not guarantee the accuracy of this service. Use at your own risk. You may simply want to check this page every day as part of a schedule.
SKS: Silberschatz, Korth, Sudarshan; SW: Simsion and Witt
| Module/ Milestone |
Dates | Topic |
RequiredReadings |
Auxiliary material | |
|---|---|---|---|---|---|
| 0 | Jan 3 | Intro to course, basics of databases, needs for database use, course website and WebCT. | Course website WSU WebCT website |
[Lec. notes] | |
| Quiz1 | Due Jan 10 |
Survey 1,
Pre-class Quiz 1 |
Module 1a | ||
| 1a | Jan 10 | Data modeling overview - Entity-Relationship Modeling, Advanced ER structures, XML models | SKS Ch6, SW Ch1,3-4 | [Lec. notes] | |
| Quiz2 | Due Jan 17 |
Pre-class Quiz 2 | Module 1b | ||
| 1b | Jan 17 | Advanced data modeling, normalization, logical and physical models, Model-Schema translation | SKS Ch7, SW Ch2,6,10-12 | [Lec. notes] | |
| A1 | Due Jan 20 |
Assignment 1 - available from WebCT | Module 1 | download | |
| Quiz3 | Due Jan 24 |
Pre-class Quiz 3 | Module 2a | ||
| 2a | Jan 24 | Basics of querying, Calculus, Algebra, Intro to SQL | SKS Ch2,3,5 | [Lec. notes] | |
| Quiz4 | Due Jan 31 |
Pre-class Quiz 4 | Module 2b | ||
| 2b | Jan 31 | Advanced SQL querying, XML qurerying (XPath/XQuery) | SKS Ch 4, W3C sites on XQuery and XPath | [Lec. notes] | |
| A2 | Due Feb 4 |
Full Assignment 2 | Module 1, 2 | download | |
Midterm |
Feb 7 | Mid-term examination (on Modules 1-2) | Practice test on WebCT | ||
| Quiz5 | Due Feb 14 | Pre-class quiz 5 | Module 3 | ||
| 3 |
Feb 14 |
Database Application Development - JDBC, JSP and Servlets |
SKS Ch8, JSP Tutorial | [Lec. notes] | |
| Feb 20 | Last date to drop a class with a grade of "W" | ||||
| P0 | Due Feb 17 |
Group Project Design | |||
| Quiz6 | Due Feb 21 | Pre-class quiz 6 | Module 4a | ||
4a |
Feb 21 | Commercial database survey, XML as a data representation and search mechanism |
W3C XML site W3Schools tutorials on XML and XPath |
[DB Lec. notes] [XML Lec. notes] [XPath Visualizer] |
|
| A3 | Due Feb 24 |
Full Assignment 3 | Module 3 | ||
| 4b | Feb 28 | Data Mining and warehousing, Distributed Databases | SKS Ch18, Chap 22 Weka Data Mining Site |
[Datamining Lec. notes] [Distributed DB notes] |
|
| Mar 7 | Project presentations, Final Exam Review | ||||
| P1 | Due Mar 10 |
Group Project - Full Implementation | |||
| Final | Mar 14 | Final Exam - 8-10PM | Module 1-4 | ||
|