Product Availability

Product Availability

An organization sells products in many countries. The logical data model below captures which product is available in which country. There are about 100 data elements in the Product entity, only a few being shown in this model:


Although certain data elements such as Product Name must be populated for all countries, there are other data elements such as Product Frozen Indicator that are only relevant for certain countries. Product Frozen Indicator for example, might be a required data element for Mexico but should never be considered for Canada.

So for this challenge, how would you capture the business rule that certain product data elements are only relevant and required for certain countries?

Product Availability

Read the response to this challenge


Leave a reply

Your email address will not be published. Required fields are marked *