UGC NET Computer Science December 2019 | Question 73

Question 73

---

Find minimum number of tables required for converting the following entity relationship diagram into relational database?

1. 1. 2
2. 2. 4
3. 3. 3
4. 4. 5

Explanation

Here we have 1 to Many relation so we requires two tables.

Attribute B being multi-valued, we need to remove the multi-valued attribute B to convert given entity relationship diagram into relational database.

As relational database do not allow multi-valued attributes. We have to instroduce new table.

So, number of tables as below:

1. R₁
2. R₁₂R₂
3. A table for B (Multi-valued attribute)

So, total 3 tables are required for the given entity relational diagram.

So, option 3 is correct answer

Previous	Next
UGC NET CS December 2019 - Question 72	UGC NET CS December 2019 - Question 74