(Solved) : Consider Following Relation Schema Table R R Eno Dno Pno Ename Dname Pname Edob Pcity Pcou Q29664086 . . .
Consider the following relation schema for table R: R(ENo,DNo,PNo,EName, DName,PName,Edob,PCity,PCountry, hours,rate)Attributes starting with “E” refer to Employees, those startingwith “D” refer to Departments, and those with “P” to Projects.Employees, Departments, and Projects are identified by uniquenumbers. The number of hours and hourly rate of pay for an employeeto carry out a project are determined by himself/herself and theproject. There may be multiple projects that are conducted in adepartment and multiple departments can be involved in a singleproject as well. Any employee can be affiliated with a fewdifferent departments and work in multiple projects at the sametime. A project may involve multiple employees. Names foremployees, departments and projects are not generally unique. Aproject will only be conducted in a single city. Multiple citiesfrom the same country may appear in the table, however, cities areuniquely named within and across all countries.
Answer the following questions:
Identify the candidate key(s) of R based on the FunctionalDependencies. You need to use the concept of attribute closure toidentify the key(s). Intermediate steps in this process should bedetailed.
Expert Answer
Answer to Consider Following Relation Schema Table R R Eno Dno Pno Ename Dname Pname Edob Pcity Pcou Q29664086 . . .
OR