Data Dictionary and Other Design Tools

1
Data Dictionary and Other Design Tools

• Dr. Merle P. Martin
• CSU Sacramento

2
Agenda

• The Structured Approach
• Data Dictionary
• Decision Tables
• Structured English

3
Structured Approach

• Figure 11-1, page 349

4
Data Dictionary

• Relationships of entities
• Figure 6-3, page 350
• Notation
• Figure 11-4, page 351
• Data Process
• Figure 11-5, page 354

5
Data Dictionary (continued)

• Data Dictionary entry
• Figure 11-6, page 354
• Data Store entry
• Figure 11-7, page 355
• Data Element entry
• Figure 11-8, page 356

6
Data Dictionary (continued)

• Relationship to COBOL
• Data Stores / Flows
• FD / 01 Levels
• Data Elements
• 05 Levels
• Data Processes
• PROCEDURE DIVISION

7
Decision Tables

• Generic - Fig. 11-9, pg. 356
• Mutual Exclusivity
• Megavideo Initial Table
• Figure 11-10, page 358
• Simplified Table
• Figure 11-11, page 360
• Example

8
Exercise

• What three (3) MIS courses should I
  take next semester?
• Conditions?
• Decision rules?
• Actions?
• Action entries?
• Simplification?

9
Structured English

• Chapter 17
• Figure 11-17, page 365
• Converts directly to COBOL
• and other languages
• Example

10
Concepts to Remember

• Structured Approach
• Figure 11-2
• Data Dictionary Elements
• Relationship to COBOL
• Decision Tables
• Structured English