
/****** Object:  Table [dbo].[Category]    Script Date: 10/20/2010 11:12:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
	[CatID] [int] IDENTITY(1,1) NOT NULL,
	[CategoryName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED 
(
	[CatID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Category] ON
INSERT [dbo].[Category] ([CatID], [CategoryName]) VALUES (1, N'Programming')
INSERT [dbo].[Category] ([CatID], [CategoryName]) VALUES (2, N'Design')
INSERT [dbo].[Category] ([CatID], [CategoryName]) VALUES (3, N'Network')
SET IDENTITY_INSERT [dbo].[Category] OFF
/****** Object:  Table [dbo].[Books]    Script Date: 10/20/2010 11:12:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Books](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[BookName] [nvarchar](50) NULL,
	[CatID] [int] NULL,
 CONSTRAINT [PK_Books] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Books] ON
INSERT [dbo].[Books] ([ID], [BookName], [CatID]) VALUES (1, N'book1', 1)
INSERT [dbo].[Books] ([ID], [BookName], [CatID]) VALUES (2, N'book2', 2)
INSERT [dbo].[Books] ([ID], [BookName], [CatID]) VALUES (3, N'book3', 3)
INSERT [dbo].[Books] ([ID], [BookName], [CatID]) VALUES (4, N'Book4', 1)
INSERT [dbo].[Books] ([ID], [BookName], [CatID]) VALUES (7, N'Book5', 2)
SET IDENTITY_INSERT [dbo].[Books] OFF
/****** Object:  ForeignKey [FK_Books_Category]    Script Date: 10/20/2010 11:12:27 ******/
ALTER TABLE [dbo].[Books]  WITH CHECK ADD  CONSTRAINT [FK_Books_Category] FOREIGN KEY([CatID])
REFERENCES [dbo].[Category] ([CatID])
GO
ALTER TABLE [dbo].[Books] CHECK CONSTRAINT [FK_Books_Category]
GO
