AdventureWorks2008R2 BusinessRules Missing Documentation

Question

While trying to understand how the AdventureWorks200R2 database is working, i found some businessrules that confused me:

CK_Product_Class => Must be in string "hmlHML" or null

CK_Product_ProductLine => Must be in string "rmtsRMTS" or null

CK_Product_Style => Must be in string "umwUMW" or null

What does the letters mean?

Where can i found a compelte documentation about the database? All i find was a database diagram *sick*

Thanks in advance for reply...

Answer 1

Documentation can be found here:

http://technet.microsoft.com/en-us/library/ms124438(v=sql.100).aspx

http://technet.microsoft.com/en-us/library/ms124425(v=sql.100).aspx

The 2008 and 2008 R2 documentation is the same.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

Thats what i am looking for - thanks for the links.

How can i find that kind of links by myself?

Answer 3

I just did a search using Google :-)

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 4

Has your question been answered?  If so, please click Mark as Answer on the reply which answered your question.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript