Use the database tables shown to answer Problems (a) to (d) below. a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. b) Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. [6 Points]c) Create the relational diagram to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC d) Create the Crow’s Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC. Table name: EMPLOYEEEMP_NUM EMP_LNAME215 SmithTable name: EDUCATIONEDU CODE34EDU DESCRIPTIONBachelor's degree216 RomeroCDPCertified data Processing217 RandallCNPCertified Network Professional218 AardenСРАCertified Public AccountantDREarned Doctorate degreeTable name: EMP_EDUCEMP_NUM EDU CODE EE_YEAR215 B4HSHighschool diplomaJCJunior College degreeM2Master's degree2002215 HS1991215 JC1994216 B41989216 CDP2004216 CNP2002216 HS1985217 HS1992217 JC2000218 B41990218 CDP2000218 CNP2005218 HS1984218 M21995

Answered: Use the database tables shown to answer…

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

See similar textbooks

Related questions

Concept explainers

Question

Use the database tables shown to answer Problems (a) to (d) below.

a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.

b) Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. [6 Points]

c) Create the relational diagram to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC

d) Create the Crow’s Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC.

Table name: EMPLOYEE
EMP_NUM EMP_LNAME
215 Smith
Table name: EDUCATION
EDU CODE
34
EDU DESCRIPTION
Bachelor's degree
216 Romero
CDP
Certified data Processing
217 Randall
CNP
Certified Network Professional
218 Aarden
СРА
Certified Public Accountant
DR
Earned Doctorate degree
Table name: EMP_EDUC
EMP_NUM EDU CODE EE_YEAR
215 B4
HS
Highschool diploma
JC
Junior College degree
M2
Master's degree
2002
215 HS
1991
215 JC
1994
216 B4
1989
216 CDP
2004
216 CNP
2002
216 HS
1985
217 HS
1992
217 JC
2000
218 B4
1990
218 CDP
2000
218 CNP
2005
218 HS
1984
218 M2
1995

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions