2. Use the following Tables to answer questions A-C . ( 60 Total points )

PRODUCT and vendor Database Tables

A. For each table, identify the primary key and the foreign key(s). If a table does

not have a foreign key, write None in the assigned space. ( 20 points )

TABLE	PRIMARY KEY	FOREIGN KEY(S)
PRODUCT
VENDOR

B. Do the tables exhibit entity integrity? Answer Yes or No, and then explain

your answer. ( 20 points )

TABLE	ENTITY INTEGRITY? Type Yes or No here	EXPLANATION Explain the reason here
PRODUCT
VENDOR

C. Do the tables exhibit referential integrity? Answer Yes or No, and then explain

your answer. Write NA (Not Applicable) if the table does not have a foreign

key. ( 20 points )

TABLE	REFERENTIAL INTEGRITY	EXPLANATION
PRODUCT
VENDOR

Table name: PRODUCT Table name: VENDOR