Product Recommendation and Offer

This ERD (see the following figure) provides a method for managing product recommendations for up-sell or cross-sell. Product Recommendation allows the user to clearly define the messages, the set of possible responses, and the recommendation itself. Similarly, Product Offer allows the user to clearly define the messages, the set of possible responses, the set of actions for the offer responses, the set of parameters for the offer response, and the offer itself

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Communication	S_COMMUNICATION
Product Line	S_PROD_LN, S_PROD_LN_PROD
Product Message	S_PROD_MSG
Product Message Response	S_PROD_MSG_RESP
Product Message Variable	S_PROD_MSG_VAR
Product Offer	S_PROD_INT
Product Offer Response	S_PROD_OFR_RESP
Product Offer Response Action	S_PROD_OFR_ACTN
Product Offer Response Action Parameter	S_PROD_OFR_PARM
Product or Service	S_PROD_INT
Product Recommendation	S_PROD_RECMNDTN