CRUD Analysis

1
CRUD Analysis
2
CRUD Process

• From the process definitions identify the
  processes within the system. List in the rows of
  a spreadsheet.
• From the data definitions identify the Entities
  within the system. List in the columns of the
  spreadsheet
• Identify the relationship type between each
  Entity and its associated processes (is it
  Created, Referenced, Updated or Deleted).
• Record the relationship between the Entity and
  Process in the cells of the Spreadsheet.

3
Context Diagram
4
Level 0 DFD
5
Data Stores

• ACCOUNT LEDGERS (D1)
• Data elements
• MEMBER NUMBER
• CHARGE CODE
• CHARGE DATE
• SALE LOCATION CODE
• CHARGE AMOUNT
• MEMBER TYPES (D4)
• Data elements
• MEMBER TYPE
• MONTHLY DUES AMOUNT
• MONTHLY MINIMUM CHARGES

• MEMBERS (D2)
• Data elements
• MEMBER NUMBER
• LAST NAME
• FIRST NAME
• STREET
• CITY
• STATE
• ZIP
• MEMBER TYPE
• CURRENT BALANCE
• CHARGE CODES (D3)
• Data elements
• CHARGE CODE
• CHARGE DESCRIPTION

6
ERD
7
Ridgeway Example
Processes
8
CRUD Process

• Check to ensure that a Create process exists for
  each Entity, otherwise how does it get known to
  the system.
• Check that there is a Delete process for each
  Entity, otherwise the system will get bigger and
  bigger . Archiving the data to back-up could be
  classed as a delete.
• Check that there are Reference and Update
  processes for each Entity, otherwise why does the
  Entity exist?