scenario based sql question

Question

Hi, I was just reading SQL scenario based question from this link ( https://www.c-sharpcorner.com/blogs/a-scenario-based-sql-interview-queries-test-modeltraining) I want information about "relationship between tables". I cannot find in this link. Can you share me?

Bryian Tan · Answer

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 Nikkhah · Answer

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

MAYANK RANJAN · Answer

Hi, I want to know the contents of the below four tables. BookCategory Book Student BookBorrow

Shahriar Nikkhah · Answer

Check the ZIP file in the top of the page

Shahriar Nikkhah · Answer

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 ]