This schedule is subject to change. Behind each assignment is the percentage
that this assignment will count towards your overall grade.
| Date |
Material |
Tentative Homework
Assignments |
|
1/27 |
Introduction and overview
Slides.
|
|
|
1/29 |
Introduction to database systems, introduction to three-tier
architectures. (Chapter 1 in the textbook.)
Slides.
|
Tomcat installation, due 2/9/2003.
Stylesheets, due 2/9/2003. |
|
2/03 |
The Entity-Relationship model, the relational model. (Chapter
2 in the textbook.)
Slides.
|
|
|
2/05 |
Relational Model, mapping ER to relational model, keys.
(Chapter 3 in the textbook.)
Guest lecture by Niki
Trigoni.
|
JavaScript Assignment, due 2/13/2003.
JSP Cookie Assignment, due 2/13/2003. |
|
2/10 |
Technologies at the three tiers:
HTML, HTTP, Forms, Stylesheets, JSP,
Servlets, JavaScript, cookies
(Chapter 7 in the textbook.) |
|
|
2/12 |
Relational algebra. (Chapter 4 in the textbook.)
Slides. |
Query Processor in Java, due 2/20/2004, 23:59pm. |
|
2/17 |
SQL. (Chapter 5 in the textbook.)
Slides. |
SQL Server Installation, due 2/20/2004, 23:59pm. |
|
2/19 |
SQL Continued. (Chapter 5 in the textbook.)
Slides. |
ER Modeling, due 2/26/2004.
Relational Algebra assignment, due 3/2/2004.
Servlet Assignment, due 3/1/2004. |
|
2/24 |
SQL, stored procedures, SQL programming interfaces. (Chapter
6 in the textbook.) |
|
|
2/26 |
Database security: Security principles, standard access
control.
(Parts of Chapter 21 in the textbook.)
Slides. |
|
|
3/02 |
Normalization. (Chapter 19 in the textbook.)
Slides. |
SQL Assignment, due 3/11/2004.
Stored procedures assignment, due 3/11/2004. |
|
3/04 |
Normalization (Contd.). This is a guest lecture by
Mirek Riedewald. |
Normalization, due 3/16/2004.
Top-N Queries, due 3/16/2004. |
|
3/09 |
Introduction to storage and indexing, introduction to query
evaluation. (Chapters 8 and 12 in the textbook.) Slides.
|
|
|
3/11 |
Introduction to query evaluation (contd.), introduction to
transactions. (Chapter 12 and 16 in the textbook.) Guest lecture by Niki
Trigoni.
|
|
|
3/16 |
|
|
|
3/18 |
Evening midterm exam, no class. |
|
|
3/30 |
Database tuning. (Chapter 20 in the textbook.)
Slides. |
Shopping Cart: Servlets with Sessions, due 4/9/2004.
Tuning Wizard, due 4/9/2004. |
|
4/01 |
Data Warehousing (Chapter 23 in the textbook.) Guest lecture by Mirek
Riedewald. Slides from
Mirek. |
|
|
4/06 |
Introduction to semi-structured data.
XML and XML DTDs.
Slides. |
|
|
4/08 |
An introduction to
Enterprise Java Beans.
Guest lecture by
Scott Selikoff.
Slides
from Scott. |
Supplier database integration assignment, due 4/27/2004. |
|
4/13 |
Continuation of Enterprise Java Beans. In-class demo. Discussion of the
Supplier Assignment. |
|
|
4/15 |
XPath and XSLT. Slides. |
|
|
4/20 |
Introduction to Data Mining.
Slides. |
|
|
4/22 |
Introduction to Data Mining. (Continued.)
Slides. |
|
|
4/27 |
XML Schema, XQuery.
Slides. |
Using Enterprise JavaBeans, due 5/6/2004. |
|
4/29 |
Web services: SOAP UDDI, WSDL.
Guest lecture by Al Demers.
Slides from Al. |
|
|
5/04 |
No class. |
|
|
5/06 |
Peer-to-Peer Systems.
Slides.
|
|