Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following table of EMPLOYEE data table [ [ EMPLOYEE ] , [ PROJ _ NUM,PROJ _ NAME,EMP _ NUM,EMP _ NAME,JOB _
Consider the following table of EMPLOYEE data
tableEMPLOYEEPROJNUM,PROJNAME,EMPNUM,EMPNAME,JOBCLASS,RATEPERHOUR,HOURSEvergreen,tableJune EArboughtableElectEnqineer$Evergreen,tableJohn GNewstableDatabaseDesigner$Evergreen,tableAlice KJohnsontableDatabaseDesigner$Evergreen,tableWilliamSmithfieldProgrammer,$Evergreen,tableDavid HSeniortableSystemsAnalyst$Amber Wave,tableAnneliseJonestableApplicationsDesigner$Amber Wave,tableJames JFrommertableGeneralSupport$Amber Wave,tableAnne KRamorastableSystemsAnalyst$Amber Wave,tableDarlene MSmithsonDSS Analyst,$Rolling Tide,tableAlice KJohnsontableDatabaseDesigner$Rolling Tide,tableAnne KRamorastableSystemsAnalyst$Rolling Tide,tableDelbert KJoenbroodtableApplicationsDesigner$Rolling Tide,tableGeoff BWabashtableClericalSupport$Rolling Tide,tableWilliamSmithfieldProgrammer,$Starflight,tableMaria DAlonzoProgrammer,$Starflight,tableTravis BBawanqitableSystemsAnalyst$Starflight,John GDatabase,$
tableEMPLOYEEPROJNUMPROJNAME,EMPNUMEMPNAME,JOBCLASS,RATEPERHOUR,HOURSStarflight,tableNewsAnneliseJonestableDesignerApplicationsDesigner$Starflight,tableRalph BWashingtontableSystemsAnalyst$Starflight,tableJames JFrommertableGeneralSupport$Starflight,tableDarlene MSmithsonDSS Analyst,$
a List all function dependencies. State the appropriate assumptions.
b Identify all composite determinants
c List all unique determinants
d List all candidate keys
e Identify the primary key
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started