Question: 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.

Modify STORE table so EMPLOYEE table does not have referential integrity.

Modify STORE table so EMPLOYEE table does not have referential integrity. EMP

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!