(1) Draw the Relational Schema for the relationship(s) between STORE and REGION.
(1) Draw the Relational Schema for the relationship(s) between STORE and REGION.
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...
Related questions
Question
Answer these 4 questions
(1) Draw the Relational Schema for the relationship(s) between STORE and REGION.
(2) Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store
employs many employees, one of whom manages the store.)
(3) Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE.
(4) Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE,
STORE, and REGION.
![Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
$1,421,987.39
$986,783.22
1 Access Junction
8
2 Database Corner
2
12
3 Tuple Charge
1
7
4 Attribute Alley
$944,568.56
3
5 Primary Key Point
$2,930,098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
East
2 West](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F249411fb-17e6-4b4c-8be8-accd9a7fc6a1%2Fcdfb5f99-16cd-4fcd-85a8-bb562ac2e4b9%2Fbo8nxd_processed.png&w=3840&q=75)
Transcribed Image Text:Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
$1,421,987.39
$986,783.22
1 Access Junction
8
2 Database Corner
2
12
3 Tuple Charge
1
7
4 Attribute Alley
$944,568.56
3
5 Primary Key Point
$2,930,098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
East
2 West
![Table name: EMPLOYEE
EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE
Mr.
Villiamson
John
21-May-64
2 Ms.
Ratula
Nancy
09-Feb-69
3 Ms.
Greenboro
Lottie
02-Oct-61
4
4 Mrs.
Rumpersfro Jennie
01-Jun-71
5 Mr.
6 Mr.
7 Mr.
8 Ms.
9 Mr.
Smith
Robert
23-Nov-59
3
Renselaer
Cary
25-Dec-65
1
Ogallo
Johnsson
Roberto
31-Jul-62
3
Elizabeth
10-Sep-68
1
Eindsmar
Jack
19-Apr-55
10 Mrs.
Jones
Rose
06-Mar-66
4
11 Mr.
Broderick
Tom
21-Oct-72
3
+
12 Mr.
08-Sep-74
25-Aug-64
25-May-66
24-May-64
Washington
Alan
Y
13 Mr.
Smith
Peter
3
14 Ms.
Smith
Sherry
4
+
15 Mr.
Olenko
Howard
16 Mr.
Archialo
Barry
03-Sep-60
5
17 Ms.
Grimaldo
Jeanine
K
12-Nov-70
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-71
4
19 Mr.
Rosten
Peter
F
03-Oct-68
4
20 Mr.
Mckee
Robert
06-Mar-70
1
21 Ms.
Baumann
Jennifer
A
11-Dec-74
3.
Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
1 Access Junction
2 Database Corner
3 Tuple Charge
4 Attribute Alley
5 Primary Key Point
$1,421,987.39
2
$986,783.22
1
$944,568.56
3
$2,930,098.45
1
15
0273
ZID>
+ ++ +
+ + + ++ ++ ++](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F249411fb-17e6-4b4c-8be8-accd9a7fc6a1%2Fcdfb5f99-16cd-4fcd-85a8-bb562ac2e4b9%2Fn4t5rsb_processed.png&w=3840&q=75)
Transcribed Image Text:Table name: EMPLOYEE
EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE
Mr.
Villiamson
John
21-May-64
2 Ms.
Ratula
Nancy
09-Feb-69
3 Ms.
Greenboro
Lottie
02-Oct-61
4
4 Mrs.
Rumpersfro Jennie
01-Jun-71
5 Mr.
6 Mr.
7 Mr.
8 Ms.
9 Mr.
Smith
Robert
23-Nov-59
3
Renselaer
Cary
25-Dec-65
1
Ogallo
Johnsson
Roberto
31-Jul-62
3
Elizabeth
10-Sep-68
1
Eindsmar
Jack
19-Apr-55
10 Mrs.
Jones
Rose
06-Mar-66
4
11 Mr.
Broderick
Tom
21-Oct-72
3
+
12 Mr.
08-Sep-74
25-Aug-64
25-May-66
24-May-64
Washington
Alan
Y
13 Mr.
Smith
Peter
3
14 Ms.
Smith
Sherry
4
+
15 Mr.
Olenko
Howard
16 Mr.
Archialo
Barry
03-Sep-60
5
17 Ms.
Grimaldo
Jeanine
K
12-Nov-70
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-71
4
19 Mr.
Rosten
Peter
F
03-Oct-68
4
20 Mr.
Mckee
Robert
06-Mar-70
1
21 Ms.
Baumann
Jennifer
A
11-Dec-74
3.
Table name: STORE
STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE
$1,003,455.76
1 Access Junction
2 Database Corner
3 Tuple Charge
4 Attribute Alley
5 Primary Key Point
$1,421,987.39
2
$986,783.22
1
$944,568.56
3
$2,930,098.45
1
15
0273
ZID>
+ ++ +
+ + + ++ ++ ++
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY