Q1
I think here number of tables required should be 2 right?
Q2 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 __
2NF ?
Q3 Derived attribute is an attribute that represents a value that is derived from( Marks: -0.66 )
- Only from a single attribute in an entity
- It can be derived from two or more attributes in an entity
- It can be derived from a different entity
- All of the above.
Here answer is 4.
Any good reference to support answer?