Course #:WA1830

System Design Training

The workshop divides design into Preliminary Design, External Design and Internal Design. Preliminary Design accomplishes the transition from analy-sis and determines the technical architec-ture of the system. It also decides what processes and data will reside on which processors. External Design is design from the viewpoint of the user. It defines dialogue flow and provides screen and report design. Internal Design is design from the viewpoint of the builder. It op-timizes the data, structures the logic and defines interfaces.

It uses the same case study as BAA. You complete the course with experi-ence in design.

The workshop provides a full dis-cussion of logical data base design. You will learn how to apply safe and aggres-sive trade-offs for optimizing the data. Safe trade-offs optimize the data without compromising integrity and redundancy. Aggressive trade-offs optimize the data while providing some compromise of integrity or redundancy.

What you will learn
Upon successful completion of this course, the student will be able to understand:

  • A step by step way to do design
  • The use of analysis results in design
  • How to do a design that meets business requirements
  • How to optimize (de-normalize) data
  • How to design code that conforms to the latest design principles
  • How to use task analysis to design screen flow
  • How to design screens and reports
  • How and when to prototype
  • The different forms of prototyping
  • What design must deliver to implementation


  • Designers
  • CASE specialists
  • Data Analysts
  • Systems Analysts
  • Programmers
  • Data/Database Administrators

To get the most out of design, it is advis-able that you have an understanding of analysis. This can be achieved by attend-ing our BAA workshop or having equivalent experience.
4 days

Outline of System Design Training

1. Introduction to Design

  • Overview of analysis
  • Deliverables from analysis
  • How to tell the data model is done
  • How to tell the process model is done
  • Role of analysis deliverables in design

2. Overview of Design

  • Characteristics of design
  • Stages of design
  • Tasks of design
  • Deliverables of design
  • The progression of deliverables from analysis to design
  • Transition from BAA deliverables

3. Preliminary Design

  • Transition to design
  • The technical architecture of a system
  • The application architecture
  • Types of systems
  • Host based
  • Distributed computing
  • Object-oriented
  • Determine scope of design
  • Determine automation boundary
  • Assign process to processors
  • Define batch, on-line, real time proc-esses
  • Assign data to processors

4. Presentation Design

  • Presentation design principles
  • Perform task analysis
  • Perform usability analysis
  • Types of dialogues
  • Data maintenance
  • Inquiry
  • Transactional
  • Designing the flow of screens/reports
  • Screen/report layout design

5. Prototyping

  • Definition of prototyping
  • Four kinds of prototyping
  • Application of kinds of prototyping
  • Tasks of prototyping
  • Prototyping the dialogue flow
  • Prototyping screen design

6. Data Design

  • Safe design trade-offs for optimization
  • Aggressive design trade-offs for optimi-zation
  • Integrity modules
  • Conversion to target DBMS

7. Function Design

  • Principles of good module design
  • Business level module design
  • Detailed level module design
  • Reusable modules
  • Module specification

8. Interface Design

  • Introduction to interfaces
  • Interface data design
  • Interface module design

9. Object Oriented Design

  • Definition of terms
  • Use of analysis models
  • Object design models

10. Client Server Design

  • Layered design:  data, presentation, function
  • Communication via message passing
  • Advantages of layered design


11. Managing Design

Access path analysis
Data usage mapping
Transaction load analysis
Performance analysis

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.