In this article we have gone through some background on DotNetNuke. Then we explained the database schemas and constructed some SQL statements based on those schemas.  This gives us a good basis to begin creating our reports in the next part of the series.