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
andmarriage
, 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 ...
Get SQL Server™ 2005 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.