Course Description

An introduction to technologies of current importance in information management application development, such as database management, computer graphics, artificial intelligence, and web development. Prerequisite: CS 2020.

Course Syllabus

1. Java overview [4 weeks]
   1. Language basics (2 hours)
      1. similarities/differences from C++.
      2. types, control structures
      3. program organization
      4. importing
      5. Editing, compiling, running a java program.
   2. Applets (4 hours )
      1. Creating and running an applet
      2. Using an IDE
      3. GUI creation. AWT? SWING?
      4. GUI event handling
   3. Graphics and Applets (6 hours)
      1. Notion of a graphics window/canvas
      2. Key graphics primitives, e.g. drawline, drawArc
      3. Setting attributes, line thickness, Color
      4. Java Graphics object
      5. Event Handling
      6. Detained vs immediate mode, Display Lists
2. Databases [at least 3 weeks]
   1. Database basics
      1. Introduction to information systems
      2. History and motivation
      3. Components and functions of database systems
      4. Database architecture
      5. Data dependency
   2. Introduction to SQL
      1. Table creation: create, alter and drop
      2. Retrieval: various forms of select
      3. Update: insert, update, delete
      4. Database connectivity (embedded SQL, ODBC)
3. Artificial Intelligence (AI) [at least 2 weeks]
   1. Overview (1 hour)
   2. Search space and constraint satisfaction
      1. Brute Force
      2. Depth first
      3. Breadth first
      4. Minimax search
      5. Heuristics
4. Web Application Development [4 weeks]
   1. Internet protocols (brief overview)
      1. TCP/IP and Application protocols: HTTP, FTP, and Email
   2. Markup Languages (brief overview)
      1. Hypertext Markup Language (HTML)
      2. Extensible Markup Language (XML)
      3. Extensible Hypertext Markup Language (XHTML)
      4. Cascading style sheets
      5. Use of web development software (e.g. Dreamweaver)
   3. N-tier architecture
      1. Presentation tier
      2. Business logic tier
      3. Data access tier
      4. Data tier
   4. Server-side scripting
      1. Java Server Pages (JSP)
   5. Client-side scripting (Javascript)

This syllabus indicates the topics covered but not the order of coverage.

Lab exercises

Programming assignments will be given using database, graphics, and artificial intelligence. A web project will be assigned that integrates all of the material taught in this course.