Fix Implementation Deficiencies of Database Structure Presenter: Rueen-Fang Wang, Ph.D., P.E.

1. Fix Implementation Deficiencies of Database StructurePresenter: Rueen-Fang Wang, Ph.D., P.E.

2. Topics • Purpose of this task • Deficiencies identified • Steps to resolve deficiencies • Current status • Remaining tasks 2

3. Purpose • To address issues discussed in the Panel’s subcommittee presentation (June 2007 ): • Enforce meaningful referential integrity • Enforce meaningful data uniqueness

4. Deficiencies Identified in the Initial Implementation • Related to referential integrity: • Arc relationship • Logical deletion • List Item reference • Related to meaningful uniqueness • Database Uniqueness rules

5. Identified Deficiency 1 –Arc Implementation

6. Identified Deficiency 2 –DELETED_DATETIME column

7. Identified Deficiency 3 –List Item Implementation

8. Identified Deficiency 4 –Meaningful Data Uniqueness

9. Steps to Resolve Deficiencies • Review and develop adequate database rules as necessary • Identify existing problematic data and the associated causes • Develop solutions to clean up the data and fix application • Develop and impose DB constraints and triggers to enforce database rules

10. Current Status

11. Remaining Tasks

12. Questions?