CIS 764  Database Design (3)  Fall 2008
   http://people.cis.ksu.edu/~hankley/d764/764Syllabus.html

Catalog description:  (very old)
Conceptual, logical, physical, and user interface design for database management systems.
Pr.: CIS 501 (general knowledge of object-oriented design and development).

Actual focus:   Enterprise Database System Design and Engineering
    Software engineering for enterprise (web based) database applications,
    with specific focus on Oracle  tools and J2EE architecture.
    Object-oriented models, model-driven development, object-relational mapping; 
    DB GUI components, data access patterns. Small programming assignments
    (using Java and Oracle JDeveloper),  project, and student presentation.
   Grading based upon performance and timely progress in both assignments and project.

Line Schedule:  Section  11389 ,  T H 2:30 , Room N122
                and   Section  15820 ,  course link  via KSU Distance Education

Instructor:  William Hankley  

TA:           Pranshu Gupta 

Links:     Log08+Assignments ...  Slides08  ...Tutorials08 ...Tutorials07 .... Students08  ....

Topics: 
    a.   J2EE architecture for Oracle 
    b.   design of object and data models
    c.   Oracle JDeveloper tool , Object-relational  mapping , Oracle tutorials
    d.   STRUTS, JSF 
    e.   other frameworks:  Ruby, Hibernate, etc.
    f.    other servers:  Oracle App server +PL/SQL  , dotNet
    g.   design project and reviews
    h.   current topics in enterprise applications development

Text:  None, but many resources are available on-line.

References:  ( .. pending updates).   
    Oracle Documentation Library, http://www.oracle.com/pls/db10g/
    Oracle By Example (tutorials and links) http://www.oracle.com/technology/obe/obe10gdb/index.html
    Oracle JDeveloper Tutorials, http://www.oracle.com/technology/obe/obe1013jdev/index.htm

    W. Iverson, Hibernate: A J2EE Developer's Guide, Addison-Wesley,  0-321-26819-9  (paperback) 2005
    H. Oak, Oracle JDeveloper 10g: Empowering J2EE Development, A! Press,  2004, paperback  300pp,.
    S. Shenoy, N. Mallya, Struts Survival Guide, Object Source, 2004, paperback 220 pp, 0-9748488-0-8
    C. Nock, Data Access Patterns, Addison Wesley, 2004.
    S. Meunch, BC4J/JClient Performance Study, Oracle Technology Network,  Jan. 2004. pp. 30
    C. Millsap, Diagnosing Performance Problems, OTN,  Jan. 2004
    S. Bodoff et al.,The J2EE Tutorial, 2ed Ed., Addison Wesley Professional, 2004, paperback, pp. 1568
    R. Roos, Java Data Objects, Addison Wesley, 2003.
    S. Haines, "J2EE Performance Tuning", 2003,  informitIT.com   
    Apache Jakarta Project: Struts,  http://jakarta.apache.org/struts/learning.html
    JPetStore Demo,  <pending>
    H. Fosdick, DBA Certifications Compared: Oracle, DB2, SQLServer, dbazine.com.

Requirements and grading: 
    1.  Actively participate in progress, discussions, and small assignments.
         a)   install and use the software tools and servers covered in the course,
               keeping with the class schedule.
         b)   contribute class comments,  ask questions, respond to class discussion questions,
               via email, keeping with the class schedule.
   2.  Participate in shared  installation and extension of sample databases and applications
         from the lecture references.  Download files will be provided.
   3.  Contribute to tutorial web site for the course topics.
   4.  Contribute technical paper and presentation.
   5.  Contribute to project DB application.
     
    Grading will be subjective based upon submitted items. 
    Periodically, grade evaluations will be reported to the class.
   
last updated:  07/09/2008