ER DIAGRAM

Question

I think ans is A,Please Confirm?

Comments

OPTION B is correct..

---

explanation?

---

check my answer..

Answer 1

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