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 for 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