EMP CODE EMP TITLE EMP LNAME EVP FNAME EMP INITIAL EMP DCE STORE CODE 1 Mr Milianson 21-May-84 John 2 Me. Ratula Noroy Lotte 0O-Fob-80 2 3 Ms. 4 Mrs 6 Mr. 6 Mr. 7 Mr 8 Ms. Greenburo 02-Odt-01...


Do the tables exihibit referential integrity.Answer yes or no, and then explain your answer.


EMP CODE EMP TITLE EMP LNAME EVP FNAME EMP INITIAL EMP DCE STORE CODE<br>1 Mr<br>Milianson<br>21-May-84<br>John<br>2 Me.<br>Ratula<br>Noroy<br>Lotte<br>0O-Fob-80<br>2<br>3 Ms.<br>4 Mrs<br>6 Mr.<br>6 Mr.<br>7 Mr<br>8 Ms.<br>Greenburo<br>02-Odt-01<br>Rurperstro<br>Jennie<br>01-kun-91<br>Snith<br>Rokort<br>23 Nov-73<br>Renselaer<br>Cary<br>25-Dec-05<br>Opalo<br>Roberto<br>31-JU-82<br>Johneson<br>Elizabeth<br>10-Sep-88<br>18-Aor-75<br>9 Mr<br>Crdsra<br>Jack<br>2<br>10 Mrs<br>Jones<br>Rose<br>06-Mar-85<br>11 Mr.<br>Broderick<br>Tom<br>21-Oct-92<br>12 Mr.<br>Washington<br>Alan<br>CO-Sop-94<br>13 Mr<br>Snith<br>Peter<br>25-Aug-84<br>14 Ms.<br>Snith<br>Sherry<br>25 May 85<br>24-May-04<br>H.<br>15 Mr.<br>Clenko<br>Howard<br>16 Mr.<br>Archiao<br>Barry<br>C3-Sep-00<br>17 Ms.<br>Grmsido<br>Jeanine<br>12 Nov.90<br>18 Mr<br>Rosonberg<br>Androw<br>24-Jan-91<br>ectangulas wr<br>Rosten<br>Peter<br>03-Oc-88<br>20 Mr<br>Mckee<br>Robert<br>06Mar.90<br>21 Ме.<br>Baunann<br>Jonnifor<br>11-Doc-04<br>Table name: STORE<br>STORE CODE STORE NAME STORE YTD SALES REGON CODE EMP CODE<br>1 Access Juncton<br>1003455 76<br>2<br>8.<br>2 Datebace Corner<br>1421 987.39<br>12<br>086783.22<br>944500.50<br>2030098.45<br>3 Tuplo Chargo<br>4 Alt-ibule Aley<br>5 Primary Koy Point<br>15<br>Table name: REGION<br>REGION CODE REGION DESCRIPT<br>1 Eact<br>2 West<br>

Extracted text: EMP CODE EMP TITLE EMP LNAME EVP FNAME EMP INITIAL EMP DCE STORE CODE 1 Mr Milianson 21-May-84 John 2 Me. Ratula Noroy Lotte 0O-Fob-80 2 3 Ms. 4 Mrs 6 Mr. 6 Mr. 7 Mr 8 Ms. Greenburo 02-Odt-01 Rurperstro Jennie 01-kun-91 Snith Rokort 23 Nov-73 Renselaer Cary 25-Dec-05 Opalo Roberto 31-JU-82 Johneson Elizabeth 10-Sep-88 18-Aor-75 9 Mr Crdsra Jack 2 10 Mrs Jones Rose 06-Mar-85 11 Mr. Broderick Tom 21-Oct-92 12 Mr. Washington Alan CO-Sop-94 13 Mr Snith Peter 25-Aug-84 14 Ms. Snith Sherry 25 May 85 24-May-04 H. 15 Mr. Clenko Howard 16 Mr. Archiao Barry C3-Sep-00 17 Ms. Grmsido Jeanine 12 Nov.90 18 Mr Rosonberg Androw 24-Jan-91 ectangulas wr Rosten Peter 03-Oc-88 20 Mr Mckee Robert 06Mar.90 21 Ме. Baunann Jonnifor 11-Doc-04 Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGON CODE EMP CODE 1 Access Juncton 1003455 76 2 8. 2 Datebace Corner 1421 987.39 12 086783.22 944500.50 2030098.45 3 Tuplo Chargo 4 Alt-ibule Aley 5 Primary Koy Point 15 Table name: REGION REGION CODE REGION DESCRIPT 1 Eact 2 West

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here