The sales_demo Database (XPS)

Your database server product contains SQL scripts for the sales_demo dimensional database. The sales_demo database provides an example of a simple data-warehousing environment and works in conjunction with the stores_demo database. The scripts for the sales_demo database create new tables and add extra rows to the items and orders tables of stores_demo.

To create the sales_demo database, you must first create the stores_demo database with the logging option. Once you create the stores_demo database, you can execute the scripts that create and load the sales_demo database from DB–Access. The files are named createdw.sql and loaddw.sql.