SQL Server - Adventure Works Sample Schema

Installation

Datawarehouse

DWH

OLTP

Schema

From Schema in AdventureWorks

Schema Contains objects related to Examples
HumanResources Employees of Adventure Works Cycles. Employee Table, Department Table
Person Names and addresses of individual customers, vendors, and employees. Contact Table, Address Table, StateProvince Table
Production Products manufactured and sold by Adventure Works Cycles. BillOfMaterials Table, Product Table, WorkOrder Table
Purchasing Vendors from who parts and products are purchased. PurchaseOrderDetail Table, PurchaseOrderHeader Table, Vendor Table
Sales Customers and sales-related data. Customer Table, SalesOrderDetail Table, SalesOrderHeader Table

Documentation / Reference


Powered by ComboStrap