Installation
https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
Datawarehouse
OLTP
Schema
| 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 |