retagged by
431 views

1 Answer

Best answer
8 votes
8 votes

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.

selected by
Answer:

Related questions

1 votes
1 votes
1 answer
2
Bikram asked Aug 26, 2017
402 views
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the max...
3 votes
3 votes
2 answers
3
Bikram asked Aug 26, 2017
412 views
$\sigma_{A=B \text{ and } B=C \text{ and } C=A} \bigg( \Pi_A (R) \times \Pi_B (R) \times \Pi_C (R) \bigg)$The number of rows returned by the above relational algebraic ex...
9 votes
9 votes
1 answer
4