GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2015 · Session-1
Database ManagementER-ModelmediumNAT2 marks
Consider an Entity-Relationship (ER) model in which entity sets E1 and E2 are connected by an m:n relationship R12. E1 and E3 are connected by a 1:n (1 on the side of E1 and n on the side of E3) relationship R13. E1 has two single-valued attributes a11 and a12 of which a11 is the key attribute. E2 has two single-valued attributes a21 and a22 of which a21 is the key attribute. E3 has two single-valued attributes a31 and a32 of which a31 is the key attribute. The relationships 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 __________.
Save your progress

Related Database Management PYQs

GATE 2015 · Set-3

SQL allows duplicates tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which on…

GATE 2015 · Set-1

Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary); departments(dept-id,dept-name,ma…

GATE 2015 · Session-1

A file is organized so that the ordering of data records is the same as or close to the ordering of data entries in some index. Th…

GATE 2015 · Set-2

In a B+ tree of order d (maximum number of pointers per internal node is d), the minimum number of keys in any non-root internal n…

GATE 2015 · Session-1

SELECT operation in SQL is equivalent to

GATE 2015 · Session-1

See the question below and answer