Gangadhara MS (6/26/2014)
Gold and Silver - is this related to Partner? Or to the Service being provided?Its related to partner which they own it after meeting some sales criteria.
So it sounds like it should be modeled as an attribute of the Partner, not directly into the Services they provide.
i.e. - the Services table does not have this, only the different Services that can be related to any given Partner.
Direct and EA - are these related to SKU Group or the Service being provided?
Its for a different program of type Direct and EA and related to SKU group.
Ask yourself if this should be an attribute of the Partner.
Sounds kind of like where we used to have Direct Customers we sold to as individuals, and stores that we stocked.
Do i need to add any further here ? not sure about your suggestion Greg ?
Thanks for your help.
So I hope you are seeing some of this, like how the Partner provides Services, and the Gold and Silver are related to the Partner.
It sounds like any Services a Partner offers are Gold or Silver based on the Partner.
So if their volume increases, or decreases, you need to only change the attribute of the Partner, not all the Services.
Likewise, a table with the Services should only need to list the Services available, not have a Gold and Silver level Service listed.
Make sense?