Which of the following is a partial dependency? - ProProfs Discuss
Topics
Products
Follow Us:

Which of the following is a partial dependency?
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS).

Which of the following is a partial dependency?<br/>
Given the table EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS).

Change Image    Delete



A. PROJ_NUM --> PROJ_NAME
B. JOB_CLASS --> CHG_HOUR
C. PROJ_NUM, EMP_NUM --> HOURS
D. PROJ_NUM, EMP_NUM --> CHG_HOURS

This question is part of Database Ch 5
Asked by Rudy, Last updated: Jun 30, 2020

+ Answer
Request

2 Answers

Chris Kenway

Chris Kenway, Content Writer, Jacksonville

Answered Apr 09, 2019

The correct answer is option A
Partial dependency is a form of dependency when non-prime attributes is functionally dependent on a part of the candidate key.
To better understand this, we need to know what candidate key and non-prime attributes are.

Using the example above
(PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS) is a functional dependency.

(EMP_PROJ) is the candidate key.
Other attributes, such as NUM, NAME, HOURS, JOB and CLASS are non-prime attributes.
Of all the options only option A is correct, as it non-prime attributes (NUM and NAME) that functionally depend on a part of the candidate key (PROJ).

 

John Smith

John Smith

Answered Jan 15, 2017

Proj_num --> proj_name
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.