CISC224 Web Databases
Department of Science, Technology, Engineering & Mathematics: Computer/Information Science
Course Number and TitleCISC224 Web Databases
Number of Credits3 credits
Minimum Number of Instructional Minutes Per Semester2250 minutes
PrerequisitesCISC215 (C or better) or VAMM110 (C or better)
Other Pertinent InformationThe 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.
Catalog Course DescriptionThis 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.
Required Course Content and Direction
- create and maintain database for web interaction.
- retrieve, insert, update and delete data.
- control data/user access.
- utilize HTML to develop user interface
- handle runtime errors
- control transactions with both Client-side and Server-side scripts.
- describe use of compiled Web Server programs.
- use basic SQL *Plus commands to select and modify existing records in a data base.
Planned Sequence of Topics and/or Learning Activities:
- Web basics, protocols, web addresses
- Theoretical, Conceptual and Physical Aspects of RDBMS.
- Need for creating dynamic web pages
- Mechanics of using our system
- Creating, Inserting and Updating databases
- Structured Query Language
- Creating queries
- Performing Calculations
- Basic tags
- Web Servers
- Installing and Using Personal Web Server
- Accessing our WebServerrr
- Site Performance factors
- Utilization of our WebServer with RDBMS
- Programming Choices
- Languages that work with the web (Java, C#,.net)
- Other application programs that help in development (Cold Fusion, PHP, etc)
- Client-side Scripts
- Debugging Techniques
- Server-side Scripts
- Creating a Web Application
- Compiled Web Server Programs
- Common Gateway Interface
- Active X DLLs
Assessment Methods for Core Learning Goals:
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.
Teaching Methods Employed150 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