For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None to indicate no FK

(P.2) Do the tables exhibit entity integrity? For each table answer yes or no and then explain your answer

(P.3) Do the tables exhibit referential integrity? For each table answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.

 

Transcribed Image Text:

Table name: EMPLOYEE Database name: Ch03_Store Co EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 1 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. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Johnsson Eindsmar Jones 1 East 2 West Broderick Washington Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION_CODE REGION_DESCRIPT Roberto Elizabeth Jack Rose Tom Alan Peter Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer W 1003455.76 1421987.39 986783.22 944568.56 2930098.45 RSLAS I W R Y <CHN U V STORE_YTD_SALES REGION_CODE EMP_CODE K D F S A 2 2 1 2 1 827 12 3 15 3 2 4 5 3 1 3 1 2 4 3 2 3 4 5 5 4 454 4 4 1 3 Table name: EMPLOYEE Database name: Ch03_Store Co EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 1 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. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Johnsson Eindsmar Jones 1 East 2 West Broderick Washington Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION_CODE REGION_DESCRIPT Roberto Elizabeth Jack Rose Tom Alan Peter Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer W 1003455.76 1421987.39 986783.22 944568.56 2930098.45 RSLAS I W R Y <CHN U V STORE_YTD_SALES REGION_CODE EMP_CODE K D F S A 2 2 1 2 1 827 12 3 15 3 2 4 5 3 1 3 1 2 4 3 2 3 4 5 5 4 454 4 4 1 3

Answer rating: 100% (QA)

Ans Table Primary key Foreignkey Employee EMPCODE S... View the full answer