From: klem s on 10 Nov 2009 16:33
Sql book Im reading uses extensively AdventureWorks database. But
its very difficult to follow since I dont 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.
Its 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?
From: Plamen Ratchev on 10 Nov 2009 17:16
Here is the ER diagram for the database:
Here is description of the business scenario and objects in the database:
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