119 views

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 | 119 views

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
0

if another key also mentioned than it will be one to one

1