ACS Workshop Agenda: Web Access to Database

Day 1
9-10:15 Workshop Overview
     Why web access to database?
     Ingredients
     DBMS
     Client/Server (Browser/Web Server)
     Server Side Scripting
     Script interface to database
10:15-10:45 Break and Informal Discussion
10:45-12 Intro to DBMS
     Components of DBMS
     Relational Model
     ER Model as a design tool
     ER conversion to relational
12-1 Lunch
1-2:15 Lab
     Intro to DB Software
     Design and construct simple database
2:15-2:45 Break and Informal Discussion
2:45-4:30 Intro to Queries
     Lab
     Create Simple Queries

Day 2
9-10:15 Intro to HTML FormsForm tags and parameters
     Form Input fields
     Submit and Reset
10:15-10:45 Break and Informal Discussion
10:45-12 Lab
     Create web pages with forms related to DBMS
12-1 Lunch
1-2:15 Intro to server side scripting
     Intro to VBScript
     Intro to ASP and its object model
2:15-2:45 Break and Informal Discussion
2:45-4:30 Lab
     Practice simple scripts with forms created earlier

Day 3
9-10:15 Intro to web access to database using ASP ADO and its object model
10:15-10:45 Break and Informal Discussion
10:45-12 Suite of examples of database access
12-1 Lunch
1-2:15 Lab
     Develop suite of database access pages with database and forms created earlier
2:15-2:45 Break and Informal Discussion
2:45-4:00 Lab
     Continue with database access
4-4:30 Evaluation and wrapup