1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.
2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.
3. 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

Table name: EMPLOYEE Database name: Ch03_StoreCo EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr Williamson John w 21-May-64 2 Ms. Ratula Nancy 09-Feb-69 2 3 Ms. Greenboro Lottie R 02-Oct-61 4 4 Mrs. Rumperstro Jennie S 01-Jun-71 5 5 Mr. Smith Robert L 23-Nov-59 3 6 Mr. Renselaer Cary 25-Dec-65 1 7 Mr Ogallo Roberto S 31-Jul-62 3 8 Ms. Johnsson Elizabeth 1 10-Sep-68 1 9 Mr. Eindsmar Jack w 19-Apr-55 2 10 Mrs. Jones Rose R 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 3 12 Mr Washington Alan Y 08-Sep-74 2 13 Mr Smith Peter N 25-Aug-64 3 14 Ms Smith Sherry H 25-May-66 15 Mr. Olenko Howard U 24-May-84 5 16 Mr Archilo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine 12-Nov-70 4 18 Mr. Rosenberg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter F 03-Oct-68 4 20 Mr. Mckee Robert s 06-Mar-70 1 21 Ms. Baumann Jennifer A 11-Dec-74 3 4 2 Table name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE 1 Access Junction 1003455.76 2 Database Corner 1421987.39 2 3 Tuple Charge 986783.22 1 4 Attribute Alley 944568.56 2 5 Primary Key Point 2930098.45 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West