The library case study described in Exercise 12.14 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 for 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 13.12 and described in Exercise 12.14 to accommodate this extension to the original case study.

What will be an ideal response?


Computer Science & Information Technology

You might also like to view...

In SharePoint, a(n) ________ is a collection of announcements, links, surveys, discussion boards, or tasks

Fill in the blank(s) with correct word

Computer Science & Information Technology

In Project 2010, you can add a third level to the timescale.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

To analyze specific values in a field as a unit, group PivotTable data.?

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The business traveling rule, "If the flight costs less than $300.00 and the hotel is less than $120.00 per night" is an illustration of ____ conditions.

A. continuous B. compound C. contiguous D. grouped

Computer Science & Information Technology