San Francisco Bay Area

QUICKLIB - A R.V.Lutionary App

September 2013   |       RV College of Engineering     |  Team size : 4

Problem Statement : Students often take multiple trips to the library to check the availability of the book. The availability of the book can be checked using a computer in the library or by manually looking for the book. This process is time consuming. 

Solution:

An easy to use Android application that accesses the college library book information anytime, anywhere and has the following key features -

  1. A search feature using fields like author name, book name, edition and branch. An ordered list of books available at present in the library stack is displayed along with the number of books which are expected for return on a certain day.

  2. If a book is not available, then the user can choose to get notification when the book becomes available and also can get updates if the books get borrowed before the user could issue it.

  3. An authentication for each student and faculty.

Sketches/ Wireframes :

 

 Implementation :

 AppsterChef mainly consists of 4 Components 

  • Android Phone (the client)- the android phone has the required input fields to gather the data from the user, sends the data to the php front end via Internet. It also accepts the response from the server to display the results to the  user.

 

  • Php Front end of the Server- the front end acts as the intermediate entity where it takes the input from the client and gives it to the database and vice versa. It also formulates the SQL query for the data retrieval from the server based on the input given by the user. It is to be noted that the php front will not contain a form as the android phone acts as the form.

 

  • Database- The database is stored on a remote location (hosted on byethost.com) which can be accessed by the administrators or the php front end. The data base uses Structured Query Language MYSQL to manage the data held in the database.

 

  • Connectivity –the phone and the php front end communicate data through the internet via the HTTP Api’s. The HTTP api’s uses a well know PORT (80) for the communication between the front end and the phone. It uses the stateless transfer methods for communication .The most preferred HTTP Api is the HTTPOST. This api is used to insert/update the data to the server and in response to this request, the sever give a reply which should contain the queried information. The format used by the server to send back the information is a JSON OBJECT which facilitates the easy retrieval of data.  

Screen Designs :

Conclusion : QuickLib was widely used and appreciated by students of RV College of Engineering.

There is scope for further improvement such as An option where a student can reserve a book, but only for a specific period of time within which he has to visit the library and issue it, failing which, the book becomes available to everyone again.

Honors : Rated in top 5(of 25) Android applications of the batch by Android experts from Samsung

Architecture Diagram

Data Flow Diagrams

Home page 

Search Activity

List of books queried

Notification when book becomes available