Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need a Conceptual Class Diagram and Attributes identified for a Library Inventory System with the following specifications: Functional Specification Every book in the new De

Need a Conceptual Class Diagram and Attributes identified for a Library Inventory System with the following specifications:

Functional Specification Every book in the new De Anza library has a title, publisher, author,editionand "type" (fiction or non fiction), and is uniquely identified by its ISBN (International Standard Book Number). 1) All copies of non fiction books are arranged on the shelves by Book catalog number (ex: 710.46E), while all copies of fiction books are arranged alphabetically by author / title. There may be zero or more copies of any given book on the shelves

2) Any or all of them may be soft cover copies (i.e. paperbacks) Each copy of every book in the library (fiction or non fiction) has a distinct bar code, which is stringified by the bar code scanner during the checkout procedure. This string uniquely identifies the copy. A non-fiction book may or may not be a reference work (ex: expensive Art Book), but all reference books are non-fiction

3)No reference book ever has a soft cover copy. There are separate shelves set aside for hard covered fiction, non-fiction and reference works, and a separate rack for all soft cover fiction. All borrowers need a library card, which has their name on the front, and a bar code on the back which uniquely identifies the borrower. Every library card also has an expiration date. If the borrower does not renew the card before then, the card expires and can no longer be used to borrow anything.

Any student or teacher at De Anza with a library card may borrow (check out) copies of books. They may do so by using the scanner which sits in the lobby of the library to read the unique bar code on their library card, and the unique bar code stamped on the copy ofevery book they are checking out . They may also go to the front desk where the librarian will check out the material by scanning the card and book copy bar codes for them.A copy of any book may normally be checked out for 10 days, but copies of reference books may only be checked out by teachers, and then only for 3 days. An individual copy is either checked out , unavailable for a variety of reasons, or on the library shelves. A security system prevents theft.

No borrower (student or teacher) who has a copy of an overdue book checked out, or has 4 other copies checked out, may check out another copy of any book. Late fees are 25 cents per day per book, except for copies of reference books which have fines of one dollar per day, and soft cover copies which have fines of 10 cents per day. No reference book ever has a soft cover copy.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students also viewed these Databases questions

Question

Trait - based performance appraisal systems are most similar to:

Answered: 1 week ago