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
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Arrays
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education