H1a:  Simple POS (Point of Sales) DataBase using Access.
       Keep track of customers,  sales ( items and tax),  and available  item information.
       Submit hardcopy of :  table schemas, relationship diagram,  sample populated tables.

H1b: VisualBasic.NET.
       Use a form, some controls (button, text area, etc.) to browse the data.
        Do not build the application. Submit hardcopy of:  form image, project structure window,  code for form.

H2.  Vocabulary & reference
     Search on the web.
     Provide definitions for ODBC, DAO, ADO, OLE.
     Provide references for some tutorial page for each of these items.

H3.  Direct SQL to Oracle
     Load the Access DB into Oracle using the loader.
     Perform some POS operations and queries using by directly entering SQL statements to SqlPlus listener.
     Include some join operation.
     Submit hard copy of the DB schema and log of the session.

H4.  Java App to Oracle
     Demonstrate simple connection and queries to buy some items and provide information feedback..
     Submit hard copy of source and screen snap shot(s).

H4b.   Java with dbAware components  ... not assigned
     Target:  not assigned
     Implement some POS interface and operations using  DBAware components.
     Submit disk with either (i) JAR file  or  (ii) bat file at the root level.

H5.  Write sql for class example 

H6 Web Access for DB
1. Build a web GUI for a partial version of POS  database.
    Show both text and numeric fields.
    Demonstrate a few operations (such as pick item, make purchase, delete items)  .
    Be sure to include a view to show all of the items in the data base
     (so that the grader can see that the database is being updated).
    Include a link to view the servlet source code  .
    Use servlets. Set up a Tomcat web server  .
    If you know how to do servlets...or have completed the assignment ... please provide help to others.
2. Send email to hankley with a live link to the primary web page.
     In order  to evaluate your work,  you must have a server running for some time after you send the email.
     If you start a server on one of the CIS machines, then it would be natural to connect to the Oracle database system.
     If you have a server on your own PC, you might connect to Access,  mySQL, or some other DBMS.
     On your web page, provide links for the server side source code (the servlet).

H7  Presentation (slides and some example)
Due: Topic selection due: 
        Presentations due  ... 
1.  For the topic you select (or get stuck with),
     develop a small demonstration of concept.
     Write a brief statement to explain what you will present to the class.
      Send zip file of the presentation and example files before your presentation day.
2.  Present to topic to the class. Explain the concept and the example code.

H8 Project
1. Due:  Topic selections as covered in class.
             Present project demonstration to the class (schedule a time).
             Documentation and disk / files due beginning of exam week.
2. Project goal:  Implement, test, document, and demonstrate a working DB application.
3. Milestones: provide sign-off  lines on the  project cover sheet.
   (1)  Draft statement of project work and features,
          use-case diagram;
          deployment diagram (in not on a single machine).
   (2)  Diagram model (class model or DB object model);
          listing of the schema details (printed from the DBMS).
   (3)  Sketches of GUI frames to illustrate major use cases.
          The user should not have to guess key item numbers or names.
          There should be confirmation the updates were completed.
          (Include some screen snapshots for the final report).
   (4)  Listing of sample populated DB;
          list of test cases  and instructions for test cases.
   (5)  class presentation ... depending upon time and class schedule
             or present demonstration to Hankley.
          (Instructor will run a few of the "key business" operations.)
   (6)  Submit documents and disks in a large envelop,
          with your name, class, and project information printed on the outside.
          Include:  the original sign-off sheet for project milestones,
                       a table of contents,
                       items (1-4) above,
                       statement of results of all tests,
                       installation instructions (such as for ODBC drivers),
                       guidance for users,
                       an annotated list of all files
                            (source for UI, DB code, scripts to populate DB,
                              bat files to run the application,
                              data files, etc.)
          end