Can you review and let me know if I am right or wrong?

REFERENTIAL INTEGRITY

Employee table ; Referential Integrity YES ; The table has a foreign key and the values in it reference valid information in another table.

Store table ; Referential Integrity YES ; The table has a foreign key and the values in it reference valid information in another table.

 Region ; Referential Integrity N/A ; Region table does not have a foreign key.

Transcribed Image Text:

Table name: EMPLOYEE EMP_CODE EMP_TITLE | EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr. 2 Ms. 3 Ms. Williamson John Ratula Nancy Greenboro Lottie W 21-May-64 09-Feb-69 3 2 4 Mrs. Rumpersfro Jennie 5 Mr. Smith Robert 6 Mr. Renselaer Cary 7 Mr. Ogallo Roberto RSLAS 8 Ms. Johnsson Elizabeth I 9 Mr. Eindsmar Jack 10 Mrs. Jones Rose WR 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 4 5 3 1 3 1 2 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 4 15 Mr. Olenko Howard U 24-May-64 5 16 Mr. Archialo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine K 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 Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner STORE_YTD_SALES REGION_CODE EMP_CODE 1003455.76 2 1421987.39 2 12 3 Tuple Charge 986783.22 1 7 827 4 Attribute Alley 944568.56 2 5 Primary Key Point 2930098.45 1 15 35 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West Table name: EMPLOYEE EMP_CODE EMP_TITLE | EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr. 2 Ms. 3 Ms. Williamson John Ratula Nancy Greenboro Lottie W 21-May-64 09-Feb-69 3 2 4 Mrs. Rumpersfro Jennie 5 Mr. Smith Robert 6 Mr. Renselaer Cary 7 Mr. Ogallo Roberto RSLAS 8 Ms. Johnsson Elizabeth I 9 Mr. Eindsmar Jack 10 Mrs. Jones Rose WR 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 4 5 3 1 3 1 2 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 4 15 Mr. Olenko Howard U 24-May-64 5 16 Mr. Archialo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine K 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 Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner STORE_YTD_SALES REGION_CODE EMP_CODE 1003455.76 2 1421987.39 2 12 3 Tuple Charge 986783.22 1 7 827 4 Attribute Alley 944568.56 2 5 Primary Key Point 2930098.45 1 15 35 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West