Library Management System


Posted Date:     Total Responses: 0    Posted By: Abhisek Panda   Member Level: Gold   Points/Cash: 40   


It is a simple Library Management System developed using C# as frontend and MS SQL Server2000 as backend. It provides separate view for the user and administrators with good user interface. The administrator can view several reports. For security purpose it uses encryption/decryption.It also maintain inventory.

It has four tables

Lib_User

Field Name Type Length(bytes) Constraint
User_ID int 4 Primary Key
User_Name varchar 120 Not Null
User_Password varchar 120 Not Null
User_Is_System bit 1 Not Null
User_Created_Date datetime 8 Not Null
Number_Of_Books_Issued int 4 Not Null


Lib_Book_Categories

Field Name Type Length(bytes) Constraint
Category_ID int 4 Primary Key
Category_Name varchar 120 Not Null


Lib_Book_Details

Field Name Type Length(bytes) Constraint
Lib_Book_ID int 4 Primary Key
Lib_Book_Title varchar 120 Not Null
Lib_Book_Category int 4 Not Null
Lib_Book_Author_Name varchar 120 Not Null
Lib_Book_Publisher_Name varchar 120 Not Null
Lib_Book_PublisAt_Name varchar 120 Not Null
Lib_Book_YearPubish int 4 Not Null
Lib_Book_Edition int 4 Not Null
Lib_Book_Volume int 4 Not Null
Lib_Book_Page int 4 Not Null
Lib_Book_Price float 8 Not Null
Lib_Book_Issue_Status bit 1 Not Null
Lib_Book_In_Inventory bit 1 Not Null

Lib_Book_Issue_Details

Field Name Type Length(bytes) Constraint
Lib_Book_Issue_ID int 4 Primary Key
Lib_Book_ID int 4 Not Null
Lib_Book_Issued_On datetime 8 Not Null
Lib_Book_Issued_To varchar 120 Not Null
Lib_Book_Returned_On datetime 8 Null


It provides facility to register a new user and login with that password. The user can search a book and issue it to him, return books and change his password.

The administrators has some additional functions such as add/remove book, add category, view reports,etc.

In this project I have included tabbed window which help the user to do multiple tasks in a single window.

The default login name is "admin" and password is "admin" after executing the Library.sql.

You have to first create the database and execute the project, otherwise it will not work.

The source code, screen-shots and database files are below.






Attachments

  • Login (687-7928-Login.bmp)
  • Admin Access (687-7929-Adminacess.bmp)
  • User Access (687-7930-User.bmp)
  • Report (687-7931-BookDetails.bmp)
  • Database (687-7925-library.sql)
  • Database(New) (687-12853-library.sql)
  • Source Code (687-7921-Library Management.zip)
  • Screen Shots (687-7927-Library screenshots.zip)
  • Library.sql Zip File (687-17938-library.zip)

  • Project Feedbacks

    Author: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    Hi Abhi,
    library.sql link is not working . Could you plz send me this project to my email address:
    chotoapa@yahoo.com
    i would appreciate your help.


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi Abhisek Panda, Iam trying to download the database file its not working....

    Can you pls check this and send the file pls....

    My mail id - mailtoamar@aol.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    hi
    i am gani from chennai.your project desidn is good ,plz send database file in my mail id gani_kh@yahoo.co.in
    thanking you


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    its a very nice screen shot please send me the DATA FLOW DIAGRAM OR THE DATA MODELING @ gierald1112@yahoo.com


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi,

    I have tried a lot to download the database file but the links are not working.

    Could you please provide a link.

    Many Thanks

    Rao


    Author: Member Level: SilverRevenue Score: 3 out of 53 out of 53 out of 5
    Hai,

    I have tried a lot to download the database file but the links are not working.Could you please provide a link.And please send me the DATA FLOW DIAGRAM OR THE DATA MODELING in my mail:sudhanthira.l@gmail.com


    Author: Member Level: SilverRevenue Score: 1 out of 5
    why you are using static only..Any Specific Reason you are using static..i cant run your project..pls send my mail..


    Author: Member Level: SilverRevenue Score: 1 out of 5
    i need source code for fine calculation in Library Management System...


    Author: Member Level: BronzeRevenue Score: 2 out of 52 out of 5
    Hi,

    I am unable to download this
    (687-7925-library.sql) please send me this on my id: zeeshansabir@ymail.com

    Thanks in advance
    regards


    Author: Member Level: GoldRevenue Score: 1 out of 5
    Here is the new database file,


    library.sql
    Author: Member Level: GoldRevenue Score: 1 out of 5
    Please check the database file here. In others the download link is not working.


    library.sql
    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    I would like to say sorry for the late feedback. I have contacted webmaster of DNS to correct the problem.

    Here is the database file contents.


    CREATE DATABASE [Library] ON (NAME = N'Library_Data', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\Library_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'Library_Log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL\data\Library_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
    COLLATE SQL_Latin1_General_CP1_CI_AS
    GO
    use [Library]
    GO
    CREATE TABLE [dbo].[Lib_Book_Categories] (
    [Category_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Category_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Users] (
    [User_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [User_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [User_Password] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [User_Is_System] [bit] NOT NULL ,
    [User_Created_Date] [datetime] NOT NULL ,
    [Number_Of_Books_Issued] [int] NOT NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Book_Details] (
    [Lib_Book_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Lib_Book_Title] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Lib_Book_Category] [int] NOT NULL ,
    [Lib_Book_Author_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Lib_Book_Publisher_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Lib_Book_PublisAt_Name] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Lib_Book_YearPubish] [int] NULL ,
    [Lib_Book_Edition] [int] NULL ,
    [Lib_Book_Volume] [int] NULL ,
    [Lib_Book_Page] [int] NULL ,
    [Lib_Book_Price] [float] NULL ,
    [Lib_Book_Issue_Status] [bit] NULL ,
    [Lib_Book_In_Inventory] [bit] NULL
    ) ON [PRIMARY]
    GO
    CREATE TABLE [dbo].[Lib_Book_Issue_Details] (
    [Lib_Book_Issue_ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Lib_Book_ID] [int] NOT NULL ,
    [Lib_Book_Issued_On] [datetime] NOT NULL ,
    [Lib_Book_Issued_To] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [Lib_Book_Returned_On] [datetime] NULL
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Categories] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Categories] PRIMARY KEY CLUSTERED
    (
    [Category_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Users] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Users] PRIMARY KEY CLUSTERED
    (
    [User_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Details] PRIMARY KEY CLUSTERED
    (
    [Lib_Book_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] WITH NOCHECK ADD
    CONSTRAINT [PK_Lib_Book_Issue_Details] PRIMARY KEY CLUSTERED
    (
    [Lib_Book_Issue_ID]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Users] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Users_User_Is_System] DEFAULT (0) FOR [User_Is_System],
    CONSTRAINT [DF_Lib_Users_User_Created_Date] DEFAULT (getdate()) FOR [User_Created_Date],
    CONSTRAINT [DF_Lib_Users_Number_Of_Books_Issued] DEFAULT (0) FOR [Number_Of_Books_Issued],
    CONSTRAINT [IX_Lib_Users] UNIQUE NONCLUSTERED
    (
    [User_Name]
    ) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Book_Details_Lib_Book_Issue_Status] DEFAULT (0) FOR [Lib_Book_Issue_Status],
    CONSTRAINT [DF_Lib_Book_Details_Lib_Book_In_Inventory] DEFAULT (1) FOR [Lib_Book_In_Inventory]
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] WITH NOCHECK ADD
    CONSTRAINT [DF_Lib_Book_Issue_Details_Lb_Book_Issued_On] DEFAULT (getdate()) FOR [Lib_Book_Issued_On]
    GO
    ALTER TABLE [dbo].[Lib_Book_Details] ADD
    CONSTRAINT [FK_Lib_Book_Details_Lib_Book_Categories] FOREIGN KEY
    (
    [Lib_Book_Category]
    ) REFERENCES [dbo].[Lib_Book_Categories] (
    [Category_ID]
    )
    GO
    ALTER TABLE [dbo].[Lib_Book_Issue_Details] ADD
    CONSTRAINT [FK_Lib_Book_Issue_Details_Lib_Book_Details] FOREIGN KEY
    (
    [Lib_Book_ID]
    ) REFERENCES [dbo].[Lib_Book_Details] (
    [Lib_Book_ID]
    ),
    CONSTRAINT [FK_Lib_Book_Issue_Details_Lib_Users] FOREIGN KEY
    (
    [Lib_Book_Issued_To]
    ) REFERENCES [dbo].[Lib_Users] (
    [User_Name]
    )
    GO
    insert into Lib_Users (user_name,user_password,user_is_system)values('admin','YWRtaW4=',1)



    You may need it in future. To run the project first run the above script file in SQL Server 2000. Then in Visual studio IDE run the project. The report section might not work due to change of location. You have to build it again.



    Author: Member Level: GoldRevenue Score: 1 out of 5
    Hi Friends,

    Please download •Library.sql Zip File (687-17938-library.zip) file. It is working.


    Author: Member Level: SilverRevenue Score: 2 out of 52 out of 5
    Hi,

    Please send me this project with full documentation on ankur.arora17@yahoo.co.in.
    I really need this project urgently.
    Your help would be highly appreciable.

    Thanks,

    Ankur


    Author: Member Level: GoldRevenue Score: 1 out of 5
    good project.

    -- Manisha Chaubey


    Author: Member Level: SilverRevenue Score: 1 out of 5
    send me database plz
    smilerathor@gmail.com

    thanks


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,
    Its really nice. I would like learn such type of things.

    It will be greatful for me to send the files.

    Thanks
    Siva Sreenath


    Post Feedback
    You must Sign In to post a feedback.
    Next Project: Training And Placement
    Previous Project: Simple Authentication and registration process for a website through Membership schema

    Return to Project Index

    Post New Project


    Related Projects


    Top Contributors
    Today
      Last 7 Days
        more...

        Awards & Gifts

        Online Members

        jonson stive
        More...
         
        Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India