Test by Bikram | Databases | Test 2 | Question: 18

Question

The above ER diagram depicts a book rental scheme.

If this ER diagram is mapped to a relational model, to correctly depict this above scenario, the total number of relations required will be _________.

Answer 1

Student(Sid, Sname, Address)

Book(BNo, Publisher)

Since it is many to many relationship a separate table will be required So, we can write hasRented(Sid, BNo)

One Table for multivalued attribute Phone no with attributes -> (Sid, PhoneNo)

Another Table for multivalued attribute Color with attributes -> (BNo, Color)

Therefore total 5 relations will be required.