Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE EMP LNAME DVP FNAME EMP INITIAL EMP DCE STORE CODE 1 Mr Milianson 21-May-84 00-Fob 80 John 3 2 Me. Ratula Narcy 2 3 Ms. Greenburo Lctte R 02-Od-01 4. 4 Mrs Rumperstro Srith Jennie 01-Jun-91 5 Mr. O Mr. Rokort 23-Nov-73 Renselaer Cary 25-Dec-05 7 Mr 8 Ms. 9 Mr. Opalo Roberto 31-JU-82 Johnsscn Elizabeth 3D 10-Sep 83 Crdsra Jack 19-Apr-75 10 Mrs Jones Rose 06-Mar-85 21-Oct 92 0-Sep-94 11 Mr. Broderick Tom 12 Mr. Wachington Sith Alan 13 Mr Peter 25-Aug-84 31 14 Ms. Snith Sherry H. 25 May 85 24-May-04 15 Mr. 16 Mr. Clenko Howard 5 Archiao Barry 03-Sep-00 17 Me. Grmeido Jeanine K 12 Nov 90 18 Mr. Rosonberg Androw D 24-Jan-91 19 Mr. Rosten Feter 03-Oc-83 20 Mr. Mckee Robert 06-Mar-90 21 Me. Baumann Jonnifor 11-Doc-04 Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1421 987.39 O86783.22 944500.50 2030098.45 1 Access Junction 2 Datebase Corner 3 Tuplo Chargo 8 12 4 Attribute Aley 2 5 Primary Koy Point 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West
Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE EMP LNAME DVP FNAME EMP INITIAL EMP DCE STORE CODE 1 Mr Milianson 21-May-84 00-Fob 80 John 3 2 Me. Ratula Narcy 2 3 Ms. Greenburo Lctte R 02-Od-01 4. 4 Mrs Rumperstro Srith Jennie 01-Jun-91 5 Mr. O Mr. Rokort 23-Nov-73 Renselaer Cary 25-Dec-05 7 Mr 8 Ms. 9 Mr. Opalo Roberto 31-JU-82 Johnsscn Elizabeth 3D 10-Sep 83 Crdsra Jack 19-Apr-75 10 Mrs Jones Rose 06-Mar-85 21-Oct 92 0-Sep-94 11 Mr. Broderick Tom 12 Mr. Wachington Sith Alan 13 Mr Peter 25-Aug-84 31 14 Ms. Snith Sherry H. 25 May 85 24-May-04 15 Mr. 16 Mr. Clenko Howard 5 Archiao Barry 03-Sep-00 17 Me. Grmeido Jeanine K 12 Nov 90 18 Mr. Rosonberg Androw D 24-Jan-91 19 Mr. Rosten Feter 03-Oc-83 20 Mr. Mckee Robert 06-Mar-90 21 Me. Baumann Jonnifor 11-Doc-04 Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1421 987.39 O86783.22 944500.50 2030098.45 1 Access Junction 2 Datebase Corner 3 Tuplo Chargo 8 12 4 Attribute Aley 2 5 Primary Koy Point 1 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....
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:Table name: EMPLOYEE
Database name: Ch03_StoreCo
EMP CODE EMP TITLE
EMP LNAME DVP FNAME EMP INITIAL EMP DCE STORE CODE
1 Mr
Milianson
21-May-84
00-Fob 80
John
3
2 Me.
Ratula
Narcy
2
3 Ms.
Greenburo
Lctte
R
02-Od-01
4.
4 Mrs
Rumperstro
Srith
Jennie
01-Jun-91
5 Mr.
O Mr.
Rokort
23-Nov-73
Renselaer
Cary
25-Dec-05
7 Mr
8 Ms.
9 Mr.
Opalo
Roberto
31-JU-82
Johnsscn
Elizabeth
3D
10-Sep 83
Crdsra
Jack
19-Apr-75
10 Mrs
Jones
Rose
06-Mar-85
21-Oct 92
0-Sep-94
11 Mr.
Broderick
Tom
12 Mr.
Wachington
Sith
Alan
13 Mr
Peter
25-Aug-84
31
14 Ms.
Snith
Sherry
H.
25 May 85
24-May-04
15 Mr.
16 Mr.
Clenko
Howard
5
Archiao
Barry
03-Sep-00
17 Me.
Grmeido
Jeanine
K
12 Nov 90
18 Mr.
Rosonberg
Androw
D
24-Jan-91
19 Mr.
Rosten
Feter
03-Oc-83
20 Mr.
Mckee
Robert
06-Mar-90
21 Me.
Baumann
Jonnifor
11-Doc-04
Table name: STORE
STORE CODE STORE NAME STORE_YTD SALES REGION_CODE EMP_CODE
1003455.76
1421 987.39
O86783.22
944500.50
2030098.45
1 Access Junction
2 Datebase Corner
3 Tuplo Chargo
8
12
4 Attribute Aley
2
5 Primary Koy Point
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.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage