GATEverse
← GATE IT 2004

Q73

MCQ2 marks, −0.5

Consider the following entity relationship diagram (ERD)(ERD), where two entities E1E1 and E2E2 have a relation RR of cardinality 1:m.

Figure 1

The attributes of E1E1 are A11A11, A12A12 and A13A13 where A11A11 is the key attribute. The attributes of E2E2 are A21A21, A22A22 and A23A23 where A21A21 is the key attribute and A23A23 is a multi-valued attribute. Relation RR does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF3NF) is designed from the above ERDERD. The number of tables in the database is

Sign in to save attempts.

Loading…