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.7k points)
retagged by | 118 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 (11k points)
selected by

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

key B--->A

Related questions

0 votes
0 answers
0 votes
0 answers
0 votes
0 answers
asked Aug 30, 2018 in Databases by bts1jimin (245 points) | 111 views
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
48,564 questions
52,765 answers
68,245 users