CISC224 Web Databases

Department of Science, Technology, Engineering & Mathematics: Computer/Information Science

I. Course Number and Title
CISC224 Web Databases
II. Number of Credits
3 credits
III. Minimum Number of Instructional Minutes Per Semester
2250 minutes
IV. Prerequisites
CISC215 (C or better) or VAMM110 (C or better)
Corequisites
None
V. Other Pertinent Information
The use of hands-on development is tightly integrated into the presentation of the course materials. Students will be evaluated in various methods including, but not limited to, exercises, written tests, and various programming projects that will be completed out of the classroom.
VI. Catalog Course Description
This course covers the development and utilization of web-enabled databases. Students will use Relational database as a backend to a web delivered interface. Both Client-side and Server-side processing will be used to create dynamic web pages.
VII. Required Course Content and Direction
  1. Learning Goals:

    1. create and maintain database for web interaction.
    2. retrieve, insert, update and delete data.
    3. control data/user access.
    4. utilize HTML to develop user interface
    5. handle runtime errors
    6. control transactions with both Client-side and Server-side scripts.
    7. describe use of compiled Web Server programs.
    8. use basic SQL *Plus commands to select and modify existing records in a data base.
  2. Planned Sequence of Topics and/or Learning Activities:

    1. Foundations
      1. Web basics, protocols, web addresses
      2. Theoretical, Conceptual and Physical Aspects of RDBMS.
      3. Need for creating dynamic web pages
    2. RDBMS
      1. Overview
      2. Mechanics of using our system
      3. Creating, Inserting and Updating databases
    3. Structured Query Language
      1. Creating queries
      2. Performing Calculations
    4. HTML
      1. Basic tags
      2. Tables
      3. Hyperlinks
    5. Web Servers
      1. Installing and Using Personal Web Server
      2. Accessing our WebServerrr
      3. Site Performance factors
      4. Utilization of our WebServer with RDBMS
    6. Programming Choices
      1. Languages that work with the web (Java, C#,.net)
      2. Other application programs that help in development (Cold Fusion, PHP, etc)
    7. Client-side Scripts
      1. Forms
      2. VBScript vs. JavaScript
      3. Use of Cookies
      4. Debugging Techniques
    8. Server-side Scripts
      1. ASP
      2. Creating a Web Application
    9. Compiled Web Server Programs
      1. Common Gateway Interface
      2. Active X DLLs
  3. Assessment Methods for Core Learning Goals:

  4. Reference, Resource, or Learning Materials to be used by Students:

    Departmentally selected textbook. Details provided by the instructor of each course section. See Course Format.
VIII. Teaching Methods Employed
150 minutes will be devoted per week to text material and special projects. Students will be completing various computer-based activities and accessing various resources that will be available on-line.

Review/Approval Date -3/02