Analysis › Detailing the Business Rules › Lesson Activity › Add the Process Logic to DELETE GOLFER

Add the Process Logic to DELETE GOLFER

Try performing the Process Logic Analysis for this process using the following outline. Then turn the page and compare your answers to the ones we have suggested.

1. What is the primary entity type that is the focus of the process DELETE GOLFER?

   ____________________________________________________________________

2. What is the entity action to be taken on this entity type?

   ____________________________________________________________________

3. Walking the neighborhood, are there any other entity types or actions required of this process?

   ____________________________________________________________________

   ____________________________________________________________________

4. Sequence the actions.

   ____________________________________________________________________

   ____________________________________________________________________

5. Determine the selection criteria.

   ____________________________________________________________________

   ____________________________________________________________________

Now, look at our suggested answers:

1. What is the primary entity type that is the focus of the process DELETE GOLFER?

   GOLFER

2. What is the entity action to be taken on this entity type?

   DELETE

3. Walking the neighborhood, are there any other entity types or actions required of this process?

   If we are going to delete the GOLFER, the Toolset requires us to first establish currency on GOLFER. There are two ways to establish currency:

   • Create an occurrence of the thing that you want to establish currency with
   • Read an existing occurrence of the thing

   In this case, we want to read an existing occurrence of golfer. In walking the neighborhood, golfer has an optional relationship to SCORING RECORD, which means golfers can exist without scoring records. However, SCORING RECORD has a mandatory relationship to GOLFER. If there are scoring records attached to a golfer, and we delete the golfer, what happens to the scoring records? Since scoring records cannot exist without the golfer, deleting the golfer will automatically delete the scoring records. The Toolset provides the capability to modify these referential integrity rules if desired. There are no other actions or entity types required.

4. Sequence the actions.

   We have identified two actions, a delete, and a read. Prior to deleting the golfer, we must first establish currency. Currency is established by reading the golfer. Therefore, the sequence of actions is as follows:

   1. Read the golfer.
   2. Delete the golfer. Deleting the golfer will automatically delete any scoring records maintained by it.
5. Determine the selection criteria.

   We will select the desired golfer based on its identifier.

Now we can add the process logic to the DELETE GOLFER process action diagram.