Contact at mumbai.academics@gmail.com or 8097636691
Responsive Ads Here

Friday, 30 March 2018

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.
NameData typeKeyConstraints
Usernamevarchar(20)Primary keyNot Null
Passwordvarchar(20)Not Null
MEMBER: This entity store the information of new member.
NameData typeKeyConstraints
First namevarchar(20)Not Null
Last namevarchar(20)Not Null
AddressVarchar(100)Not Null
Cityvarchar(20)Not Null
Countryvarchar(20)Not Null
Contact No.numeric
Emailvarchar(40)Primary Key
Passwordvarchar(20)Not Null

Product Category: This entity store information of products category like mobile, computer, electronic items etc.
NameData typeKeyConstraints
Category_IdintPrimary Key
Category Namevarchar(20)Not Null

Product Item:
 This entity store the information of product items.
NameData typeKeyConstraints
Product_IdintPrimary key
Category_IdintForeign Key
Product Namevarchar(20)Not Null
RatenumericNot Null
UnitnumericNot Null
Opening StocknumericNot Null
Product_trans: This entity store the information of product transition.
NameData typeKeyConstraints
Invoice NointPrimary key
Member_IdintForeign
Product_IdintForeign
Trans_DateintNot null
QtyNumericNot null
AmountNumericNot null
DiscountNumericNot null
Net _amountNumericNot null
Trans_ModeNumericNot null

Product Supplier:
 This entity store the information of product Supplier.
NameData typeKeyConstraints
Supplier_idintPrimary key
Product_idintForeign key
Purchase_DateDateNot null
QtyNumericNot null
Total amountNumericNot null
DiscountNumeric
Net AmountNumericNot null
Payment modeintNot null

No comments:

Post a Comment