scenario based sql question

content of structure i assume you are looking for

CREATE TABLE [dbo].[Book](
[Bookid] [int] IDENTITY(1,1) NOT NULL,
[BookName] [varchar](50) NULL,
[BookCategoryId] [int] NULL,
[IsActive] [bit] NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
[Bookid] 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 ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[BookBorrow] Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookBorrow](
[BookBorrowId] [int] IDENTITY(1,1) NOT NULL,
[BookId] [int] NULL,
[StudentId] [int] NULL,
[BorrowDate] [datetime] NULL,
[BookReturn] [bit] NULL CONSTRAINT [DF_BookBorrow_BookReturn] DEFAULT ((0)),
[IsActive] [bit] NULL,
CONSTRAINT [PK_BookBorrow] PRIMARY KEY CLUSTERED
(
[BookBorrowId] 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
/****** Object: Table [dbo].[BookCategory] Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BookCategory](
[BookCategoryId] [int] IDENTITY(1,1) NOT NULL,
[BookCategoryName] [varchar](50) NULL,
[IsActive] [bit] NULL,
CONSTRAINT [PK_BookCategory] PRIMARY KEY CLUSTERED
(
[BookCategoryId] 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 ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Student] Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Student](
[StudentId] [int] IDENTITY(1,1) NOT NULL,
[StudentName] [varchar](50) NULL,
[StudentDescipline] [varchar](50) NULL,
[IsActive] [bit] NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[StudentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Check the ZIP file in the top of the page
Shahriar Nikkhah8y ago
content of structure i assume you are looking for
CREATE TABLE [dbo].[Book](
    [Bookid] [int] IDENTITY(1,1) NOT NULL,
    [BookName] [varchar](50) NULL,
    [BookCategoryId] [int] NULL,
    [IsActive] [bit] NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
    [Bookid] 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 ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[BookBorrow]    Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookBorrow](
    [BookBorrowId] [int] IDENTITY(1,1) NOT NULL,
    [BookId] [int] NULL,
    [StudentId] [int] NULL,
    [BorrowDate] [datetime] NULL,
    [BookReturn] [bit] NULL CONSTRAINT [DF_BookBorrow_BookReturn]  DEFAULT ((0)),
    [IsActive] [bit] NULL,
CONSTRAINT [PK_BookBorrow] PRIMARY KEY CLUSTERED
(
    [BookBorrowId] 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
/****** Object:  Table [dbo].[BookCategory]    Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BookCategory](
    [BookCategoryId] [int] IDENTITY(1,1) NOT NULL,
    [BookCategoryName] [varchar](50) NULL,
    [IsActive] [bit] NULL,
CONSTRAINT [PK_BookCategory] PRIMARY KEY CLUSTERED
(
    [BookCategoryId] 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 ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Student]    Script Date: 2/15/2018 3:59:11 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Student](
    [StudentId] [int] IDENTITY(1,1) NOT NULL,
    [StudentName] [varchar](50) NULL,
    [StudentDescipline] [varchar](50) NULL,
    [IsActive] [bit] NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
    [StudentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Bryian Tan8y ago
You can download it from here https://www.c-sharpcorner.com/UploadFile/BlogImages/02162018044343AM/LibraryMgmt.zip

The download link is above the Introduction header.
Shahriar Nikkhah8y ago
I am just replyig by the names

BookCategory ----> Book (one to many relationship)

Book ----------------> Book Borrow (one to many relationship)

Student ------------> Book Borrow (one to many relationship)

BookCategory ----> Book ------> BookBorrow <------ Student
MAYANK RANJAN8y ago
Hi,

I want to know the contents of the below four tables.
BookCategory

Book

Student

BookBorrow