Database Testing: Orphan Records

This is the issue which the data are focusing on the assurances of the quality. Orphan records example are they not applicable to the system but still it is present to the system.Testing the data with different creation of scenario and cases is important to meet the quality results. There are different type of testing which can be use and one of this effective type is the Parallel Testing that the performances between the gap, functionality backend of Existing Database System and the New or Upgraded Database System. The different is the scenarios which the functionality has been changing
and updating the stored  procedure either from the existing database system and new database system (upgraded). The expected results should be the same from test scenarios created for the existing database system and new or updated database system.