retagged by
3,363 views
0 votes
0 votes

In functional dependency between two sets of attribute $A$ and $B$ then set of attributes $A$ of database is classified as:

  1. top right side
  2. down left side
  3. left hand side
  4. right hand side
retagged by

2 Answers

1 votes
1 votes
ANS  : c

In functional dependency between two sets of attribute A and B

A →B

A is determinant, and

B is dependent

so attributes a is classified as c.
0 votes
0 votes
A functional dependency, denoted by A $\rightarrow$B, between two sets of attributes A and B that are subsets of R, such that any two tuples t1 and t2 in r that have t1[A] = t2[A], they must also have t1[B] = t2[B].

This means that the values of the B component of a tuple in r depend on, or are determined by, the values of the A component;

We say that the values of the A component of a tuple uniquely (or functionally) determine the values of the B component. We say that there is a functional dependency from A to B, or that B is functionally dependent on A.

 

In functional dependency between two sets of attribute A and B

A $\rightarrow$B

A is determinant,B is dependent

ans should be C
Answer:

Related questions

0 votes
0 votes
2 answers
1
admin asked Mar 31, 2020
868 views
Normalization from which is based on transitive dependency is classified as:First normal form.Second normal form.Fourth normal form.Third normal form.
1 votes
1 votes
2 answers
3
admin asked Mar 31, 2020
4,534 views
If attribute of relation schema $R$ is member of some candidate key then this type of attributes are classified as:atomic attributecandidate attributenon-prime attributep...
2 votes
2 votes
1 answer
4
admin asked Mar 31, 2020
1,226 views
Which of the following is a fundamental operation in relational algebra?Set intersectionAssignmentNatural JoinNone of the above