| 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 | ||