data base management systems assignment

FIGURE P3.1 THE CH03 STORECO DATABASE TABLES EMPLOYEE Pave MOKY Le P 1 Dan PU Cay Opet T MC Cabine IKK A Ares . T Sed Py4 Ser HA Ima 4 V A Table STORE STOPE CODE TOPMAR SPOREYT_SPARTPOK CODE COD PARLAN HO 14217 C 11 3 Days N E Say is Table REGION RECKON CODE 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 key(s). 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. 23 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) if 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. IM 20 THE 10 EM FMR SM 10 10 M HUM 13 H4W 15 IEM 16 E 20 D Dalah Mans