| Author: Ever green | Member Level: Silver | Revenue Score:  |
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: Amaranath.M | Member Level: Bronze | Revenue Score: |
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: gani | Member Level: Bronze | Revenue Score: |
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: Gerald Natividad | Member Level: Bronze | Revenue Score: |
its a very nice screen shot please send me the DATA FLOW DIAGRAM OR THE DATA MODELING @ gierald1112@yahoo.com
|
| Author: rao mazin | Member Level: Bronze | Revenue Score: |
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: Nisha | Member Level: Silver | Revenue Score: |
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: Nisha | Member Level: Silver | Revenue Score: |
why you are using static only..Any Specific Reason you are using static..i cant run your project..pls send my mail..
|
| Author: Nisha | Member Level: Silver | Revenue Score: |
i need source code for fine calculation in Library Management System...
|
| Author: zeeshan | Member Level: Bronze | Revenue Score: |
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: Abhisek Panda | Member Level: Gold | Revenue Score: |
Here is the new database file,
library.sql |
| Author: Abhisek Panda | Member Level: Gold | Revenue Score: |
Please check the database file here. In others the download link is not working.
library.sql |
| Author: Abhisek Panda | Member Level: Gold | Revenue Score: |
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: Abhisek Panda | Member Level: Gold | Revenue Score: |
Hi Friends,
Please download •Library.sql Zip File (687-17938-library.zip) file. It is working.
|
| Author: Ankur | Member Level: Silver | Revenue Score: |
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: manisha | Member Level: Gold | Revenue Score: |
good project.
-- Manisha Chaubey
|
| Author: rajesh kumar | Member Level: Silver | Revenue Score: |
send me database plz
smilerathor@gmail.com
thanks
|
| Author: siva | Member Level: Gold | Revenue Score: |
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
|