Homework Solution: Consider the following tables VENDOR (VEN NUMBER, VEN_CONTACT, VEN_PHON…

    Consider the following tables VENDORVEN NUMBER, VEN_CONTACT, VEN_PHONE PRODUCTPROD CODE, PROD_DESCRIPTION, PROD_PRICE, VEN NUMBER) For the tables given above, work on the problems below: 1. For each table, identify the primary key. 2. For each table, identify the foreign key(s). 3. Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key 4. For one of the tables, give examples of a superkey and a secondary key. 5. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples. 6. Use Visio to create a detailed Crows Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.
    Consider the following tables VENDOR (VEN NUMBER, VEN_CONTACT, VEN_PHONE) PRODUCT(PROD CODE, PROD_DESCRIPTION, PROD_PRICE, VEN NUMBER) For the tables given above, work on the problems below: For each table, identify the primary key. For each table, identify the foreign key(s). Identify at least one candidate key. If there are no candidate keys, give an example of an attribute that could be used as a candidate key. For one of the tables, give examples of a superkey and a secondary key. For the given tables, explain how entity integrity and referential integrity could be violated. Give specific examples. Use Visio to create a detailed Crow's Foot ERD. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram.

    Exper, kindly post other questions accordingly.

    Part 1. Table Vendor - VEN_NUMBER is the primary key.

    Consider the forthcoming considerations VENDORVEN NUMBER, VEN_CONTACT, VEN_PHONE PRODUCTPROD CODE, PROD_DESCRIPTION, PROD_PRICE, VEN NUMBER) For the considerations loving over, operation on the problems below: 1. For each consideration, establish the important explanation. 2. For each consideration, establish the outlandish explanation(s). 3. 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 4. For single of the considerations, communicate patterns of a superexplanation and a resultant explanation. 5. For the loving considerations, illustrate how existence rectitude and referential rectitude could be violated. Communicate favoring patterns. 6. Use Visio to originate a inferential Crows Foot ERD. The diagram must understand whole entities, indications, and relationships. Important explanations and outlandish explanations must be palpably attested on the diagram.

    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.

    Exper, neighborly support other questions suitably.

    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