This is a continuation of the ongoing TeraTech Development Approach from last month.
3. Database Review
The data structures from step 1 are reviewed by the architects to determine if any redesign is required for the new system. The following factors will be considered:
-Normalization of the data structures
-Change the databse platform (ie convert from MS Access to SQL Server)
-Data cleanup or correction
Conversion and data correction plans are prepared based on this analysis and then discussed with NJ Sullivan Database Administrators (DBA’s).