Consider the forthcoming considerations VENDOR (VEN NUMBER, VEN_CONTACT, VEN_PHONE) PRODUCT(PROD CODE, PROD_DESCRIPTION, PROD_PRICE, VEN NUMBER) For the considerations loving over, operation on the problems below: For each consideration, establish the important explanation. For each consideration, establish the outlandish explanation(s). Establish at lowest single claimant explanation. If there are no claimant explanations, communicate an pattern of an indication that could be used as a claimant explanation. For single of the considerations, communicate patterns of a superexplanation and a resultant explanation. For the loving considerations, illustrate how existence rectitude and referential rectitude could be violated. Communicate favoring patterns. Use Visio to originate a inferential Crow’s Foot ERD. The diagram must understand whole entities, indications, and relationships. Important explanations and outlandish explanations must be palpably attested on the diagram.
Part 1. Consideration Vendor – VEN_NUMBER is the important explanation.
Consideration Product – PROD_CODE is the important explanation.
Part 2. VEN_NUMBER is the outlandish explanation.
Part 3. VEN_CONTACT is a claimant explanation.
Part 4. For consideration vendor : VEN_NUMBER is a super explanation and VEN_CONTACT