The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
0 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

asked in Databases by Loyal (9.2k points)
retagged by | 119 views

1 Answer

+2 votes
Best answer
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
answered by Boss (10.7k points)
selected by

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

key B--->A

Related questions

0 votes
0 answers
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
49,540 questions
54,099 answers
71,006 users