|Case Study : Database Audit|
Key Points :-
This requires a diagram or report showing the major Tables in the Database, along with record counts. We have a Script for Oracle, listed under Data Analysis,to do this. A Neat solution, if it is available to you, is to reverse engineer a Database into a Data Modelling Tool, such as DataArchitect or ERWin. This allows you to create a diagram of a Data Model for the Database.
|1||Define the Database design||Preferably by Reverse Engineering||Database Diagram|
|2||Check Data Values||Look for invalid Data||Action Plan|
|1||Data Management Review Archives|| || |