retagged by
933 views
3 votes
3 votes

I think ans is A,Please Confirm?

retagged by

1 Answer

Best answer
4 votes
4 votes

OPTION B

In many to one relation , always many side is key..


ER1 :  Let's take counter example..

       All records of P related to same record in Q , like -

      P      Q
      P1     Q1
      P2     Q1
      P3     Q1

Now , Becoz P has total participation , so table P has 3 records for P1, P2, P3  respectively..But Q can have any number of records.. So, we can't say that table 'P' will have more records than table Q..


ER2 : Here Q side total participation  but P side can have any number of entities besides those who are in relationship..

       P       Q
       P1       Q1
       P2       Q2
       P3       Q2
       P4       Q3

Here , many to one relationship and Q side total participation - means Q will have 3 entities & P has 4 enities , (P>Q)

Here we can notice that P is key so can't repeat & hence P>=Q   (P can have more records as it is in partial participation but never less)..

selected by

Related questions

0 votes
0 votes
0 answers
1
practicalmetal asked Oct 26, 2023
359 views
Can someone please provide me with the correct explanation for this question
0 votes
0 votes
2 answers
4
kd..... asked Apr 26, 2019
776 views
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...