Entity Design Question
-
I am working and studding the AdventureWorks database and I am tring to come to grips on the Vendors and PurchaseOrderHeader and all the related tables to the Vendors entity.
It looks like to me that Vendors can be customers that purchase goods from a company, and it also looks like Vendors can be a company's supplier. Because I would only believe that vendors would be a customer until I see the relation to the ProductVendor table. Then this leaves me believing that Vendors is actually a supplier of products.
The credit rating in the Vendors table leads me to believe that Vendors are customers.
Here is the Schema that I am referring to:
Thank you for any elaboration on this area.
Erik
Dam again!
-
AFCC Inc. Com (5/27/2008)
It looks like to me that Vendors can be customers that purchase goods from a company, and it also looks like Vendors can be a company's supplier. Because I would only believe that vendors would be a customer until I see the relation to the ProductVendor table. Then this leaves me believing that Vendors is actually a supplier of products.The credit rating in the Vendors table leads me to believe that Vendors are customers.
The Vendors are suppliers only, not customers.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply