GATE 2022: Database Management System Quiz-1

Specialization is denoted by ________ in ER diagram

Find the number of correct statements from the following sentences:

I. All 1:M and 1:1 relationships should be converted into separate tables.

II. All multi valued attributes should be converted into separate tables.

III. Cardinality ratio is applicable for only binary relationships.

IV. A key attribute can uniquely identify an entity from an entity set.

The minimum number of tables required if attribute a22 is a composite attribute?