War W30 Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Each store employs many employees, one of whom manages the store Question No. 1 Marks 2) Define primary and foreign key. For each table, identify the primary key and the foreign keys) a table does not have a foreign key, write None, Question No. 2 (Marks 2) Define entity integrity. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer 2011 Question No. 3 (Marks 2) Define referential integrity Page 20 ? Answer yes or no, and then explain your answer not have a foreign key. o DELL FB F7 FB F9 F10 F11 F12 PrtSce Insert & NYXOM Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Cach store employs many employees, one of whom manages the store.) Question No. 1 (Marks 2) Deline primary and foreign key. For each table, identify the primary key and the foreign keys) If a table does not have a foreign key, write None. Question No. 2 (Marks 2] Define entity integrity. Do the tables exhibit entity Integrity? Answer yes or no, and then explain your answer Pro 2011 Question No. 3 (Marks 2) Define referential integrity PageQ+? Answer yes or no, and then explain your answer not have a foreign key. RI DOLL F5 F6 F7 FB F9 F10 F11 F12 Priser Insert WE GOCK = Our Googte Question No. 1 (Marks 2) Define primary and foreign key. For each table, Identity the primary key and the foreign keys). of a table does not have a foreign key, write None. Question No. 2 (Marks 2) Define entity integrity. Do the tables exhibit entity Integrity? Answer yes or no, and then explain your answer. Far 21 Question No. 3 (Marks 2) Define referential Integrity. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) the table does not have a foreign key. Question No. 4 (Marks 2) Create a relational diagram to show the relationships among EMPLOYEE, STORE, and REGION Page 13 + 0 1 G 5 DELL 25 F6 FZ FO F9 F10 F12 Priser Insert Dell a F11 * A & * 6 Bac 7 War W30 Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Each store employs many employees, one of whom manages the store Question No. 1 Marks 2) Define primary and foreign key. For each table, identify the primary key and the foreign keys) a table does not have a foreign key, write None, Question No. 2 (Marks 2) Define entity integrity. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer 2011 Question No. 3 (Marks 2) Define referential integrity Page 20 ? Answer yes or no, and then explain your answer not have a foreign key. o DELL FB F7 FB F9 F10 F11 F12 PrtSce Insert & NYXOM Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Cach store employs many employees, one of whom manages the store.) Question No. 1 (Marks 2) Deline primary and foreign key. For each table, identify the primary key and the foreign keys) If a table does not have a foreign key, write None. Question No. 2 (Marks 2] Define entity integrity. Do the tables exhibit entity Integrity? Answer yes or no, and then explain your answer Pro 2011 Question No. 3 (Marks 2) Define referential integrity PageQ+? Answer yes or no, and then explain your answer not have a foreign key. RI DOLL F5 F6 F7 FB F9 F10 F11 F12 Priser Insert WE GOCK = Our Googte Question No. 1 (Marks 2) Define primary and foreign key. For each table, Identity the primary key and the foreign keys). of a table does not have a foreign key, write None. Question No. 2 (Marks 2) Define entity integrity. Do the tables exhibit entity Integrity? Answer yes or no, and then explain your answer. Far 21 Question No. 3 (Marks 2) Define referential Integrity. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) the table does not have a foreign key. Question No. 4 (Marks 2) Create a relational diagram to show the relationships among EMPLOYEE, STORE, and REGION Page 13 + 0 1 G 5 DELL 25 F6 FZ FO F9 F10 F12 Priser Insert Dell a F11 * A & * 6 Bac 7