¤ Create summary diagram -
Select or create a subset diagram for the entity types that support the processes for the design area. Record the location and time period for which the volumes on the diagram will apply.
¤ Identify entry point
For each process that is to be given automated support and that will execute in the selected operational environment, and for each entity type used by the process, identify the selection condition. Entities are selected in two ways: by way of one or more relationships, and from the values of one or more attributes. The attributes used are entered onto the summary diagram in a large arrow pointing to the entity type or subtype.
When design for the selected database management software is affected by whether a relationship is used in one or in both directions, use of the relationship may optionally be indicated by a smaller arrow pointing to the target end of the relationship line.
¤ Note integrity rules -
Add, to the entity type or relationship in the diagram, the identifying numbers of any integrity rules that are cited in the process logic or that are documented in the data model.
¤ Calculate frequency of use
Frequency of use is a function of the number of times the entity is selected by a selection condition during a single execution of the process, and the number of times the process is executed in a time period for the specified operating environment. Add the frequency to the total usage of the entry point by previously analyzed processes.
¤ Check use of identifiers
Match the attribute list of each entity type with the selection conditions. Is each identifying attribute used by the group of processes analyzed in at least one entry point? Are additional selection conditions needed to support inquiry or other processes for which no detailed process logic analysis exists? Add any additional necessary entry points to the summary diagram.
» Creates deliverable D4.7.3 Data Structure Specification.
» Creates deliverable D4.7.4 Data Structure Summary Diagram.
Previous : This is the first Sub-Activity of Activity A4.3
Activity Overview : A4.3
Stage Overview : Design Stage
Overview : Table of Contents