Question

Number of tables required and also the attribute set of the tables

Comments

i also don't know the answer can you please provide the attribute set of all the 5 tables?

---

Anu.. Can't we do this in 4 because the multivalued attribute will be placed with the keys of E2 and E3?

---

vaibhav if question specify BCNF then no we cannot but with 1NF we can do it with 4 tables.

Answer 1

table (relation) schema
E1 (a11, a12)   //a11= pk (primary key)
E2(a21,a11)    //as a21 is derived attribute and it is not mention from which it is derived so pk = {a21,a11}
R13 (a21, a11, a31)    // m:n so it will have its own table with primary key of entities
E3 (a31)    // a31 = pk, not sure will a32 comes here or not although it will surely have a separate table with foreign key as a31 refering to primary key in e3.
E'3 (a31, a32)   // pk = {a31, a32}