Modify STORE table so EMPLOYEE table does not have referential integrity.
EMP CODE EMP_TITLE Mr. EMP_INITIAL w 1 1 2. 2 Ms. 3 3 Ms. R 4 4 Mrs. s L 5 5 Mr. 6 6 A Mr. Mr. 7 7 s 8 8 Ms. 1 9 9 Mr. w 10 10 Mrs. R EMP_LNAME EMP_FNAME Williamson John Ratula Nancy Greenboro Lottie Rumperstro Jennie Smith Robert Renselaer Cary Ogallo Roberto Johnsson Elizabeth Eindsmar Jack Jones Rose Broderick Tom Washington Alan Smith Peter Smith Sherry Olenko Howard Archiato Barry Grimaldo Jeanine Rosenberg Andrew Rosten Peter Mckee Robert Baumann Jennifer EMP_DOB STORE_CODE 1984-05-21 00:00:00 3 1989-02-09 00:00:00 2 1981-10-02 00:00:00 4 1991-06-01 00:00:00 5 1979-11-23 00:00:00 3 1985-12-25 00:00:00 1 1982-07-31 00:00:00 3 1988-09-10 00:00:00 1 1975-04-19 00:00:00 2 1986-03-06 00:00:00 4 1992-10-21 00:00:00 3 1994-09-08 00:00:00 2 1984-08-25 00:00:00 3 1986-05-25 00:00:00 4 1984-05-24 00:00:00 5 1980-09-03 00:00:00 5 1990-11-12 00:00:00 4 1991-01-24 00:00:00 4 1988-10-03 00:00:00 4 1990-03-06 00:00:00 1 1994-12-11 00:00:00 3 11 11 Mr. 12 12 Mr. Y 13 13 Mr. N 14 14 Ms. H 15 15 Mr. U 16 16 Mr. v 17 17 Ms. K 18 18 Mr. D 19 19 Mr. F 20 20 Mr. S 21 21 Ms. A EMP_CODE STORE_CODE 1 1 REGION_CODE 2 2 8 2 2 STORE_NAME STORE_YTD_SALES Access Junction 1003456 Database Corner 1421987 Tuple Charge 986783 Attribute Alley 944569 Primary Key Point 2930098 3 3 1 12 7 3 4 4 5 15 REGION_CODE 1 1 REGION_DESCRIPT East West 2. 2. EMP CODE EMP_TITLE Mr. EMP_INITIAL w 1 1 2. 2 Ms. 3 3 Ms. R 4 4 Mrs. s L 5 5 Mr. 6 6 A Mr. Mr. 7 7 s 8 8 Ms. 1 9 9 Mr. w 10 10 Mrs. R EMP_LNAME EMP_FNAME Williamson John Ratula Nancy Greenboro Lottie Rumperstro Jennie Smith Robert Renselaer Cary Ogallo Roberto Johnsson Elizabeth Eindsmar Jack Jones Rose Broderick Tom Washington Alan Smith Peter Smith Sherry Olenko Howard Archiato Barry Grimaldo Jeanine Rosenberg Andrew Rosten Peter Mckee Robert Baumann Jennifer EMP_DOB STORE_CODE 1984-05-21 00:00:00 3 1989-02-09 00:00:00 2 1981-10-02 00:00:00 4 1991-06-01 00:00:00 5 1979-11-23 00:00:00 3 1985-12-25 00:00:00 1 1982-07-31 00:00:00 3 1988-09-10 00:00:00 1 1975-04-19 00:00:00 2 1986-03-06 00:00:00 4 1992-10-21 00:00:00 3 1994-09-08 00:00:00 2 1984-08-25 00:00:00 3 1986-05-25 00:00:00 4 1984-05-24 00:00:00 5 1980-09-03 00:00:00 5 1990-11-12 00:00:00 4 1991-01-24 00:00:00 4 1988-10-03 00:00:00 4 1990-03-06 00:00:00 1 1994-12-11 00:00:00 3 11 11 Mr. 12 12 Mr. Y 13 13 Mr. N 14 14 Ms. H 15 15 Mr. U 16 16 Mr. v 17 17 Ms. K 18 18 Mr. D 19 19 Mr. F 20 20 Mr. S 21 21 Ms. A EMP_CODE STORE_CODE 1 1 REGION_CODE 2 2 8 2 2 STORE_NAME STORE_YTD_SALES Access Junction 1003456 Database Corner 1421987 Tuple Charge 986783 Attribute Alley 944569 Primary Key Point 2930098 3 3 1 12 7 3 4 4 5 15 REGION_CODE 1 1 REGION_DESCRIPT East West 2. 2
