CREATE TABLE [dbo].[Authors] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (MAX) NULL,
CONSTRAINT [PK_Authors] PRIMARY KEY CLUSTERED ([Id] ASC)
CREATE TABLE [dbo].[Books] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Category] NVARCHAR (MAX) NULL,
[Title] NVARCHAR (MAX) NULL,
CONSTRAINT [PK_Books] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [FK_Books_Authors_AuthorId] FOREIGN KEY ([AuthorId]) REFERENCES [dbo].[Authors] ([Id]) ON DELETE CASCADE