UTpaper

Free mock tests & test series

Question 59Asked in UGC NET Computer Science, June 2015 (Paper II & III, Selected Questions)

Let E₁ and E₂ be two entities in E-R diagram with simple single valued attributes. R₁ and R₂ are two relationships between E₁ and E₂ where R₁ is one - many…

Let E₁ and E₂ be two entities in E-R diagram with simple single valued attributes. R₁ and R₂ are two relationships between E₁ and E₂ where R₁ is one - many and R₂ is many - many. R₁ and R₂ do not have any attribute of their own. How minimum number of tables are required to represent this situation in the Relational model?
  1. A4
  2. B3
  3. C2
  4. D1
Show answerHide answer

Correct answer: (B) 3

Explanation

One table for each entity : 2 R₁ is one to many (No separate table): 0 R₂ is many to many and requires one separate table: 1 Total number of tables: 3

From UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions)

This is question 59 of UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.