Creating a Database

In this tutorial, we will create a database using SQL Server Management Studio. In PlaylistStore, basically, we need 2 tables in our database, Genre and Song.

Genre table refers to stored available list of genre. Song table collects list of song title, singer, writer, year created and genre.

Moreover, we will link the tables together and set a selected column as Primary Key and Foreign Key.