GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 16

Which of the following option is not correct regarding to convert an ER diagram into relational table ?
(A) If the ER diagram has 1:1 cardinality and both side have total participation, then the minimum number of table required to convert into relational model is 1.
(B) If the ER diagram has 1:1 cardinality and one side has total and another side has partial participation, then the minimum number of table required to convert into relational model are 2.
(C) If the ER diagram has 1:1 cardinality and both side have partial participation, then the minimum number of table required to convert into relational model are 3.
(D) If the ER diagram has 1:N cardinality and one side has total and another side has partial participationn, then the minimum number of table required to convert into relational model are 3.

Answer: (D)
Explanation: If the ER diagram has 1:N cardinality and one side has total and another side has partial participationn, then the minimum number of table required to convert into relational model are 2.

Only option (D) is false.
Quiz of this Question

Article Tags :

GATE

Recommended Articles

1. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 15

2. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 17

3. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 18

4. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 19

5. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 20

6. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 21

7. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 22

8. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 1

9. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 5

10. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 2

11. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 3

12. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 4

13. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 6

14. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 7

15. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 8

16. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 9

17. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 10

18. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 11

19. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 12

20. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 13

21. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 14

22. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 23

23. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 24

24. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 25

25. GATE | Sudo GATE 2020 Mock III (24 January 2019) | Question 26