GATE DA 2026 — Question 61

Database Management and WarehousingER-modelNAT2 marksMedium

Consider an ER model with the entities E1(A\(_{11}\),A\(_{12}\),A\(_{13}\)) and E2(A\(_{21}\),A\(_{22}\),A\(_{23}\)), where, A\(_{11}\), A\(_{12}\), A\(_{13}\) are the attributes of E1, and A\(_{21}\), A\(_{22}\), A\(_{23}\) are the attributes of E2. Let A\(_{22}\) be a multi-valued attribute. A\(_{11}\) and A\(_{21}\) are the primary keys of E1 and E2, respectively. Let R12 be a many-to-many relationship between E1 and E2. Participation of both E1 and E2 in R12 is total. The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)
Practise the full 2026 paper
Challenge a friend: WhatsApp Telegram
From RENYXERAWhat rank do your marks get?GATE score, likely All-India Rank and qualifying marks for your category.
Practise more on ER-modelTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group