SQL Server™ 2005 Bible

Appendix B. Sample Databases

In This Appendix

• The file list, background, requirements, diagrams, and descriptions for the five sample databases

In addition to Microsoft's Adventureworks sample database, this book draws examples from the following five sample databases, each designed to illustrate a particular design concept or development style:

• Cape Hatteras Adventures is actually two sample databases that together demonstrate upsizing to a relational SQL Server database. Version 1 consists of a simple Access database and an Excel spreadsheet—neither of which is very sophisticated. Version 2 is a typical small- to mid-size SQL Server database employing identity columns and views. It uses an Access project as a front end and publishes data to the Web using the SQL Server Web Publishing Wizard and stored procedures.

• The OBXKites database tracks inventory, customers, and sales for a fictitious kite retailer with four stores in North Carolina's Outer Banks. This database is designed for robust scalability. It employs GUIDs for replication and Unicode for international sales. In various chapters in the book, partitioned views, full auditing features, and Analysis Services cubes are added to the OBXKites database.

• The Family database stores family tree history. While the database has only two tables, person and marriage, it sports the complexities of a many-to-many self-join and extraction of hierarchical data.

• Twenty-five of Aesop's Fables provide the text for Chapter 13, "Using Full-Text ...