Description
The Tool Library helps members make repairs to their homes and gardens by loaning hand tools and power tools for 1-7 days. Up until now, the library has been managing its inventory of tools using a database designed by one of its volunteers. The Tool Library would now like a system for keeping track of tools that have been loaned to library members. The existing database will need to be extended to keep track of loan information and an application interface needs to be developed to allow librarians who don’t know SQL to record loans and returns.
Target users
Library Member
Librarian
Tags
User Stories
List
As a library member or librarian, I can view the tool inventory and see a list of tools available to be loaned.
Log in
As a library member, I need the ability to “log in” so that I can use the system to manage my personal information.
Librarian Log in
As a librarian, I need the ability to “log in” so that I can use the system to help patrons check tools out from the tool lib
Add to Shopping cart
As a librarian, I can add tools to a “shopping cart” for a member so that it’s easier to loan multiple tools at once.
View Shopping Cart
As a librarian, I can add tools to a “shopping cart” for a member so that it’s easier to loan multiple tools at once.
View Checked Out
As a librarian, I can view a list of all tools that are currently checked out and to which library member.
Tool Search
As a librarian, I can find and view an existing tool loan record by looking up the borrower’s name, driver’s license, or tool number.
User Register
As an anonymous user, I need to be able to register to access the system.
User Tool Search
As a user, I need to be able to search for tools that are available to be checked out for I can complete the project I want to work on. I also need to be able to search for tools that are checked out and when they might be available.
Checkout
As a user, I need to be able to check out a tool item from my shopping cart for my use.
Status
As a user, I need to be able to check on the status of the items I have checked out to determine due dates, the list of items checked out, etc.
User Add to Shopping Cart
As a user I need to be able to add items to a shopping cart for subsequent checkout.
User Tool Reserve
As a user, I need to be able to reserve a tool that is currently checked out so that it cannot be renewed.
User Tool Renewal
As a user, I needed to be able to renew a tool checkout unless some other user has reserved it. There will need to be a maximum number of renewals per tool checkout.