Design and Development of an Online Store using .Net Framework and SQL Server Database

INTERNET SYSTEM
DEVELOPMENT

Table of Contents
1. Introduction.......................................................................................................................................2
2. Product Description...........................................................................................................................2
3. Design and Development...................................................................................................................2
4. Implementation..................................................................................................................................4
4.1 Data dictionary..........................................................................................................................4
4.2 Output Screenshots....................................................................................................................6
5. Testing..............................................................................................................................................15
6. Conclusion........................................................................................................................................16
References................................................................................................................................................16
Appendix 1...............................................................................................................................................17
Appendix 2...............................................................................................................................................19
1

1. Introduction
The main objective of the project is to design and develop an online store using .Net
framework and SQL server database. In this report we will discuss about product description, the
design patter and implementation technologies will be discussed in detail. The testing and
debugging of this project will be provided.
2. Product Description
An online shop is a virtual store on the web where clients can examine the rundown and
pick results of interest. The picked things may be amassed in a purchasing crate (Vezir OĞUZ,
2018). At checkout time, the issues in the acquiring crate might be included as a demand. Round
at that point, more records could be anticipated to finish the substitute. Ordinarily, the buyer
could be requested to fill or pick a charging address, a transportation adapt to, and transport
option, and portion records, for instance, Visa number. An email see is sent to the client while
the demand is about (Alsharief, 2017).
3. Design and Development
Title of the Project: - Online Shopping
Project Description: - The user can purchase any item an on line store is
available for The user 24 hours. Many shopping website
are available in market, it save lots of time which other
people west in shopping at places like mall shopping
street in market and other places. In this technical
everything is getting on line education, on line banking
etc., so why not shopping.
Platform: - Front-end:- ASP.NET[C#]
Back-end:- SQL
Hardware Requirement:
-
Minimum: - 512 MB RAM
80 GB Hard-Disk
2

Pentium-4 or equivalent Processor
Software Requirement: - Visual Studio – 2012
SQL Server – 2012
Figure 1 Architecture of Project development
In this project, the client is provided with a web business endeavor website page that
might be connected to buy books on the net. To execute this as a web utility we connected
ASP.net in light of the fact that the
Advancement (Frederick, 2011). ASP.net has a few purposes of enthusiasm, for instance,
updated execution, adaptability, worked in assurance and ease. MySQL wind up used as back-
quit database since it's miles a champion among the greatest surely understood open supply
databases, and it gives brief insights get to, simple set up request and ease.
A better than average buying crate arrangement must be ran with smooth to catch
shopping lot programming method of reasoning. It should be useful for the buyer to look the
substance in their truck and to can possibly clear or add things to their truck (Kim and Martinez,
2012). The purchasing container utility delineated on this wander offers various features that are
expected to make the customer more noteworthy pleasing.
3

4. Implementation
The main objective of this activity is to collect an online standby. On the moment that the
buyer sorts inside the URL of the store in adapt to field of this framework, a web Server is come
to get the asked for measurements. In the .net Framework, IIS is going roughly as the net Server.
The web server is doing the process of getting the HTTP request and taking the request and to
reestablish the request into a HTTP response. The main component is IIS (Internet Information
System) and it helps to provide accessing authority to the HTTP request. So that the request
message will be sent to Web server. So this approach is essential for adapt to the request and
proceed further responses. The webserver takes the decision for all the HTTP requests given by
client. The decision is based on the development of the requested lookup. Firstly the web server
looks up the list. If the request is present in its history it will send the immediate response.
Otherwise, it will search and provide the information asked by the client.
4.1 Data dictionary
Order table
Column Name Data type Allow nulls Description
Serial no. numeric No Primary key
Amount numeric No Amount of order
Username varchar No Fk(user.username)
Reviews
Column Name Data type Allow nulls Description
Revieweid varchar No Primary key
review varchar No Product review
Username varchar No Fk(user.username)
Productid numeric No Fk(product.productid)
Product_category
Column Name Data type Allow nulls Description
4

Productid numeric No Primary key
Productname varchar No Product name
Productdescription varchar No Product description
Productshortdescription varchar No Product short
description
Price numeric No Price
Category varchar No Category
Productiamage varchar No Product image
Productiamagethumb varchar No Product image thumb
Product_category
Column Name Data type Allow nulls Description
Categoryid numeric No Primary key
Category varchar No Product category
Shopping_cart
Column Name Data type Allow nulls Description
Shopingid numeric No Primary key
Productno numeric No Product no
Userid numeric No Fk(user.username)
Salesstatus varchar No Sales status
Qty numeric No Quantity
User_table
Column Name Data type Allow nulls Description
Id numeric No Primary key
Username varchar No Username
Password varchar No Password
Emailid varchar No Email id
5