Select student.rollno,student.sname
From Student Natural Join Enroll
where enroll.grade='A' AND Enroll.cno in (Select from teach where tname='Ramesh')
Select student.rollno,student.sname
From Student , Enroll , Teach
where Student. rollno. = Enroll.rollno. AND Enroll.grade='A' AND tname='Ramesh')
Students (rollno*, sname, saddr) with rollno →sname, saddr is in BCNF
courses (cno*, cname) with cno→ cname is in BCNF
enroll(rollno*, cno*, grade) with rollno → grade,cno and cno → grade, rollno. is in BCNF
teach(tno*, tname, cao*) here Cao tno → tname, cao and cao → tname,tno is in BCNF