Question: [ # 3 ] Functional Dependency Exercise ( 2 pts . ) PROJECT / EMPLOYEE PROJ _ NUM PRJ _ NAME EMP _ NUM EMP

[#3] Functional Dependency Exercise (2 pts.)
PROJECT/EMPLOYEE
PROJ_NUM PRJ_NAME EMP_NUM EMP_NAME JOB_CLASS CHR_HOUR HOURS
PROJ_NUM: Project number
PRJ_NAME: Project name
EMP_NUM: Employee number
EMP_NAME: Employee name
JOB_CLASS: Job class
CHR_HOUR: Charge hours (hourly charge)
HOURS: Work hours
Note: The charge hour attribute (CHR_HOUR) represents the employees hourly charge and it can be decided by the employees job class. Employees can work for different projects and each project-work hour is traced. A project needs many employees.
[a] Identify the primary key(s)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!