Portable semantic artifact · version 1

Northwind relational model

Thirteen tables form a commerce system spanning sales, catalog, fulfillment, organization, and customer segmentation.

Northwind relational modelThirteen tables form a commerce system spanning sales, catalog, fulfillment, organization, and customer segmentation. Standard semantic detail active. Generated legend with 4 items across 4 sections: Entities, Table (13); Groups, Group (5); Relationships, Foreign key (13); Active view, Standard detail (1).Northwind relational model. Thirteen tables form a commerce system spanning sales, catalog, fulfillment, organization, and customer segmentation. 13 nodes and 13 relationships. Customers foreign key Orders (places). Employees foreign key Orders (owns). Shippers foreign key Orders (ships via). Orders foreign key Order Details (contains). Products foreign key Order Details (ordered as). Categories foreign key Products (classifies). Suppliers foreign key Products (supplies). Employees foreign key Employees (reports to). Employees foreign key Employee Territories (assigned). Territories foreign key Employee Territories (covered by). Region foreign key Territories (contains). Customers foreign key Customer Customer Demo (segmented as). Customer Demographics foreign key Customer Customer Demo (categorizes).Standard semantic detail active.Generated legend with 4 items across 4 sections: Entities, Table (13); Groups, Group (5); Relationships, Foreign key (13); Active view, Standard detail (1).placesownsships viacontainsordered asclassifiessuppliesreports toassignedcovered bycontainssegmented ascategorizesSales and customersCustomer accounts, orders, and line items.Product catalogProducts, categories, and suppliers.FulfillmentShipping provid…Organization and territoriesEmployees, reporting lines, regions, and territory assignments.Customer segmentationCustomer demographic categories and their assignments.CustomerstableOrganizations t…OrderstableCommercial orde…Order DetailstableProducts, quant…ProductstableSellable produc…CategoriestableProduct classif…SupplierstableOrganizations t…ShipperstableCarriers respon…EmployeestableStaff members w…Employee TerritoriestableAssociates employees with…TerritoriestableSales territori…RegiontableTop-level geogr…Customer DemographicstableReusable descriptions of cu…Customer Customer DemotableAssociates customers with dem…GENERATED LEGEND · PRESENT SEMANTICS ONLYEntitiesTable (13)GroupsGroup (5)RelationshipsForeign key (13)Active viewStandard detail (1)