Session-by-session outline for 601 Module (M. Fogelman)

  1. Pretest, Overview and the Functional and Systems Role

  1. IT's Technology Focus and the Customer Orientations
  2. Product and culture issues
  3. Professional, Scholarly and Industry Literature
  4. "Book Reports," Executive Summary/Updates and Status Reports

  • Systems Development Life Cycle/Database Design Life Cycle
    1. Stages: Needs Analysis, Requirements Definition, Design, Coding and Testing, Implementation and Training, Maintenance and Evolution.
    2. Functional Decomposition vs. Data-Based Analysis
    3. Database Design as a Microcosm of or an alternative to Systems Evolution

  • Database Project Team Assignment
    1. Database Design
    2. Team Formation: Client/Analyst/Designer
    3. Your "Real Client"
    4. Technical Enviroment (What You'll See and Hear Out There.)
    5. Presentations in Third Normal Form

  • Flowcharting and Other Project Tools
    1. Classical Flowcharting
    2. Data-Flow Diagrams (Prof. Kavanagh)
    3. Other Structured Analysis and Logic Tools (Structured English/Pseudocode, Data element/Data element value tables, Decision Trees, Function Charts, I/O Charts, IPO Charts)
    4. Gantt and Other Project Charting Tools
    5. Automating Systems Development with Visio, Microsoft Project, CASE tools, Etc.
    6. Interfaces, Customizations, Conversion, "Go Live," Parallel Testing, Prototyping

  • The Technical Enviroment
    1. Software
      1. Client Server
      2. Middleware
      3. Thin Client/Fat Client Wintel PC/Java-Sun-Netscape NC debate
    2. Hardware: Commonly Used Types
      1. Networks
      2. Servers
      3. Routers
      4. Bridges
    3. Languages
      1. Comparison of Classical Through Modern Object Programming Languages
      2. SQL - Review and Practical Excerises
    4. Industry Jargon and Other Terminology
      1. Topology
      2. Protocol
      3. RAID

  • Relational Concepts and Tools: Normalization, SQL
    1. General Concepts: Review
    2. Design Issues
    3. Normalization
    4. Industry Leaders and Vendor Practices and Characteristics

  • Business Process Change and Workflow Analysis
    1. Evaluating and Selecting BPC Forms
    2. Workflow, Groupware and Document Management
        1. The Virtual Project
        2. Economic storage, retrieval and use of the organization's collective knowledge
    3. Knowledge Management: Adding intelligent agents/filters to Workflow system

  • Enterprise Resource Planning
    1. General Concepts
    2. Available Packages

  • Application Review Presentations
  • Database Presentations