The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)c. Draw the relational diagram.d. Draw the Crow's Foot ERD. TABLE P6.6EMP NUMEMP LNAMEEMP EDUCATION1003101810191023WillakerSmithMcGuireMcGuireBBA, MBABBABS, MS, Ph.D.JOB_CLASSSLSSLSUNTDBAEMP DEPENDENTSGerald (spouse),Mary (daughter),John (son)JoAnne (spouse)George (spouse)Jill (daughter)DEPT CODEDEPT NAMEDEPT MANAGEREMP TITLEEMP DOBEMP HIRE DATEMKTGMKTGSVCINFSMarketingMarketingGeneral ServiceInfo. SystemsJill H. MartinJill H. MartinHank B. JonesCarlos G. OrtezSales AgentSales AgentJanitorDB Admin23-Dec-196828-Mar-197918-May-198220-Jul-195914-Oct-199715-Jan-200621-Apr-200315-Jul-1999EMP_TRAININGL1, L2L1L1L1, L3, L8, L15EMP BASE SALARY$38,255.00$30,500.00$19,750.00$127,900.00EMP COMMISSION_RATE0.0150.010

Write the relational schema and the dependency diagram for the employee table.

Answered: TABLE P6.6 EMP NUM EMP LNAME EMP…

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

The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics.

a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.

b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)

c. Draw the relational diagram.

d. Draw the Crow's Foot ERD.

TABLE P6.6
EMP NUM
EMP LNAME
EMP EDUCATION
1003
1018
1019
1023
Willaker
Smith
McGuire
McGuire
BBA, MBA
BBA
BS, MS, Ph.D.
JOB_CLASS
SLS
SLS
UNT
DBA
EMP DEPENDENTS
Gerald (spouse),
Mary (daughter),
John (son)
JoAnne (spouse)
George (spouse)
Jill (daughter)
DEPT CODE
DEPT NAME
DEPT MANAGER
EMP TITLE
EMP DOB
EMP HIRE DATE
MKTG
MKTG
SVC
INFS
Marketing
Marketing
General Service
Info. Systems
Jill H. Martin
Jill H. Martin
Hank B. Jones
Carlos G. Ortez
Sales Agent
Sales Agent
Janitor
DB Admin
23-Dec-1968
28-Mar-1979
18-May-1982
20-Jul-1959
14-Oct-1997
15-Jan-2006
21-Apr-2003
15-Jul-1999
EMP_TRAINING
L1, L2
L1
L1
L1, L3, L8, L15
EMP BASE SALARY
$38,255.00
$30,500.00
$19,750.00
$127,900.00
EMP COMMISSION_RATE
0.015
0.010

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 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