Task #3
uThe Problem:
ØLarge number of tables in a hierarchical structure that represents an application
§Customer A has address B, confirmed by person C, with phone D …
uThe Task:
ØCreate a full copy of the application in the same database with new IDs preserving all parent/child relationships.
uEnvironment:
ØSingle-column primary key
ØFK for all relationships
ØUniversal sequence for all objects
uSolution:
ØUniversal clone mechanism