Consider the following set of functional dependencies
(Eid, pno) --> hours,
Eid –> Ename,
Pno –> (Pname, Plocation),
Pname --> Plocation
in a relation R (Eid, Pno, hours, Ename, Pname, Plocation). After decomposition, the relation R1 (Pno, Pname, Plocation) is in __( Marks: 0.00 )
- 3NF but not in BCNF
Please avoid sharing links… if possible give your own solution.