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

asked in Databases by Loyal (9.8k points)
retagged by | 116 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.9k points)
selected by
0

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

key B--->A

Related questions

0 votes
0 answers
6
0 votes
0 answers
7
asked Aug 30, 2018 in Databases by bts1jimin (199 points) | 100 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

47,080 questions
51,333 answers
177,708 comments
66,675 users