Appendix B -- Database Schemas

The Northwind Database Schema

Figure B.1 is a schema diagram for the Northwind database. The diagram was generated in the SQL Server Enterprise Manager. The schema shows the tables in the Northwind database. The columns in each table and the relationships between the tables are shown. Use the schema diagram to understand the structure of the Northwind database when you are working with them in the examples and exercises in this training kit or whenever you use this sample database.

click to view at full size

Figure B.1 The Northwind database schema diagram

The Northwind_Mart Database Schema

Figure B.2 is a schema diagram for the Northwind_Mart database. The diagram was generated in the SQL Server Enterprise Manager. The schema shows the tables in the Northwind_Mart database. The columns in each table and the relationships between the tables are shown. Use the schema diagram to understand the structure of the Northwind_Mart database when you are working with them in the examples and exercises in this training kit.

click to view at full size

Figure B.2 The Northwind_Mart database schema diagram

The Library Database

Figure B.3 is a schema diagram for the library database. The diagram was generated in the SQL Server Enterprise Manager. The schema shows the tables in the library database. The columns in each table and the relationships between the tables are shown. Use the schema diagram to understand the structure of the library database when you are working with it in the examples and exercises in the appendices of training kit.

click to view at full size

Figure B.3 The library database schema diagram



Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net