Functional Description:

The Santa Clara Library Department operates under a tight budget and they are particularly concerned over the way our system currently handles fines, and its inability to detect whether certain borrowers repeatedly damage resources lent to them.

Today once a resource copy is returned, any overdue charges are correctly rolled into the total of what the borrower owes the library ... but then all record of the borrower ever having checked out the copy are obliterated. This is considered a problem because:

• The borrower is presented only with the total amount she owes. There is no way to include the details of where those charges came from if some of the total is based on late charges for resources which have already been returned.
• There is no way to detect, at what point in its lending history, a copy of a resource was damaged. So if for example a borrower of a Book reports that pages have been defaced or ripped out, there is no current way to determine who the previous borrower was.

Use Cases:

• Borrower History of Outstanding Fines

-Track and be able to summarize in a Borrower report, all outstanding Borrower overdue fines for both returned and unreturned Copies, and any penalties involving lost or damaged Copies.

-This report must identify each Copy involved (barcode, Book Title & Author), the dates it was loaned to the Borrower, the reason it is on the list (Checked Out Overdue, Returned Overdue, Returned Damaged, Declared Lost ...) and the amount of any fine or "Lost Copy" penalty.

• Assigning Responsibility for Damages

-Track complete checkout history of a Copy (Borrower, Dates, Condition returned) to allow library personnel to determine which Borrower took it out last before damage was reported

New Reports

Borrower History: All borrowers with overdue material (whether still checked out or previously returned with outstanding unpaid fine).

Borrower: Name, type of borrower, library card #

For Each item on which an outstanding fine or penalty still exists:

Title, author, Copy bar code, date checked out, optional date returned

Amount owed and Reason (Overdue, Lost, Damaged)

Copy Checkout History: Given Barcode

Checkout History (in chronological order from purchase to present)

Book Title, author, type, ISBN #, Catalog #

Copy Information (Bar Code, whether "Soft Cover")

(list)

Current Status (On shelves, On Hold, Unavailable, Checked Out)

Borrow History: Report Examples

• Borrower Overdue Query: Given the library card bar code #:

List (in reverse order) each copy checkout where an outstanding fine or penalty still exists, whether or not the checked out copy has since been returned.

Ex: Ron Kleinman, Teacher, 22334

Copy Date Date

Book Title Author Bar Code Checked Returned Fine Reason

Stranger in a Strange Land, Robert Heinlein, 7654321, 9/6/18, ***, $18.00, LOST

Fabric of the Cosmos, Brian Greene, 5678901 9/6/18, ***, $ 8.75 OVERDUE

Gone With the Wind, Margaret Mead, 123456, 3/12/17, 4/11/17, $ 4.25, RETURNED

• Copy Check Out History: Given the copy bar code #:

List each instance that the copy was checked out by a borrower in the past (reverse order):

CopyBar Code Book Title Author ISBN# Type Catalog#

7654321, Stranger in a Strange Land, Robert Heinlein, ABC1234, Fiction , ***

Lib Card # Name Checked Out Returned Condition

22334, Ron Kleinman, 5/6/18, ***, LOST

77882, Mary Smithson, 4/6/18, 4/19/18, OK

11991, John Johnson, 3/7/18, 3/12/18, OK

Borrow History: Start withmidterm Library System requirements (Basic System + "Reservation")

• Draw the updated LIS Conceptual Class Diagram which will support the above requirements

-Include any new class(es) required, and all their 1:N or N:1 labeled relationships with existing classes,

• For every new Class(es) identified and for the Copy class (which has been impacted)

-Provide the complete list of attributes (some of which might currently be in other classes). As always this should include the unique ID, and the type and state enumerated values,

-Extra Credit: Provide the Event/State diagram, for the major new class.