FIGURE P3.1 THE CH03_STORECO DATABASE TABLES Table name: EMPLOYEE Database name: Ch03_StoreCo EMP_CODE EMP_TITLE | EMP_LNAME | EMP_FNAME | EMP_INITIAL | EMP_DOB | STORE_CODE 1 Mr. 2 Ms. Williamson Ratula John W 21-May-84 3 Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie 4 Mrs. Rumpersfro Jennie 5 Mr. Smith Robert 6 Mr. Renselaer Cary 7 Mr. Ogallo Roberto RSLAS 02-Oct-81 4 01-Jun-91 5 23-Nov-79 3 25-Dec-85 1 31-Jul-82 3 8 Ms. Johnsson Elizabeth I 10-Sep-88 1 9 Mr. Eindsmar Jack W 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 Y 08-Sep-94 2 13 Mr. Smith Peter N 25-Aug-84 3 14 Ms. Smith Sherry H 25-May-86 4 15 Mr. Olenko Howard U 24-May-84 5 16 Mr. Archialo Barry V 03-Sep-80 5 17 Ms. Grimaldo Jeanine K 12-Nov-90 4 18 Mr. Rosenberg Andrew D 24-Jan-91 4 19 Mr. Rosten Peter F 03-Oct-88 4 20 Mr. Mckee Robert S 06-Mar-90 1 21 Ms. Baumann Jennifer A 11-Dec-94 3 Table name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE 1 Access Junction 1003455.76 2 8 2 Database Corner 1421987.39 2 12 3 Tuple Charge 986783.22 1 4 Attribute Alley 944568.56 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West
FIGURE P3.1 THE CH03_STORECO DATABASE TABLES Table name: EMPLOYEE Database name: Ch03_StoreCo EMP_CODE EMP_TITLE | EMP_LNAME | EMP_FNAME | EMP_INITIAL | EMP_DOB | STORE_CODE 1 Mr. 2 Ms. Williamson Ratula John W 21-May-84 3 Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie 4 Mrs. Rumpersfro Jennie 5 Mr. Smith Robert 6 Mr. Renselaer Cary 7 Mr. Ogallo Roberto RSLAS 02-Oct-81 4 01-Jun-91 5 23-Nov-79 3 25-Dec-85 1 31-Jul-82 3 8 Ms. Johnsson Elizabeth I 10-Sep-88 1 9 Mr. Eindsmar Jack W 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 Y 08-Sep-94 2 13 Mr. Smith Peter N 25-Aug-84 3 14 Ms. Smith Sherry H 25-May-86 4 15 Mr. Olenko Howard U 24-May-84 5 16 Mr. Archialo Barry V 03-Sep-80 5 17 Ms. Grimaldo Jeanine K 12-Nov-90 4 18 Mr. Rosenberg Andrew D 24-Jan-91 4 19 Mr. Rosten Peter F 03-Oct-88 4 20 Mr. Mckee Robert S 06-Mar-90 1 21 Ms. Baumann Jennifer A 11-Dec-94 3 Table name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE 1 Access Junction 1003455.76 2 8 2 Database Corner 1421987.39 2 12 3 Tuple Charge 986783.22 1 4 Attribute Alley 944568.56 2 3 5 Primary Key Point 2930098.45 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 2P: Problem 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX...
Related questions
Question
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None.
Transcribed Image Text:FIGURE P3.1 THE CH03_STORECO DATABASE TABLES
Table name: EMPLOYEE
Database name: Ch03_StoreCo
EMP_CODE EMP_TITLE | EMP_LNAME | EMP_FNAME | EMP_INITIAL | EMP_DOB | STORE_CODE
1 Mr.
2 Ms.
Williamson
Ratula
John
W
21-May-84
3
Nancy
09-Feb-89
2
3 Ms.
Greenboro Lottie
4 Mrs.
Rumpersfro Jennie
5 Mr.
Smith
Robert
6 Mr.
Renselaer
Cary
7 Mr.
Ogallo
Roberto
RSLAS
02-Oct-81
4
01-Jun-91
5
23-Nov-79
3
25-Dec-85
1
31-Jul-82
3
8 Ms.
Johnsson
Elizabeth
I
10-Sep-88
1
9 Mr.
Eindsmar
Jack
W
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
Y
08-Sep-94
2
13 Mr.
Smith
Peter
N
25-Aug-84
3
14 Ms.
Smith
Sherry
H
25-May-86
4
15 Mr.
Olenko
Howard
U
24-May-84
5
16 Mr.
Archialo
Barry
V
03-Sep-80
5
17 Ms.
Grimaldo
Jeanine
K
12-Nov-90
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-91
4
19 Mr.
Rosten
Peter
F
03-Oct-88
4
20 Mr.
Mckee
Robert
S
06-Mar-90
1
21 Ms.
Baumann
Jennifer
A
11-Dec-94
3
Table name: STORE
STORE_CODE STORE_NAME
STORE_YTD_SALES REGION_CODE
EMP_CODE
1 Access Junction
1003455.76
2
8
2 Database Corner
1421987.39
2
12
3 Tuple Charge
986783.22
1
4 Attribute Alley
944568.56
2
3
5 Primary Key Point
2930098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
1 East
2 West
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr