QUESTION

Text
Image

The library case study described is extended to include the fact that the library has significant stock of book that are no longer suitable for loaning out. these books can be sold out for a fraction of the original cost. however, not all library books are eventually sold as many considered too damaged to sell on, or are simple lost or stolen. each book copy that is suitable for selling has a price and the date that the book is no longer to be loaned out. introduce enhanced concept in to the ER model shown in figure:


Practice 2 Q2: The library case study described is extended to include the fact that the library has a significant stock of books that are no longer suitable for loaning out. These books can be sold tor a fraction of the original cost. However, not all library books are eventually sold as many are considered too damaged to sell on, or are simply lost or stolen. Each book copy that is suitable for selling has a price and the date that the book is no longer to be loaned out. Introduce enhanced concepts into the ER model shown in Figure Figure Library ER model

Draw a EER enhanced Entity Relationship for this question

modify the current ER model to EER enhanced Entity Relationship

Public Answer

UR8WHW The First Answerer