easy computer work_lab9296

The AdventureWorks database contains many tables; we will be using only some of those tables in the course. Below is an ER diagram showing the tables in the AdventureWorks database that we will be using. NOTE: Not all the relationship lines are drawn between the tables in this diagram. To find relationships between tables you may have to look for matching field names.

Product (Production)

ProductID

Name

ProductNumber

MakeFlag

FinishedGoodsFlag

Color

SafetyStockLevel

ReorderPoint

StandardCost

ListPrice

Size

SizeUnitMeasureCode

WeightUnitMeasureCode

Weight

DaysToManufacture

ProductLine

Class

Style

ProductSubcategoryID

ProductModelID

SellStartDate

SellEndDate

DiscontinuedDate

rowguid

ModifiedDate

ProductCategory (Production)

ProductCategoryID

Name

rowguid

ModifiedDate

ProductSubcategory (Production)

ProductSubcategoryID

ProductCategoryID

Name

rowguid

ModifiedDate

ProductCostHistory (Production)

ProductID

StartDate

EndDate

StandardCost

ModifiedDate

SalesOrderHeader (Sales)

SalesOrderID

RevisionNumber

OrderDate

DueDate

ShipDate

Status

OnlineOrderFlag

SalesOrderNumber

PurchaseOrderNumber

AccountNumber

CustomerID

ContactID

SalesPersonID

TerritoryID

BillToAddressID

ShipToAddressID

ShipMethodID

CreditCardID

CreditCardApprovalCode

CurrencyRateID

SubTotal

TaxAmt

Freight

TotalDue

Comment

rowguid

ModifiedDate

SalesOrderDetail (Sales)

SalesOrderID

SalesOrderDetailID

CarrierTrackingNumber

OrderQty

ProductID

SpecialOfferID

UnitPrice

UnitPriceDiscount

LineTotal

rowguid

ModifiedDate

SalesPerson (Sales)

SalesPersonID

TerritoryID

SalesQuota

Bonus

CommissionPct

SalesYTD

SalesLastYear

rowguid

ModifiedDate

SalesTerritory (Sales)

TerritoryID

Name

CountryRegionCode

[Group]

SalesYTD

SalesLastYear

CostYTD

CostLastYear

rowguid

ModifiedDate

Contact (Person)

ContactID

NameStyle

Title

FirstName

MiddleName

LastName

Suffix

EmailAddress

EmailPromotion

Phone

PasswordHash

PasswordSalt

AdditionalContactInfo

rowguid

ModifiedDate

CountryRegion (Person)

CountryRegionCode

Name

ModifiedDate

Employee (HumanResources)

EmployeeID

NationalIDNumber

ContactID

LoginID

ManagerID

Title

BirthDate

MaritalStatus

Gender

HireDate

SalariedFlag

VacationHours

SickLeaveHours

CurrentFlag

rowguid

ModifiedDate