291 views
0 votes
0 votes

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 )

  1.  Only from a single attribute in an entity
  2.    It can be derived from two or more attributes in an entity
  3.    It can be derived from a different entity
  4.   All of the above.

Here answer is 4. 

Any good reference to support answer?

Please log in or register to answer this question.

Related questions

1 votes
1 votes
1 answer
1
Na462 asked May 12, 2018
1,358 views
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).Please explain every point in detail...
0 votes
0 votes
2 answers
2
Balaji Jegan asked Nov 4, 2018
2,199 views
How many minimum number of tables needed for this Quaternary Relationship?
1 votes
1 votes
6 answers
3
Abbas2131 asked Jul 30, 2018
2,234 views
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
3 votes
3 votes
1 answer
4
Manu Thakur asked Sep 17, 2017
1,862 views
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram: