|
MILESTONE 7 - SAMPLE CRUD TABLE
The CRUD Table lists all main processes or process modules of the system in the rows and all the files, tables, or record types in the columns. The intersection of processes and files is filled in with the actions taken by the processes on the respective tables. It is permited to put more than one action (such as Create and Update) in each cell.
The CRUD Table is a powerful tool for information systems maintenance, as it allows developers to identify the cascading effects of any changes made to any process or to any file.
CELL VALUE:
C = Create
R = Read Only
U = Update
D = Delete
Elementary Process |
Record Type |
| CUSTOMER |
ORDER
LINE |
ORDER |
INVENTORY |
| CREATE ORDER |
R |
C |
C |
R |
| PROCESS ORDER |
R |
U |
R |
U |
| CREATE CUSTOMER |
C |
|
|
|
| UPDATE CUSTOMER |
U |
|
|
|
| DELETE CUSTOMER |
D |
|
|
|
|
|