1

Library Management System Database Design

Library management system database design is key for storing and managing data. In this project we provide a information of every database table with every field.

Database is important for every project which is called as back end application. When user enters data from front end graphical user interface data is stored in to database based on sql query we write in code. For every specific operation there will be different tables like storing customer information we create customerinfo database table with required fields and data is stored in to this table.

Library Management System Database Design

Key features for database design are giving types, primary key, foreign key and secondary key. Data that we store in database for years are maintained without any problem .We need to take back up for security purpose and reduce chances for loosing data.

Detailed explanation on existing and proposed system is explained in Library Management system SRS documentation.

Working:

When user enters data in to front end GUI data from fields are stored in buffers and transfer data in to SQL query. When query is executed database connection is opened and then data is stored in to database.

Youtube link for step by step ODBC Database connection establishment.

Video for database Design and Connection:

How to check:

We can open database and execute retrieve query to find out details in database. Other process is when data is inserted correctly we can view data from front end.

Download Library Management System Database Design

Data types details used in Library management system:

Number: This is a data type which can store double precision , floating point and eight byte data.

Text:  This data type can store maximum of 250 characters and maximum length of text variable is 1024 characters.

Date Time: This data type is used for storing data and time 

Database Name: Books 

Field Name

Data Type

Description

BookId

AutoNumber

Primary Key

Subject

Text (30)

-

Title

Text (30)

-

Author

Text (25)

-

Publisher

Text (25)

-

Copyright

Number

-

Edition

Number

-

Pages

Number

-

ISBN

Text

-

NumberOfBooks

Number

-

NumberOfAvailbleBooks

Number

-

NumberOfBorrowedBooks

Number

-

Library

Text(25)

-

Availble

Yes/No

-

ShelfNo

Number

-

 

 Table Name: Borrow  

Field Name

Data Type

Description

BookId

Number

Primary Key

MemberID

Number

-

DayOfBorrowed

Date/Time

-

DayOfReturn

Date/Time

-

 

Table Name: Members 

Field Name

Data Type

Description

MemberId

AutoNumber

Primary Key

ID

Number

-

Password

Text(10)

-

NAME

Text(25)

-

EMAIL

Text(25)

-

Major

Text(10)

-

NumberOfBooks

Number

-

Mony

Number

-

Expired

Date/Time

-

Also refer to: Library Management System Project in JAVA

Related Posts

  • Airline Reservation System Project Airline Reservation system project (asp.net) will cover basic features which are explained below. Which is part of user requirements? Project Requirements: Front end Design must be in Asp...
  • Online College Administration Project Online college administration project is a online web portal designed to manage entire information of college through a web portal. This project is developed in ASP.Net using SQL Server. This appli...
  • Shoe Store Billing Management System Project Project Titled Shoe Store Billing Management System Project is a software application designed in visual basic( VB.NET) platform and MS Access database. Main objective of this project is provide a ...
  • Retail Store Inventory Management System Software Retail Store inventory management system project is designed in visual basic ( vb.net ) using Microsoft SQL server database. This software application is stand alone software which can be installed...
  • Lab Management System Project Report Lab Management System Project is a web based application which is used to organize lab tasks in a efficient way. This application is designed in java programming language. Lab Management Syste...
  • Implementing Institute Management System Project Institute Management System project is developed to manage information of institutes using a online portal. This application is designed and implemented in ASP.NET and SQL Server. This application ...
Filed in: database design

Get Updates

Share This Post

© 2014 Project Seminar. All rights reserved.