Information Systems Analysis, Modeling, and Design

The purpose of the individual system analysis and design project is to make it into a real-world project.
Ticket purchase system (airline, train, cruise, concert, or others)
Project Deliverables
The project requires students to perform (a) requirements analysis, (b) system and database design, and (c) a project plan. The planning part requires the use of MS Project software.
Title page (project name, author, and date)
Phase 1: Requirement analysis

  1. Problem definition
  2. Issues
  3. Objectives
  4. Requirements
  5. Constraints
  6. Description of the proposed system
  7. Logical model design
  8. Data flow diagrams

Context diagram/Diagram 0/Diagram 1
[Diagram 1 is optional]
Descriptions of processes in each diagram

  1. Descriptions of outputs/inputs/performance/security or controls
  2. Specific requirements, if any (interface, operational, resource, performance, etc.)

Phase 2: System and database design (Physical model design)

  1. User interface

Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.

  1. How data will be input to the system?
  2. The physical layout for each input
  3. The input design and procedures
  4. How data will be output from the system?
  5. The physical layout for each output
  6. The output design and procedures
  7. Data design

Develop a physical plan for data organization, storage, updating, and retrieval.

  1. Database design
  2. Database tables with their attributes should be presented (however their implementations are not required)
  3. Primary key(s) should be identified in each table, if any
  4. Three steps of normalization should be included.
  5. Entity-relationship diagrams
  6. Data file storage and access
  7. System architecture

Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.
Phase 3: Project plan (Microsoft Project)
A list of tasks or activities needed for implementing the proposed system
Estimating completion time and costs
A project schedule for performing those activities (Gantt charts or PERT charts)