GATE DA · 2026 · DA
Question 61: Database Management and Warehousing
Give it a try, then reveal the answer to check your work.
Question 61
DANAT2 marksNeeds review
Consider an ER model with the entities E1 (A₁₁, A₁₂, A₁₃) and E2 (A₂₁, A₂₂, A₂₃), where, A₁₁, A₁₂, A₁₃ are the attributes of E1, and A₂₁, A₂₂, A₂₃ are the attributes of E2. Let A₂₂ be a multi-valued attribute. A₁₁ and A₂₁ 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)
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerEXPLORE & PRACTISE
Paper and topic context
See where this question comes from and choose what to practise next.
2026DA
GATE DA 2026 · Paper 1
Data Science and Artificial Intelligence · Original paper archive
- Section
- Data Science and Artificial Intelligence
- Question type
- Numerical answer (NAT)
- Marks
- 2 marks
Practise related topics
Explore more previous year questions using this question’s imported topic tags.
data science
GATE DA previous year questions
artificial intelligence
GATE DA previous year questions
computing
GATE DA previous year questions
database management warehousing
GATE DA previous year questions
Database Management and Warehousing
GATE DA previous year questions
er model
GATE DA previous year questions
normal form
GATE DA previous year questions
relational model
GATE DA previous year questions
Comments
Ask a question, share your approach, or help someone understand.
Log in to view the discussion
You’re not logged in. Log in or create an account to see discussions and add comments.