CIS560 Assignments  Fall 2004

1.  Basic vocabulary:
     Submit a conceptual graph of vocabulary words for Chapter 1 (paper copy).
2.  Relational DB using M.S. Access:
     A "mini-university" example was defined in recent lectures.
     It incorporates entities, an "entity-subentity" pattern, a many-to-many relationship, and a lookup table.
      Implement part of the mini-university example in Access:
        Consider:  Students,  Courses,  Classes,  enrollment+grades.
       (show conceptual design in UML and implementation design as schema diagram
         for review before implementing the db).
        Enforce referential integrity constraints, populate the tables,
         build at least two non-trivial queries, and one form.
        Submit screen snapshots of all aspects.
3.  Knowing SQL syntax:
     Write or draw syntax rules for the subset of SQL that is covered in Chapter 7.
4.  Direct access to Oracle using SQL via SqlPlus program:
     Create and populate some the mini-university tables.
     Execute two "interesting" queries
     (as:  report all students in this section of CIS560 this semester,
         and report all students who have ever taken CIS560
         or   report students who have never taken CIS56).
     Submit hard copy of the table structure,  populated data,
     source and results of the queries.
5.  Sample SQL queries for select, update,  select with aggregation functions:
     Work 2 examples each from 3.5, 3.8, and 3.10  (see sample problem sheet).
     Present and explain solutions during class discussion; submit written solutions..
6.  Java client with JDBC connection to (4):
     Build a Java client with "nice" GUI interface with features for:
         - at least one "add item" operation
         - one get item info from the DB using interactive select (rather than entry of the key)
         - and one interesting query  that returns a  multi-row result set
                (the result should be readable; it show show meaningful  fields , and not encoded FK's).
     The program must have a application-GUI-model-dataAccess architecture.
     Submit CD with source, classes, and the necessary JDBC driver.
6.  Web client for (4):
      As a first step, set up a CIS web page with your name, picture,  email link,  and 560_web link.
      Build a web client with at least some of the features of (6).
      Use servlets in Tomcat.  Provide a link to see the source code (you may send it by email).
      When the server is running,  send an email with a live link to the client start page and a link to the source code..

7.  Class presentation:
     Select a topic (subject to approval),
     schedule the presentation (see Log page),
     submit slides in advance of the presentation,
     present talk to the class (see criteria for slides and presentation).

8.  DB project:
     Select one of the four DB projects,
     submit initial documents for review of:
          requirements (use case model),
          design ( domain model, GUI design, some sequence model),
          implementation (table model,  test plan);
      keep the sign-off sheet for the project reviews,
      keep a log of  project work and hours.
      Present project demo (in class or to instructor);
      submit final report: 
            sign-off sheet,  summary of hours and lines-of-code,
            hard copy and source files of design documents,
            program source files,
            for Java app:  CD with working bat file
            for web app:  deployable files and instructions, and working URL.