MyContactBook : Part 2 - Setup database for My Contact Book Application

Steps :
Step - 1 : Create a Database.

Go to Solution Explorer > Right Click on App_Data folder > Add > New item > Select SQL Server Database Under Data > Enter Database name > Add.

Step-2: Create table for Save Contact Information.

Open Database > Right Click on Table > Add New Table > Add Columns > Save > Enter table name > Ok.

In this example, I have used one tables as below
Step-3: Create table for Country

Open Database > Right Click on Table > Add New Table > Add Columns > Save > Enter table name > Ok.

In this example, I have used one tables as below
Step-4: Create table for State

Open Database > Right Click on Table > Add New Table > Add Columns > Save > Enter table name > Ok.

In this example, I have used one tables as below
Complete Database Structure
MyContactBook : Part 2 - Setup database for My Contact Book Application
Posted By :