Fall 2005

8/23  Introduction (syllabus page); H1 = conceptual graph of Chap. 1 vocabulary
8/25   H1 disscussion;  introduction to relational model

8/30   Mini-university domain and data models.
9/01   tour of Access; H2 = mini-university application using Acess

9/06  Access ex (Northwind, Students),  syntax, intro to sql;  H3 = syntax of Chap. 7 sql.
9/08  Oracle isqlplus;  kinds of sql statements;  Chap 7 sql examples; 
          companies example, H4 = selected sql for companies (due 9/13)
          H5 =  mini-university via direct sql to Oracle.

9/13  discussion of H4 items: nesting, joins, aggregate functions, with clause
9/15  discussion of H3 syntax; Oracle sql documents; select w negation

9/20  Java client; JDBC;  H6 = client for mini-university
9/22  review JDBC;  JTable and TableModel;  derived attributes, atomic actions via commit/rollback
         H5 due;  prelude to H7 = create your home.html page.

9/27  review domain vs data models;  sql for "same-city" query;  exercise: KDOT domain model
9/29  Java client features;  ER models

10/04  Fall Break day
10/06  review for Ex 1

10/11  Exam 1
10/13  review exam

10/18  no class
10/20  asssign presentation topics and project topics;  forms and servlets

10/25  project reviews
10/27  no class

11/01  Pat: history;    Bill: normalization
11/03  project reviews

11/08  review of Chapts  1,2,4,5,7,8;  concepts from  Chapts  6,13, 11, 12, 14
11/10  Philip: GIS;         Mary:  query opt.;                   project reviews

11/15  Tim: phpBB;       David: Oracle hints;      
11/17  Yahui: DOORS;    Alan: stored procs;                Jared: XML

11/22  Bill:  web apps;  Lucas: recovery;       Cole: SQLite;      Matt: DBMS ;      Bart: injection
           
11/29  no class
12/01  Exam 2

12/06  Curtis:
12/08  Project demos

12/12  Project reports due. 




560 Log  Spring 2005

01/12  Introduction, goals.
01/14  H1= "miniUniversity" using Access.

01/19  conceptual graph for Access;  finish Access features
01/21  H1 example;  BNF notation,   H2 =  syntax for Chap 7 sql

01/24  connection to Oracle, password, iSQL*Plus, syntax for create & insert
01/26  syntax & features for select (join, aggregates, grouping);
            H3 = miniUniversity using sql for Oracle

01/31  simple sql examples for company model
02/02  sql examples: subqueries vs nested queries, "in" & other operators, use of temporary tables
02/03  Distinguished Lecture by Dr. Santos: Inference for user queries
02/04  sql examples with aggregate operators; evaluation of "where" vs "having";
           negation and set operations

02/07  derived attributes (by query vs attribute, current vs delayed evaluation);
           client server structures, H4 = java.sql  class diagram (due Wed.)
02/09  JDBC; oracle drivers; Chap 8
02/11  Java thin client architecture; H5 = java client for H3

02/16  no class
02/18  discuss H5; ER diagrams, Chaps. 2,3

02/21  project process & topics; mapping ER to UML
02/23  ER -> UML example;  conceptual_model -> relational_DB_model (see UML profiles links)
02/25  no class: submit Java client to instructor (if done)

02/28  review for exam ; selection of project topics;  web access
03/02  enterprise applications, 3 tier structure, tomcat, H6=web client and server for H3
03/04  review/preparation for exam: sample problems; conceptual model, data model,
           sql .. aggregation, negation, derived attributes

03/07  Exam 1
03/09  H7=class presentation; H7a=self-eval form;  review tomcat
03/11  project reviews by appointment ( 8:15 and 1:30-4:45 ugh )

03/14  Review Exam 1; presentation schedule
03/16  Transactions
03/18  no meeting.

****    Spring break 

03/28  paper selection and schedule; >>> email slides / notes before your presentation; <<<<<
           review J2EE model, EJB's
03/30  no class meeting:  please schedule an appointment to review project models
                                     (two sequence models -- one for "add" , one for "do key operation" )
04/01  Bambera;  Fisher, Jundt

04/04  Carlson, Leon, Taylor
04/06  Gomez, Sutherland
04/08  University Open House

04/11  Jantz, Lamb
04/13  Anderson, Radafsky, Smith, Hankley
04/15  Project reviews

04/18  Dolezilek, Solera, Rogers-Ostema
04/20  Pickett, Clayton, Cline, Goreham, Haynes
04/22  no meeting         

04/25   review for exam; 
04/27  Exam 2
04/29  no meeting

05/02  Query processing; performance factors
05/04  Review exam2 results
05/06  Project demonstrations (by arrangement)

05/09   Project documents due:
            Project demonstrations (by appointment)

---

Previous semesters:

wk1  Introduction, goals.  (H1)

wk2   Conceptual graph for Chapter 1 vocabulary
          Comparison of object and relational models:
              (schema, table, row, PK, FK; entity, relational table, lookup table)  
wk3   Tour of Access ...
         ... tour of Access;  Assignment: Small University Model: Conceptual Model + Access implementation. (H2)
wk4   Grammars, BNF, syntax diagrams (H3)
         ER models & diagrams (Chap 2)

wk5   SQL systax (and semantics)
         SQL examples

wk6  more sql examples
        architecture and concepts of Oracle DMBS

wk7   ODBC; using Access to view Oracle table; compare JDBC
        select project topics; java.sql components; sample Java clients

wk8  discuss presentation topics; intro to web access to DB
        review for exam

wk9   Exam 1
          size+ speed estimates  

wk10  Review exam results
            Project reviews:  requirements

wk11  Web client  ; Tomcat;  3  tier J2EE architecture

wk12  Project reviews: domain model, GUI

wk13-14  Project reviews: GUI, table design
               student presentations

wk15   Exam 2 

wk16  Review  exam results.
       Project demonstrations (by arrangement)