MS SQL Server Interview Question:

How AdventureWorksLT tables are related?

Submitted by: Administrator

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
<pre>s.name t.name t.type_desc
dbo 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</pre>

Here is an ER (Entity Relation) diagram presented on Jasmin's photo galary:
AdventureWorksLT ER Diagram.
Submitted by: Administrator