Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Table name: EMPLOYEE EMP INITIAL EMP DCE STORE CODE 21-May-84 EMP CODE EMP TITLE EMP LNAME EVP FNAME 1 Mr. 2 Me. Milianson Jonn Ratula Norcy 0-Fob-80 2 3 Ms. 4 Mrs 5 Mr O Mr. 7 Mr 8 Ms. 9 Mr Greenbaro Lotte 02-Oct-01 4 Rurperstro Jennie is 01-Jun-91 Srith Robort 23-Nov-79 3 Renselast Cary A 25-Dec-05 1. Opalo Roberto 31-JU-82 3 Johnsson Elizabeth 3D 10.Sep 88 Erdsrar Jack 19-Apr-75 2 10 Mrs Jones Rose R 06-Mar-86 4 11 Mr. Broderick Tom 21-Oct-92 3 12 Mr. Washington Alan CO-Sep-94 2 13 Mr Peter 25-Aug-84 3. Srith Sherry H. 25 May 85 24-May-04 14 Ms. 15 Mr. Clerko Howard 16 Mr. Archiao Berry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov 90 10 Mr. Rosenberg Rosten Androw 24-Jan-91 19 Mr Peter 03-Oct-88 20 Mr Mckee Robert 06-Mar-90 21 Me. Baunann Jennifor 11-Dec-04 3 Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1 Access Juncton 2 81 2 Datebase Corner 3 Tuplo Chargo 1421 987.39 12 086783.22 944560.50 1 7. 4 Att ibute Aley 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West

Table name: EMPLOYEE EMP INITIAL EMP DCE STORE CODE 21-May-84 EMP CODE EMP TITLE EMP LNAME EVP FNAME 1 Mr. 2 Me. Milianson Jonn Ratula Norcy 0-Fob-80 2 3 Ms. 4 Mrs 5 Mr O Mr. 7 Mr 8 Ms. 9 Mr Greenbaro Lotte 02-Oct-01 4 Rurperstro Jennie is 01-Jun-91 Srith Robort 23-Nov-79 3 Renselast Cary A 25-Dec-05 1. Opalo Roberto 31-JU-82 3 Johnsson Elizabeth 3D 10.Sep 88 Erdsrar Jack 19-Apr-75 2 10 Mrs Jones Rose R 06-Mar-86 4 11 Mr. Broderick Tom 21-Oct-92 3 12 Mr. Washington Alan CO-Sep-94 2 13 Mr Peter 25-Aug-84 3. Srith Sherry H. 25 May 85 24-May-04 14 Ms. 15 Mr. Clerko Howard 16 Mr. Archiao Berry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov 90 10 Mr. Rosenberg Rosten Androw 24-Jan-91 19 Mr Peter 03-Oct-88 20 Mr Mckee Robert 06-Mar-90 21 Me. Baunann Jennifor 11-Dec-04 3 Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1 Access Juncton 2 81 2 Datebase Corner 3 Tuplo Chargo 1421 987.39 12 086783.22 944560.50 1 7. 4 Att ibute Aley 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Do the tables exihibit referential integrity.Answer yes or no, and then explain your answer.Write NA if the table does not have a foreign key.

Table name: EMPLOYEE EMP INITIAL EMP DCE STORE CODE 21-May-84 EMP CODE EMP TITLE EMP LNAME EVP FNAME 1 Mr. 2 Me. Milianson Jonn Ratula Norcy 0-Fob-80 2 3 Ms. 4 Mrs 5 Mr O Mr. 7 Mr 8 Ms. 9 Mr Greenbaro Lotte 02-Oct-01 4 Rurperstro Jennie is 01-Jun-91 Srith Robort 23-Nov-79 3 Renselast Cary A 25-Dec-05 1. Opalo Roberto 31-JU-82 3 Johnsson Elizabeth 3D 10.Sep 88 Erdsrar Jack 19-Apr-75 2 10 Mrs Jones Rose R 06-Mar-86 4 11 Mr. Broderick Tom 21-Oct-92 3 12 Mr. Washington Alan CO-Sep-94 2 13 Mr Peter 25-Aug-84 3. Srith Sherry H. 25 May 85 24-May-04 14 Ms. 15 Mr. Clerko Howard 16 Mr. Archiao Berry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov 90 10 Mr. Rosenberg Rosten Androw 24-Jan-91 19 Mr Peter 03-Oct-88 20 Mr Mckee Robert 06-Mar-90 21 Me. Baunann Jennifor 11-Dec-04 3
Transcribed Image Text:Table name: EMPLOYEE EMP INITIAL EMP DCE STORE CODE 21-May-84 EMP CODE EMP TITLE EMP LNAME EVP FNAME 1 Mr. 2 Me. Milianson Jonn Ratula Norcy 0-Fob-80 2 3 Ms. 4 Mrs 5 Mr O Mr. 7 Mr 8 Ms. 9 Mr Greenbaro Lotte 02-Oct-01 4 Rurperstro Jennie is 01-Jun-91 Srith Robort 23-Nov-79 3 Renselast Cary A 25-Dec-05 1. Opalo Roberto 31-JU-82 3 Johnsson Elizabeth 3D 10.Sep 88 Erdsrar Jack 19-Apr-75 2 10 Mrs Jones Rose R 06-Mar-86 4 11 Mr. Broderick Tom 21-Oct-92 3 12 Mr. Washington Alan CO-Sep-94 2 13 Mr Peter 25-Aug-84 3. Srith Sherry H. 25 May 85 24-May-04 14 Ms. 15 Mr. Clerko Howard 16 Mr. Archiao Berry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov 90 10 Mr. Rosenberg Rosten Androw 24-Jan-91 19 Mr Peter 03-Oct-88 20 Mr Mckee Robert 06-Mar-90 21 Me. Baunann Jennifor 11-Dec-04 3
Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1 Access Juncton 2 81 2 Datebase Corner 3 Tuplo Chargo 1421 987.39 12 086783.22 944560.50 1 7. 4 Att ibute Aley 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West
Transcribed Image Text:Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1 Access Juncton 2 81 2 Datebase Corner 3 Tuplo Chargo 1421 987.39 12 086783.22 944560.50 1 7. 4 Att ibute Aley 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS