Base answer on picture below

Lastly, Create the ERD to show the relationship between STORE and REGION

Table name: EMPLOYEE + + + EMP_CODE EMP_TITLE + Mr. + 2 Ms. 3 Ms. 4 Mrs. + 5 Mr. 6 Mr. + 7 Mr. + 8 Ms. 9 Mr. + 10 Mrs. 11 Mr + 12 Mr + 13 Mr. 14 Ms. 15 Mr 16 Mr. 17 Ms. 18 Mr 19 Mr. + 20 Mr. 21 Ms. EMP_LNAME Williamson Ratula Greenboro Rumperstro Smith Renselaer Ogallo Johnsson Eindsmar Jones Broderick Washington Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Database name: Cho3_Storeco EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE John w 21-May-64 3 Nancy 09-Feb-69 2 Lottie R 02-Oct-61 4 Jennie S 01-Jun-71 5 Robert L 23-Nov-59 3 Cary A 25-Dec-65 1 Roberto S 31-Jul-62 3 Elizabeth 1 10-Sep-68 1 Jack w 19-Apr-55 2 Rose R 06-Mar-66 4 Tom 21-Oct-72 3 Alan Y 08-Sep-74 2 Peter N 25-Aug-64 3 Sherry H 25-May-66 4 Howard U 24-May-64 5 Barry v 03-Sep-60 5 Jeanine K 12-Nov-70 4 Andrew D 24-Jan-71 4 Peter F 03-Oct-68 4 Robert S 06-Mar-70 1 Jennifer A 11-Dec-74 3 + + + + + + Table name: STORE STORE_CODE STORE NAME Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION_CODE REGION_DESCRIPT East 2 West STORE_YTD_SALES REGION_CODE EMP_CODE $1,003,455.76 8 $1,421,98739 12 $986,783.22 7 $944,568.56 3 $2,930.098.45 1 15 + + + + + NNN For each table below in Example Tables 1, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. TABLE PRIMARY KEY FOREIGN KEY(S) EMPLOYEE STORE REGION Example Tables 1 Do the tables below in Example Table 2 exhibit entity integrity? Answer yes or no; then explain your answer. Example Tables 2 ENTITY INTEGRITY EXPLANATION TABLE EMPLOYEE STORE REGION Do the tables below in Table 3, exhibit referential integrity? Answer yes or no; then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Example Tables 3 REFERENTIAL INTEGRITY EXPLANATION TABLE EMPLOYEE STORE REGION