retagged by
713 views
1 votes
1 votes

Suppose that we have a relation schema R(A, B, C) representing a relationship between two entity sets with keys A and B, respectively and suppose that R has the FD: A $\rightarrow$ B, then the relationship in relational model possible is __________ .

A. One to many                                                                       B. One to one

C. Many to one                                                                        D. Many to many

retagged by

1 Answer

Best answer
3 votes
3 votes
Here A->B is the FD

so we are identifying B with A so A must be unique but B need not be

It can be like this

A        B

a         1

b          1

Here 1 is mapped to a,b of A which are unique by which 1 can be identifies so it is a many to one
selected by

Related questions

1 votes
1 votes
2 answers
1
ajaysoni1924 asked May 22, 2018
707 views
What should be correct option for 1. and why...?
0 votes
0 votes
3 answers
2
ajaysoni1924 asked May 22, 2018
488 views
minimum no. of tables required....!!!How to do such question where aggregation generalization or specialization is involved