(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