Prev: Why can't recursive queries contain...?
Next: sp_MSforeachtable
From: klem s on 10 Nov 2009 16:33
Hi

Sql book I’m reading uses extensively AdventureWorks database. But
it’s very difficult to follow since I don’t know what exactly the
tables and their columns represent ( I realize each column has a
descriptive name like RevisionNumber, TaxAmt …but many of these terms
are confusing, especially when not seeing the larger picture ), and
how these tables ( aka what they represent in real world ) are
semantically related to each other.

It’s even that more difficult, since I know nothing about the finance/
business terminology used by the book to describe tables and their
columns ( terms like running total etc).

So is there a site(s) which would ( in layman terms ) help me answer
all of my questions?


thanx
From: Plamen Ratchev on 10 Nov 2009 17:16
Here is the ER diagram for the database:
http://www.microsoft.com/downloads/details.aspx?familyid=0f6e0bcf-a1b5-4760-8d79-67970f93d5ff&displaylang=en&displaylang=en

Here is description of the business scenario and objects in the database:
http://msdn.microsoft.com/en-us/library/ms124825.aspx
http://msdn.microsoft.com/en-us/library/ms124438.aspx
http://msdn.microsoft.com/en-us/library/ms124425.aspx

--
Plamen Ratchev
http://www.SQLStudio.com
From: klem s on 17 Nov 2009 13:19
Sorry for bot replying sooner, but I had my PC in repair.

Anyways, thank you for your help

 | 
Pages: 1
Prev: Why can't recursive queries contain...?
Next: sp_MSforeachtable