Library Management System

Database definition

A database is a collection of organised data,information and records. A library database is a searchable electronic index of published, reliable resources. Databases provide access to a wealth of useful research materials from academic journals, newspapers, and magazines. Some databases also include e-books, relevant Web resources, and various multimedia. The information found in databases is either originally created or comes from different, reliable sources.

Our Aim of the Project

Library databases index edited, published material, often scholarly, and collected for an educational use, and subscribed to by your school because it is judged to be useful to the curriculum. Library databases are more focused on scholarly books and articles, and provide more of them, than the open web. Anyone can publish anything on the Internet so one must be willing to sort through and evaluate an Internet site’s content. Databases are more credible because publishers have checked the contents for accuracy and reliability. Databases provide quick access to information on the Web, such as newspaper, magazine articles, biographies, books reviews, images and more. The databases provide access to information that is safe, accurate, current, validated, copyright –clear, and organized. Information in databases can be searched using different age appropriate interfaces and results can be matched to each student’s individual reading ability. Searching is precise, quick and convenient. When a student is surfing the World Wide Web using a search engine like Google, the student is searching information from billions of sites, both good and bad. Since anyone can publish on-line there is a large amount of information, which is unsafe, unreliable, inaccurate, outdated and biased. In addition, annoying popup ads and animated images often cause distractions and frustrations. The World Wide Web has been described as the “Wild West of information, with no sheriff in town.”

DATABASE CREATION

We first created a Firebase realtime database to store the details of the book such as the ISBN number,author,title and description of the book

A short snippet of our database:

DATABASE HOLDING BOOKS

Firebase realtime database is created to store the details about the books

The following snippet shows the connectivity to our database

The database holds various information about the books like,
- Title
- isbn
- authors
- category
- Description

We now see how to access information from our database by entering various information about the book

CASE 1:

Get the title of the book given the ISBN number

The following snippet shows the query to get the title of the book given the ISBN number

The output of the query is as follows:

CASE 2:

Get the authors of the given book

The following snippet shows the query to get the authors of the given book

The output of the query is as follows:

CASE 3:

Get the description of the book

The following snippet shows the query to get the descrition of the book given the book title

The output of the query is as follows