Online Computer Store .Net Project

INTRODUCTION

The project entitled “ONLINE COMPUTER STORE” is a web-based application software developed in ASP.Net using C# as front end and SQL Server as a backend.

Client Server Technology

Client/ Server with RDBMS and Web-Based Application

The proposed Online Computer Store system comes under Client/ Server with RDBMS category, as there is need to manipulate the transaction online network based for multi-user and faster and the quires output in quick successive time and also the highly secured. This Online Computer Store project is categorized as Relational Database Management System (RDBMS) which is base on client-server architecture. In client Server architecture the interface for use is created in any programming language (Front-end) and the database where data is stored is called back end. The user interface is treated as a client to which user request for data and user interface sends the user request to the server as database and the server returns the data required by the client program manipulation.

SYSTEM REQUIREMENT

(A) Hardware Requirement-

• PROCESSORS: Pentium 4/Celeron/Dual Core/ Core 2 Duo/Core i 3 /Core i 5
• RAM :1 GB/2 GB/4 GB
• CD/DVD DRIVE
• HDD:40 GB /80 GB/160 GB
• MONITOR :16 “ SVGA
• POINTING/OPTICAL DEVICES: (MOUSE), ONE MICROSOFT NATURAL PS2 KEY BOARD

SYSTEM REQUIREMENT

(B) Software Requirement-

Internet Technology:
Front End
 ASP.Net
RDBMS/BACK END: MICROSOFT ACCESS 2003
Language: C#
Scripting Language: Java Script.
Web Server: IIS(Internet Information Server)
Operating Systems: Windows 7, Windows XP sp2, sp3, Windows 2000 server, Windows server 2003
Application: Web-Based Application

MODULES

Basically, there are four modules. They are as follows-

1. Admin
2. Customer
3. Support
4. Report generation

1. ADMIN- An ‘ADMIN’ is a person who manages all the deeds related to the product. For instance-
• Product creation
• Change price list
• Set discount & offers
• Check the minimum level of product
• Daily sale/purchase report

2. PRODUCT ENTRY- A ‘CUSTOMER’ is a person who visits on the site, make his account, login to the site and then take services given by the providers of the site. For instance-
• New registration
• Login for existing member
• Paid a sales invoice
• Product delivery report

3. PRODUCT PURCHASE- The ‘SUPPORT’ is an area where consumers can give their views and advices related to the product. For instance-
• Customer feedback entry
• Solution of feedback
• Product query.

4. USER LOGIN- The ‘REPORT GENERATION’ module defines all the information related to the project. For instance-
• Customer status report
• Supplier status report
• Product status report

 

DATABASE DESIGN

Admin: This entity store Username and password of the administrator.

Name	Data type	Key	Constraints
Username	varchar(20)	Primary key	Not Null
Password	varchar(20)		Not Null

MEMBER: This entity store the information of new member.

Name	Data type	Key	Constraints
First name	varchar(20)		Not Null
Last name	varchar(20)		Not Null
Address	Varchar(100)		Not Null
City	varchar(20)		Not Null
Country	varchar(20)		Not Null
Contact No.	numeric
Email	varchar(40)	Primary Key
Password	varchar(20)		Not Null

 

Product Category: This entity store information of products category like mobile, computer, electronic items etc.

Name	Data type	Key	Constraints
Category_Id	int	Primary Key
Category Name	varchar(20)		Not Null

Product Item: This entity store the information of product items.

Name	Data type	Key	Constraints
Product_Id	int	Primary key
Category_Id	int	Foreign Key
Product Name	varchar(20)		Not Null
Rate	numeric		Not Null
Unit	numeric		Not Null
Opening Stock	numeric		Not Null

Product_trans: This entity store the information of product transition.

Name	Data type	Key	Constraints
Invoice No	int	Primary key
Member_Id	int	Foreign
Product_Id	int	Foreign
Trans_Date	int		Not null
Qty	Numeric		Not null
Amount	Numeric		Not null
Discount	Numeric		Not null
Net _amount	Numeric		Not null
Trans_Mode	Numeric		Not null

Product Supplier: This entity store the information of product Supplier.

Name	Data type	Key	Constraints
Supplier_id	int	Primary key
Product_id	int	Foreign key
Purchase_Date	Date		Not null
Qty	Numeric		Not null
Total amount	Numeric		Not null
Discount	Numeric
Net Amount	Numeric		Not null
Payment mode	int		Not null