Best Training App Ideas
The Librarian

Application to help your local library to organise book catalogue and offer students a way to check which books they have checked out from the library.

Who will use this app?

This app will have two interfaces and two user roles. The first role is a "Librarian", a person who uses a computer inside a library for one of the following tasks:


registering new books and editing number of each book.
registering students
assigning borrowed books to the students
noting down returned books


The second user role is Student, who have account and password, allowing the following tasks:


see which books you have borrowed and when they are expiring
extend borrowed books


Data Model

We need to have the following models:


All the books (includes ISSN, title, author as well as number of copies)
Student (student code, password, email)
Librarians (librarian code, password, email)
"Borrowed book" (record for each borrowed book, date when borrowed, date when book must be returned, link to student and link to a book)


Reports

A Librarian should also be able to see several reports:


List of Student ordered by a number of "Borrowed books" which are Overdue