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 -
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)..