Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected by an m : n relationship R 12 . E 1 and E 3 are connected by a 1 : n (1 on the side of E 1 and n on the side of E 3 ) relationship R 13 . E 1 has two single-valued attributes a 11 and a 12 of which a 11 is the key attribute. E 2 has two single-valued attributes a 21 and a 22 of which a 21 is the key attribute. E 3 has two single-valued attributes a 31 and a 32 of which a 31 is the key attribute. The relationship do not have any attributes. If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is _______.

GATE Computer Science (CS) 2015 Shift 1 Solved Paper

Question : 48 of 65

Marks: +1, -0

Consider an Entity-Relationship (ER) model in which entity sets E₁ and E₂ are connected by an m : n relationship R₁₂. E₁ and E₃ are connected by a 1 : n (1 on the side of E₁ and n on the side of E₃) relationship R₁₃.
E₁ has two single-valued attributes a₁₁ and a₁₂ of which a₁₁ is the key attribute. E₂ has two single-valued attributes a₂₁ and a₂₂ of which a₂₁ is the key attribute. E₃ has two single-valued attributes a₃₁ and a₃₂ of which a₃₁ is the key attribute. The relationship do not have any attributes.
If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is _______.

Your Answer:

Validate

Go to Question:

Prev Question

Next Question