6 Sep '12

Shiva Prasad

Hello all, I am collecting resources from different sources and Our freelance developers are developing VB.Net, ASP.Net, PHP, ASP, JAVA, Android projects, C# Programming, C and C++ programming projects for IT, Diploma and engineering students.

10 Shares

Library Management System database design

Advertisements

This page contains information of Library Management System database design. The database is a collection of information and is systematically stored in tables in the form of rows and columns. The table in the database has unique name that identifies its contents. The database in turn is further described in detail giving all the fields used with the data types, constraints available, primary key and foreign key.

Database design is used to manage large of information. In this database we describe the entire 4 table available in the software, which are used to store all the records.

2. Data types and its description:

Fields in database table have a data type used in database table are explained below.

  1. Integer: one optional sign character (+ or -) followed by at least one digit (0-9). Leading and trailing blanks are ignored. No other character is allowed.
  2. Varchar:  It is used to store alpha numeric characters. In this data type we can set the maximum number of characters up to 8000 ranges by defaults SQL server will set the size to 50 characters range.
  3. Data/time: Data/time data type is used for representing date or time.

Database Name: bookdetails

Field Name  Data Type  Size  Relation
Accno Varchar 50 Primary key
Author Varchar 50 Not null
Title Varchar 50 Not null
Publication Varchar 50 Not null
Edition Varchar 50 Not null
No_of_copies int Not null
Volumn Varchar 50 Not null
Date_pur Varchar 50 Not null
Price Decimal (18,2) Not null
Status Varchar(50) 50 Not null

 

Database Name: student

Field Name  Data Type  Size  Relation
Name Varchar 50 Not null
Regno Varchar 50 Primary key
Date_of_issue Datetime Not null
Addresss Varchar 50 Not null
Date_of_return Datetime Not null
Course Varchar 50 Not null
Accno Varchar 50 Foreign key
Gender Varchar 50 Not null

 

Database Name: issue

Field Name  Data Type  Size  Relation
Regno Varchar 50 Foreign key
Date_of_issue_books Datetime Not null
Date_of_return_books Datetime Not null
Accno Varchar 50 Not Null
Name Varchar 50 Not null
Course Varchar 50 Not null
Author Varchar 50 Not null
Volumn Varchar 50 Not null
Edition Varchar 50 Not null

Database Name: return

Field Name  Data Type  Size  Relation
Regno Varchar 50 Foreign key
Accno Varchar 50 Not Null
Date_of_return_books Datetime Not null
Date_of_issue_books Datetime Not null
Name Varchar 50 Not null
Course Varchar 50 Not null
Author Varchar 50 Not null
Volumn Varchar 50 Not null
Edition Varchar 50 Not null

Entity Relationship Diagram:

Entity Relationship Diagram is used in modern database software engineering to illustrate logical structure of database. It is a relational schema database modeling method used to

Model a system and approach. This approach commonly used in database design. The diagram created using this method is called ER-diagram.

The ER-diagram depicts the various relationships among entities, considering each object as entity. Entity is represented as rectangle shape and relationship represented as diamond shape. It depicts the relationship between data object. The ER-diagram is the notation that is used to conduct the data modeling activity.

Entity: Entity is the things which we want to store information. It is an elementary basic building block of storing information about business process. An entity represents an object defined within the information system about which you want to store information. Entities are distinct things in the enterprise.

Relationship: A relationship is normal connection or association between entities used to relate two or more entities with some common attributes or meaningful interaction between the object.

Attributes: Attributes are the properties of the entities and relationship descriptor of the entity. Attributes are elementary pieces of information attached to an entity.

Download this documentation

Download synopsis of Library management system project in JAVA

Library management system project SRS document

 

For more project Ideas visit http://www.bestprojectsidea.com/
For Source code of all projects visit http://www.studentprojectcode.com/
Advertisement

About Shiva Prasad

Hello all, I am collecting resources from different sources and Our freelance developers are developing VB.Net, ASP.Net, PHP, ASP, JAVA, Android projects, C# Programming, C and C++ programming projects for IT, Diploma and engineering students.

Related Posts

  • naveen

    please post the soucre code to work on fedora os

    • admin

      Rite now we not offering that.

  • Hamid

    how to create it?

  • Hamid

    please post to me the source code to this work.

  • Andrew

    Here’s example code to create the tables using SQL (including MySQL):
    CREATE TABLE bookdetails (
    Accno VARCHAR(50) NOT NULL PRIMARY KEY,
    Author VARCHAR(50) NOT NULL,

    No_of_copies INT NOT NULL,

    Price DECIMAL(18,2) NOT NULL,
    Status VARCHAR(50) NOT NULL
    ) DEFAULT CHARACTER SET utf8;

    I suggest looking at the MySQL Reference Manual for more information:
    http://dev.mysql.com/doc/refman/5.6/en/