Question Details

Consider two entity sets E1(A11, A12, A13) and E2(A21,A22,A23) with A11 and A21 as PK.

A22 is a multivalued attribute. R12 is a many to many relationship with total participation on both side. What is the min number of relations required to convert this ER model to relational model in 3NF?

Show Answer
Correct Answer
4

Solution :

The correct answer is 4.

To determine the minimum number of relations (tables) required to represent the given Entity-Relationship (ER) model in the relational model in Third Normal Form (3NF), we analyze each component of the ER diagram step-by-step:
1. Entity E1: E1 has attributes A11, A12, and A13, with A11 as the Primary Key (PK). This entity is represented by a relation:
E1(A11, A12, A13)
This gives us 1 relation.

2. Entity E2 and its multivalued attribute: E2 has attributes A21, A22, and A23, with A21 as the PK. However, A22 is a multivalued attribute. In relational database design, multivalued attributes cannot be stored directly in the main entity table because doing so would violate First Normal Form (1NF). Therefore, they must be split into a separate relation:
- The main relation for E2: E2(A21, A23)
- The relation for the multivalued attribute A22: E2_A22(A21, A22), where both attributes together form the composite primary key.
This gives us 2 relations for E2.

3. Relationship R12: R12 is a many-to-many relationship between E1 and E2. A many-to-many relationship always requires its own separate junction table containing the primary keys of the participating entities as foreign keys. Even with total participation on both sides, a many-to-many relationship cannot be merged into either E1 or E2 without causing redundancy or violating normal forms. Thus, we need a separate relation for the relationship:
R12(A11, A21)
This gives us 1 relation for the relationship.

Summing up the required relations:
- Relation for E1: 1
- Relations for E2 (including multivalued attribute A22): 2
- Relation for many-to-many relationship R12: 1

Total minimum number of relations required = 1 + 2 + 1 = 4.

Transparent Access on Mindyard

Built for Learners & Educators Alike

Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.

FREE FOR STUDENTS

Practice & Learn Free for Students

Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.

  • Unlimited mock tests & question bank practice
  • Full access to curated study library & formula notes
  • 100% free for students • No credit card required
2 MONTHS FREE TRIAL

Educators & Coaching Institutes

Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.

  • AI question uploader & rapid test generator
  • Anti-cheating tab proctoring & performance reports
  • Full Pro access free for 60 days • No upfront commitment
Discover more resources

You may also like

Mock Tests

View All
  • GATE
  • beginner
  • 3 hours
  • civil engineering

Prepare for GATE 2026 Civil Engineering with the latest question papers, previous year papers, detailed solutions, syllabus, exam pattern, preparation tips, mock tests, and subject-wise study material. Download GATE 2026 CE question papers with solutions in PDF format and boost your preparation for top engineering institutes and PSU recruitment.

  • GATE
  • beginner
  • 3 hours
  • electronics and communication engineering

Prepare effectively for GATE 2026 Electronics & Communication Engineering (EC) with this comprehensive Question Paper with Solutions. This resource includes detailed explanations, concept-wise solutions, previous year paper analysis, and exam-oriented practice to help aspirants strengthen core subjects like Electronic Devices, Analog Circuits, Digital Circuits, Signals & Systems, Network Theory, Control Systems, Electromagnetics, Communications, and more. Perfect for revision, self-assessment, and boosting your GATE 2026 EC preparation strategy.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...
Ask your own doubt or choose a quick prompt: