⟩ How AdventureWorksLT tables are related?
There are 12 user tables defined in AdventureWorksLT:
USE AdventureWorksLT
GO
SELECT s.name, t.name, t.type_desc
FROM sys.tables t, sys.schemas s
WHERE t.schema_id = s.schema_id
ORDER BY s.name
GO
s.name t.name t.type_descdbo BuildVersion USER_TABLE
dbo ErrorLog USER_TABLE
SalesLT Address USER_TABLE
SalesLT Customer USER_TABLE
SalesLT CustomerAddress USER_TABLE
SalesLT Product USER_TABLE
SalesLT ProductCategory USER_TABLE
SalesLT ProductDescription USER_TABLE
SalesLT ProductModel USER_TABLE
SalesLT ProductModelProductDescription USER_TABLE
SalesLT SalesOrderDetail USER_TABLE
SalesLT SalesOrderHeader USER_TABLE
Here is an ER (Entity Relation) diagram presented on Jasmin's photo galary:
AdventureWorksLT ER Diagram.