The ProjectPal Database
Let’s get our hands a little dirtier by looking at the data, code, and techniques used to create the ProjectPal system.
Not all the code in the ProjectPal system is here because of space constraints and the fact that some of the code is quite repetitive. However, you can download the full source code, as mentioned at the beginning of this chapter, or play with it online at www.project-inspiration.com/projectpal.
The ProjectPal system uses SQL Server 2000 as its main datasource. The system is made up of various tables, views, and stored procedures. Throughout this section, I assume you have knowledge of SQL Server, SQL Queries, and basic Transact SQL.
The Database schema used by the ProjectPal system is ...