Open In App
Related Articles

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

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
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

Last Updated : 20 Jan, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads