Song Table

On the other hand, song table needs more attributes to store Id, title, singer, writer, year created and corresponding genre.

Therefore, our SQL code for song table shown below.

CREATE TABLE Song
(
    Id int Primary Key NOT NULL IDENTITY(1,1),
    Title nvarchar(50) NOT NULL,
    Singer nvarchar(50)NOT NULL,
    Writer nvarchar(50)NOT NULL,
    Year nvarchar (4) NOT NULL,
    GenreId int NOT NULL
)

Actually, it shares the same attributes and data types with Genre table.