For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. Do the tables exhibit entity integrity and referential integrity? Answer yes or no and then explain your answer. In the case of Referential Integrity write NA (Not Applicable) if the table does not have a foreign key. iii. Describe the type(s) of relationship(s) between STORE and REGION Create the ERD to show the relationship between STORE and REGION.6 Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) Draw the ERD to show the relationships among EMPLOYEE, STORE and REGION.
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. Do the tables exhibit entity integrity and referential integrity? Answer yes or no and then explain your answer. In the case of Referential Integrity write NA (Not Applicable) if the table does not have a foreign key. iii. Describe the type(s) of relationship(s) between STORE and REGION Create the ERD to show the relationship between STORE and REGION.6 Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) Draw the ERD to show the relationships among EMPLOYEE, STORE and REGION.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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 in the space
provided.
- Do the tables exhibit entity integrity and referential integrity?
Answer yes or no and then explain your answer. In the case of
Referential Integrity write NA (Not Applicable) if the table
does not have a foreign key.
- iii. Describe the type(s) of relationship(s) between STORE and
REGION
- Create the ERD to show the relationship between STORE and
REGION.6
- Describe the type(s) of relationship(s) between EMPLOYEE
and STORE. (Hint: Each store employs many employees, one of
whom manages the store.)
- Draw the ERD to show the relationships among EMPLOYEE,
STORE and REGION.
![Table name: EMPLOYEE
Database name: Ch03_StoreCo
EMP CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB STORE_CODE
1 Mr.
Williamson
John
21-May-64
3
2 Ms.
3 Ms.
Ratula
Nancy
09-Feb-69
2
Greenboro
Lottie
R.
02-Oct-61
4
4 Mrs.
Rumpersfro
Jennie
S
01-Jun-71
5
5 Mr.
6 Mr.
7 Mr.
8 Ms.
9 Mr.
Smith
Robert
L
23-Nov-59
3
Renselaer
Cary
A
25-Dec-65
Ogallo
Roberto
31-Jul-62
3
Johnsson
Elizabeth
10-Sep-68
1
Eindsmar
Jack
19-Apr-55
2
10 Mrs.
Jones
Rose
06-Mar-66
4
11 Mr.
Broderick
Tom
21-Oct-72
3
12 Mr.
Washington
Simith
Alan
Y.
08-Sep-74
13 Mr.
Peter
25-Aug-64
14 Ms.
Smith
Sherry
25-May-66
24-May-64
03-Sep-60
4
15 Mr.
Olenko
Howard
16 Mr.
Archialo
Barry
5
17 Ms.
Grimaldo
Jeanine
12-Nov-70
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-71
4
19 Mr.
Rosten
Peter
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
1003455.76
1 Access Junction
2
8
2 Database Corner
1421987.39
2
12
3 Tuple Charge
986783.22
1
7
4 Attribute Alley
944568.56
2
5 Primary Key Point
2930098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
1 East
2 West](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fda2f0f68-b5e2-4430-a35b-de244ebaf928%2F7ef8f8a8-7bd0-474b-9dbc-89cc2c28622b%2Fp1b6hjf_processed.png&w=3840&q=75)
Transcribed Image Text:Table name: EMPLOYEE
Database name: Ch03_StoreCo
EMP CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB STORE_CODE
1 Mr.
Williamson
John
21-May-64
3
2 Ms.
3 Ms.
Ratula
Nancy
09-Feb-69
2
Greenboro
Lottie
R.
02-Oct-61
4
4 Mrs.
Rumpersfro
Jennie
S
01-Jun-71
5
5 Mr.
6 Mr.
7 Mr.
8 Ms.
9 Mr.
Smith
Robert
L
23-Nov-59
3
Renselaer
Cary
A
25-Dec-65
Ogallo
Roberto
31-Jul-62
3
Johnsson
Elizabeth
10-Sep-68
1
Eindsmar
Jack
19-Apr-55
2
10 Mrs.
Jones
Rose
06-Mar-66
4
11 Mr.
Broderick
Tom
21-Oct-72
3
12 Mr.
Washington
Simith
Alan
Y.
08-Sep-74
13 Mr.
Peter
25-Aug-64
14 Ms.
Smith
Sherry
25-May-66
24-May-64
03-Sep-60
4
15 Mr.
Olenko
Howard
16 Mr.
Archialo
Barry
5
17 Ms.
Grimaldo
Jeanine
12-Nov-70
4
18 Mr.
Rosenberg
Andrew
D
24-Jan-71
4
19 Mr.
Rosten
Peter
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
1003455.76
1 Access Junction
2
8
2 Database Corner
1421987.39
2
12
3 Tuple Charge
986783.22
1
7
4 Attribute Alley
944568.56
2
5 Primary Key Point
2930098.45
1
15
Table name: REGION
REGION_CODE REGION_DESCRIPT
1 East
2 West
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.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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 System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education