Register

SELF DOUBT

749 views
2 2 votes

Hi Can any one explain by Diagram. It will be more Easy to understand

Thanks,

Let R represents an one to many relationship between entities E1 and E2 and the set A, B attributes represent the key of R (A is key for E1 and B is key for E2) then which of the following statements is correct

  1.   The FD, A→B will only holds
  2.  The FD, B→A will only holds
  3.  (a) and (b) hold together
  4.   Neither (a) nor (b) holds

1 Answer

3 3 votes
may be 2 is the answer. if the relation A has three values (1,2,3) and relation B has three values (1,2,3). since relationship is one to many , we can form relationship instances (1,1),(1,2),(2,3). now b attribute can identify attribute A.
Voting & Accepting an answer helps improve the community
← Previous · test seriesNext → · gatebook-os
← Previous in category · normalizationNext in category → · test series
Position:
Show:

Related questions

0 0 votes
1 1 answer
686
686 views
kunal13 asked Jun 3, 2024
686 views
Self Doubt relate to ER diagrams(Databases).
 In (https://gateoverflow.in/219555/number-of-tables) number of tables to be made was 4, merging E1 and E2 in one table, one for R3, and for E3 and one for E4. Now based ...
1 1 vote
1 1 answer
3.3k
3.3k views
aditi19 asked Jun 7, 2019
3,271 views
ER Model Self Doubt
How to represent referential integrity constraint in ER model?pls explain with diagram
0 0 votes
2 2 answers
1.6k
1.6k views
kd..... asked Apr 26, 2019
1,562 views
Self Doubt: Databases ER diagram
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong enti...
1 1 vote
0 0 answers
810
810 views
Hemanth_13 asked Dec 4, 2018
810 views
Self Doubt on ER diagram
How to solve these type of questions https://gateoverflow.in/201404/er-diagramCopying the image for quick reference:Minimum no of tables.My approach was:First allocate al...