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