Register

ER Model

• edited by
268 views
0 votes
0 votes

Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows :

A.

pk(R2) → pk(R1)
B.

pk(R1) → pk(R2)

C

pk(R2) → R1 ∩ R2
D.

pk(R1) → R1 ∩ R2

 

• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Ashutosh_17 asked Apr 13, 2023
433 views
Database ER model
Consider the following relation (capitalized letters are attributes and lower letters are values). X: From the given FDs find the dependencies that seems to apply on X and identify a possible key (Candidate key) for X. A→C,D→E,C→A,E→B E→A,C→B,B→D,B→A
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
User Avatar
0 votes
0 votes
2 answers
3
priyanshu710 asked Sep 15, 2021
793 views
ER Model to Relational Model Conversion
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side? Can i have just a single table with all attributes and (A1,B1) as a composite primary key?
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side?Can i have just a single table with a...
User Avatar
1 votes
1 votes
1 answer
4
aditi19 asked Jun 7, 2019
1,897 views
ER Model Self Doubt
How to represent referential integrity constraint in ER model? pls explain with diagram
How to represent referential integrity constraint in ER model?pls explain with diagram
User Avatar
Link Copied!