One of the things i was never expecting to like, was databases and analysis. Since i learned how to properlly use them in my studies, i applied to everything. I belive that the previous proper analyisis of projects and/or tasks makes easier for all the team to work as one, and reduces times of debugging and developing.

A solid base, can handle anything. But you cant build a steel base, on a swamp, because it will drown in the swamp. So here is my point, you need to know where and how to build before doing a solid work.

I allways like to start with a entity relation diagram, that almost make the database by itself, and you can easily create a flow char of the app and the ui from that point. Which finally leads to class diagrams to end the cake. 

As you can imagine, i cant show any of those diagrams, as they are part of running apps or videogames either web, windows or smartphones. But i can make you a quick analysis of any project in... like seconds during any intervew (Not braging, its one of my flaws, but it has his usefull side).