IST 462: Databases Modeling and Application
 
      	                 Spring 2007
__________________________________________________________________

Links: syllabus | presentation | project #2 teams | project #3 teams

Note: subject to change -- refresh the page for updates.

== January: DB Basics ==

16: Introduction
18: VLab and MS SQL Server Tutorial
23: ER
25: Proj #1 (DUE: Feb. 13)
30: Proj #1 discussion

== February: PHP, Advanced DB ==

1: SQL: basic, Northwind Lab (DUE: Feb. 27) => Solution
6: Relational Model: basics, conversion 
8: SQL: subquery
8 (6-9pm @ 205): Make-up class: SQL join, jeopardy
13: Proj #2 (DUE: Mar. 20 30)
15: PHP Tutorial, VLab 3C PHP Help
20: PHP DB connection (examples)
22: DB security modeling, NTS DB Security Lab (DUE: Mar. 30)
27: PHP security (examples)

== March: XML, Web Services ==

1: PHP session (examples)
6: XML schema (examples)
8: XML vs. RDBMS
13, 15: Spring Break
20: Semantic Web: RDF
22: Proj #2 discussion
27: Semantic Web: OWL, RSS 
29: Web Services: overview, Proj #3 (DUE: Apr. 30), semantic web article reading (DUE: Apr. 17) 
30: NTS DB Security Lab solution

== April: Semantic Web, Mashup ==

3: Web Services: REST, AJAX
5: Proj #2 Presentation
10, 12: No class due to my travel (make-ups done in Feb.)
17: Class by Prof. Gerry Santoro
19: Class by Prof. Prasenjit Mitra: information extraction
24: XPath
26: XQuery, XQuery Lab: data, questions => solution 
30: Proj #3 DUE

==  May ==

2, 4: Proj #3 Presentation