Example database

USE [master]
GO

CREATE DATABASE [Exercise11]
GO

USE [Exercise11]
GO

CREATE TABLE [dbo].[Artist](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](256) NOT NULL,
    CONSTRAINT [PK_Artist] PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[Audio](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [CreatedAt] [datetime2](7) NOT NULL,
    [Title] [nvarchar](256) NOT NULL,
    [GenreId] [INT] NOT NULL,
    [Duration] [INT] NOT NULL,
    [Url] [nvarchar](256) NULL,
    [YEAR] [INT] NULL,
    [ArtistId] [INT] NOT NULL,
    [DeletedAt] [datetime2](7) NULL,
    CONSTRAINT [PK__Audio__3214EC072AFFAF4D] PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[AudioTag](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [AudioId] [INT] NOT NULL,
    [TagId] [INT] NOT NULL,
    PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[Genre](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](256) NOT NULL,
    PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[Tag](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](10) NOT NULL,
    PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[USER](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Username] [nvarchar](50) NOT NULL,
    [PwdHash] [nvarchar](256) NOT NULL,
    [PwdSalt] [nvarchar](256) NOT NULL,
    [FirstName] [nvarchar](256) NOT NULL,
    [LastName] [nvarchar](256) NOT NULL,
    [Email] [nvarchar](256) NOT NULL,
    [Phone] [nvarchar](256) NULL,
    CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

CREATE TABLE [dbo].[UserAudioPermission](
    [Id] [INT] NOT NULL,
    [UserId] [INT] NOT NULL,
    [AudioId] [INT] NOT NULL,
    CONSTRAINT [PK_UserAudioPermission] PRIMARY KEY CLUSTERED
    (
        [Id] ASC
    )
)
GO

SET IDENTITY_INSERT [dbo].[Artist] ON
GO
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (1, N'Tina Turner')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (2, N'Van Halen')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (3, N'DJ Snake')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (4, N'Louis Armstrong')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (5, N'Maroon 5')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (6, N'Sia')
INSERT [dbo].[Artist] ([Id], [Name]) VALUES (7, N'Editors')
SET IDENTITY_INSERT [dbo].[Artist] OFF
GO

SET IDENTITY_INSERT [dbo].[Audio] ON
GO
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (2, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Moves Like Jagger (feat. Christina Aguilera)', 1, 278, N'https://www.youtube.com/watch?v=iEPTlhBmwRg', 2010, 5, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (3, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'The Greatest', 7, 351, N'https://www.youtube.com/watch?v=GKSRyLdjsPA', 2016, 6, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (4, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'All The Kings', 10, 310, N'https://www.youtube.com/watch?v=d2oSgaRb9Bg', 2016, 7, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (8, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'What''s Love Got to Do with It', 3, 226, N'https://www.youtube.com/watch?v=oGpFcHTxjZs', 1984, 1, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (10, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'The Best', 8, 249, N'https://www.youtube.com/watch?v=GC5E8ie2pdM', 1989, 1, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (11, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Jump', 11, 242, N'https://www.youtube.com/watch?v=SwYN7mTi6HM', 1984, 2, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (12, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Lean On', 5, 178, N'https://www.youtube.com/watch?v=YqeW9_5kURI', 2015, 3, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (13, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'What a Wonderful World', 4, 138, N'https://www.youtube.com/watch?v=rBrd_3VMC3c', 1967, 4, NULL)
INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url], [YEAR], [ArtistId], [DeletedAt]) VALUES (14, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'We Have All The Time In The World', 4, 194, N'https://www.youtube.com/watch?v=RMxRDTfzgpU', 1969, 4, NULL)
SET IDENTITY_INSERT [dbo].[Audio] OFF
GO

SET IDENTITY_INSERT [dbo].[AudioTag] ON
GO
INSERT [dbo].[AudioTag] ([Id], [AudioId], [TagId]) VALUES (1, 3, 12)
GO
SET IDENTITY_INSERT [dbo].[AudioTag] OFF
GO

SET IDENTITY_INSERT [dbo].[Genre] ON
GO
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (1, N'Pop')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (2, N'Hip-hop')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (3, N'Rock')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (4, N'Jazz')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (5, N'Dance')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (6, N'Dubstep')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (7, N'Electro')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (8, N'R&B')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (9, N'Country')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (10, N'Indie')
INSERT [dbo].[Genre] ([Id], [Name]) VALUES (11, N'Pop-rock')
GO
SET IDENTITY_INSERT [dbo].[Genre] OFF

SET IDENTITY_INSERT [dbo].[Tag] ON
GO
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (1, N'listening')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (2, N'radio')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (3, N'music')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (4, N'event')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (8, N'beat')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (9, N'producer')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (10, N'art')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (11, N'style')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (12, N'nowplaying')
INSERT [dbo].[Tag] ([Id], [Name]) VALUES (13, N'video')
GO
SET IDENTITY_INSERT [dbo].[Tag] OFF
GO

ALTER TABLE [dbo].[Audio]  WITH CHECK ADD  CONSTRAINT [FK_Audio_Artist] FOREIGN KEY([ArtistId])
REFERENCES [dbo].[Artist] ([Id])
GO
ALTER TABLE [dbo].[Audio] CHECK CONSTRAINT [FK_Audio_Artist]
GO
ALTER TABLE [dbo].[Audio]  WITH CHECK ADD  CONSTRAINT [FK_Audio_Genre] FOREIGN KEY([GenreId])
REFERENCES [dbo].[Genre] ([Id])
GO
ALTER TABLE [dbo].[Audio] CHECK CONSTRAINT [FK_Audio_Genre]
GO
ALTER TABLE [dbo].[AudioTag]  WITH CHECK ADD  CONSTRAINT [FK_AudioTag_Audio] FOREIGN KEY([AudioId])
REFERENCES [dbo].[Audio] ([Id])
GO
ALTER TABLE [dbo].[AudioTag] CHECK CONSTRAINT [FK_AudioTag_Audio]
GO
ALTER TABLE [dbo].[AudioTag]  WITH CHECK ADD  CONSTRAINT [FK_AudioTag_Tag] FOREIGN KEY([TagId])
REFERENCES [dbo].[Tag] ([Id])
GO
ALTER TABLE [dbo].[AudioTag] CHECK CONSTRAINT [FK_AudioTag_Tag]
GO
ALTER TABLE [dbo].[UserAudioPermission]  WITH CHECK ADD  CONSTRAINT [FK_UserAudioPermission_Audio] FOREIGN KEY([AudioId])
REFERENCES [dbo].[Audio] ([Id])
GO
ALTER TABLE [dbo].[UserAudioPermission] CHECK CONSTRAINT [FK_UserAudioPermission_Audio]
GO
ALTER TABLE [dbo].[UserAudioPermission]  WITH CHECK ADD  CONSTRAINT [FK_UserAudioPermission_User] FOREIGN KEY([UserId])
REFERENCES [dbo].[USER] ([Id])
GO
ALTER TABLE [dbo].[UserAudioPermission] CHECK CONSTRAINT [FK_UserAudioPermission_User]
GO