Hello Guys,

All, this is a very general question but I'd love to get some input. Recently I've had a few projects assigned to me that involve delving into a database designed by someone else and trying to find and troubleshoot the errors and make improvements. The initial assignment is listed as "gain an intimate understanding of the workings of the database." These databases have hundreds of objects and hundred of pages of codes to go through.

Does anyone have any tips for how to gain a quick understanding of a new-to-you database?
Is there some sort of mystical magical map that would show me how everything works without clicking on every object and looking for dependencies or viewing database documenter files for every object?


Thanks

I didn't find the right solution from the internet.
References:
- http://www.accessforums.net/showthread.php?t=67265
- Management consultancy video Examples.

http://www.sql.ru/forum/1267694/taking-over-someone-else-s-database