Question No. 1 Perform all the following Steps and take Screen Shots of each step and add to the Answer Sheet.

1. Create an ASP.Net Web Site of your own Name and RegNo, For example TAYYABMEHMOOD17ARID1585. Add Screen Shot of this step to your Answer Sheet.
2. Create a database on your own named, For example eShoppingTayyab. Add Screen Shot of this step to your Answer Sheet.
3. Create Three Tables named tblItemsCategory, ItemsScubCategory, tblItemDetails. The Structure of the tables are as follow'

(Note: Kindly change item names in data base according to your choice)

tblItemsCategory Allow Nulls DESKTOP-E3H3DJ2\S...o.tblltemCategory* x Column Name Data Type ItemCategorySID int Category Title varchar(50) Sample Data is DESKTOP-E3H3DJ2\S...o.tblltemCategory X ItemCategory... Category Title Softwares 2 Hardwares 3 Stationary 1 ItemsScubCategory Allow Nulls DESKTOP-E3H3DJ2\...temsScubCategory X Column Name Data Type ItemSubCatSID int SubCatTitle varchar(50) ItemCatSID int Sample Data DESKTOP-E3H3DJ2\...temsScubCategory X ItemSubCatSID SubCatTitle ItemCatSID 1 Operating Systems 1 2 Laptops 2 3 CPUs 2 4 Books 3 5 Printers 2 6 Scanners 2 Allow Nulls tblItem Deta DESKTOP-E3H3DJ2\S...bo.tblltemDetails x ils Column Name Data Type ItemSID int Item Name varchar(50) ItemPrice float SubCatSID int UK Sample Data SubCatSID 1 N 1 2 2 DESKTOP-E3H3DJ2\s...bo.tblltemDetails X ItemSID ItemName ItemPrice 1 MS Windows 8 5000 Linux 4300 3 HP Laptop 25000 4 Dell Laptop 20000 5 OOP By Dr. Asif... 250 6 Algorithm Anal... 600 7 Visual Program... 2300 8 Software Engin... 400 9 Dell Printer 56000 10 HP Printer N34 20000 4 4 4 4 5 5 5 From Your SQL Server Take and Add Screen Shot of this step to your Answer Sheet