S# |
Audit Area |
CheckList Item |
1 |
Tables |
Create sequence instead of
identity cols |
2 |
Create calculated fields for MVD
columns |
|
Create check contraints for
domain values |
3 |
|
4 |
Views |
Views are created only for joins, and filters |
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
|
|
11 |
|
12 |
|
40 |
Functions |
For complicated and reusable business logic |
41 |
|
42 |
|
44 |
|
45 |
|
46 |
Triggers |
For automatic operations, triggered by operations in the
database, like ontime calculation, logging, |
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
Procedures |
All operations should be
implemented on this level, not on the source code level |
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|