Report 2
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Report 2 as PDF for free.
More details
- Words: 4,992
- Pages: 39
A Report On
Subject
ONLINE SHOPPING DEGREE: Bachelor of Engineering In Computer Engineering
Submitted To:
Submitted By:
Ms. Neelam
Renuka Saini(91)
VIII Sem. MajorProject Coordinator
Richa Kumbhat(92)
(Lecturer CE)
Computer Engineering IV B.E. DEPARTMENT OF COMPUTER ENGINEERING
JAIPUR ENGINEERING COLLEGE & RESEARCH CENTER UNIVERSITY OF RAJASTHAN 2007-2008
CONTENTS
ACKNOWLEDGEMENT ABSTRACT REQUIREMENTS SOFTWARE REQUIREMENT SPECIFICATION(SRS) Note--- you have to add screenshorts in your project report by am rita sarasw at. TECHNOLOGIES USED FEASIBILITY STUDY PROJECT DESCRIPTION •
ERD
•
DATABASE DESIGN
•
SCREEN SHOTS
FUTURE ENHANCEMENTS CONCLUSION REFERENCES BIBLIOGRAPHY
ACKNOWLEDGEMENT It is our pleasure to present a dissertation which owes its existence to numerous people. At the ver y outset, we have a word of ardent appreciation for the faculty of COMPUTER SCIENCE, JECRC for their faith to undertake the training in project. We express deep sense of gratitude to Ms. Neelam, faculty guide at COMPUTER SCIENCE, JECRC for being our mentor and giving his valuable suggestions, guidance and encouragement without which the completion of this project would have been a dream. Lastly, I extend my hearty thanks to all those who have contributed in making this project a success.
RENUKA SAINI RICHA KUMBHAT
ABSTRACT Whether you're buying direct from a business or an individual, an online “retailer” or an Internet auction, shopping online can be fun, easy, practical, and economical. But, just as in the bricks and mortar world, the Internet shopping experience can be marred with unscrupulous dealers constantly devising new ways to deceive consumers out of their money. This site offers information to help you shop safely and wisely online. You can learn, for example, how to use online payment services, participate in an Internet auction or resolve a complaint with an online dealer. If you're a seller, you can learn about the rules for online advertising, timely deliveries and other business-related matters. All storefront solutions include a shopping cart; this is the component of our store that allows the customer to select the items they want to purchase. It’s the most important aspect of our online store. Another most important fact is that many customers on the internet will expect the customer service you offer online to match or exceed that which you offer in the real world. Through this site not only the consumers on the internet feel empowered in a way that has not existed offline, but they actually have been empowered. You can almost instantly compare your prices and services with that of the other organizations. You can quickly find out if your previous customer is satisfied with your company. You can also post your complaints online if at any time you are unsatisfied with our site. In short, we have shifted the power of the buyer-seller relationship in the hands of the buyer. You cannot afford to slip up when it comes to your online
store. Excellence in execution and deliver y is a must. That is why one of the most important that you can do is just visit our website and feel free and convenient to shop for anything you feel. This site allows you to surf through the complete site and then you can shop for any products under your range. The look of our store is vital when you are operating in an environment as competitive as the internet. Customers will often make a decision about whether to enter an online store based on the look of its front page. This ever ything else including the images you can only find on our website. These all features are supported by our website. We have included all the important aspects which one thinks of in an online shopping. It has been said that it is just as eas y to lose the customers on the web as is to attract them. This means that setting up a store on internet involves far more than just creating an attractive website to sell your products.
SOFTWARE REQUIREMENTS SPECIFICATIONS DOCUMENT GROUP MEMBERS: RENUKA SAINI (B1CS912008) RICHA KUMBHAT (B1CS922008)
Introduction :This document provides details about the entire software requirements specification for the software ONLINE-SHOPPING an Online Shopping Centre. This site offers information to help you shop safely and wisely online. You can learn, for example, how to use online payment services, participate in an Internet auction or resolve a complaint with an online dealer. All storefront solutions include a shopping cart; this is the component of our store that allows the customer to select the items they want to purchase. It’s the most important aspect of our online store. Another most important fact is that many customers on the internet will expect the customer service you offer online to match or exceed that which you offer in the real world. Through this site not only the consumers on the internet feel empowered in a way that has not existed offline, but they actually have been empowered. You can almost instantly compare your prices and services with that of the other organizations. You can quickly find out if your previous customer is satisfied with your company. You can also post your complaints online if at any time you are unsatisfied with our site.
Purpose :The purpose of this project is to provide eas y shopping facility online and getting the products to the doorsteps of provided categories. We have shifted the power of the buyer-seller relationship in the hands of the bu yer. You cannot afford to slip up when it comes to your online store. Excellence in execution and deliver y is a must. That is why one of the most important that you can do is just visit our website and feel free and convenient to shop for anything you feel. This site allows you to surf through the complete site and then you can shop for any products under your range.
Scope :The name of the project is ONLINE- SHOPPING The software provides the customer with his unique Order ID number. The software provides the following facilities to the customers: •
Facilitates eas y shopping online any where with minimal shipping (conditions apply)
•
Provides information about the products in categories
•
Can reserve or order if the particular product is not available
•
Customers are provided with up to date information on the products available
•
Provides feedback form facility for future correspondence
•
Provides backup facility
•
Reserve the product for the customer till the time he/she doesn’t completes his transaction.
The software will not provide the following facilities to the customers: •
No banking facility available.
•
Responsibility of damages.
•
The product cannot be changeable after 7 days from the date of payment.
The objective of this software is to provide eas y assistance both to the administrator and customer with proper database and information.
Definitions, Acronyms and Abbreviations :1. Customer
: The person who purchases the product
2. Admin
: The person/company manager who deals with the
database and products. 3. Order
ID
Number
:
The
unique
id
given
to
each
customer
who access the data in the site. 4. Product
: The products available on our website.
Overview :The following subsections provide the complete overview of the software specifications
requirements
documentation
for
the
product
ONLINE-
SHOPPING The entire SRS is documented in view of both customers and the administrator and the following sub sections are arranged to give a complete outlook of the software, its perspective, features, system requirements and users know how.
Product perspective:This software is totally self contained and works relatively as efficient as other packages related to the subject. It provides simple database rather than
complex ones for high requirements and it provides good and easy graphical user interface to both new, naïve as well as experienced users of the computers.
System Interfaces:Interface: The software provides good graphical interface for the front end of the database and a good informative interface for the rear end User Interface: The first interface the user will encounter is the Home page on the Online Shopping website. From here the user can search any product or sign in for bu ying a product by clicking on Sign-in. The user can move to the following web pages: 1. Sign-in 2. Registration 3. My Account 4. Forget Password 5. Shopping Cart 6. Final Order 7. Payment Details 8. About us 9. Terms and condition 10. Shopping Demo 11. Contact us Hardw are Interface:The system should have these hardware requirements:
•
The processor should be at least Pentium 4 or above.
•
The processor speed should be greater than 456 MHz.
•
RAM should be or greater than 256 MB.
Software Interfaces:The software requires the support of the following software’s for the database and other requirements •
IIS should be installed on the machine of the server.
•
ASP.Net for web interface.
•
SQL Server 2005 for database.
•
Server (windows 2000 or above…)
Operations :The operations required by the users are : Customers : 1. Window shopping 2. Creates accounts/ Register him 3. Shopping 4. Add products to their shopping cart 5. Buy products 6. Provide feedback Website Administrator : 1. Update information 2. Add Products 3. Delete Products 4. Honest transactions 5. Replies to the feedback
Product functions :The following use case diagram provides complete information regarding how the software works
register
business info
login with email customer
administrator search item
search by category
Update database create user preference
product database check order status
accounts regarding products Places order
calculate total
query
customer's data for correspondence
Complete use case diagram of the product functionality
•
Hom e page The home page works as the site map for the whole software.
•
Login Introduction and Purpose The login Function allows the users to access the web based facilities and information.
software
User types their username i.e. the email id and the password in the provided textboxes and then click on the sign in button and then is able to access the different the functionalities from the home page. If the details provided by the user do not match with the database, error message is displayed and he has to refill the information. •
Logout Introduction and Purpose The logout function allows the user to safely end the session on the web based software. The user has to click on the logout button active on the web pages which is visible after signing-in in their accounts.
•
Creating New Account Introduction and Purpose The login Function allows the users to gain membership to access the web based software facilities and information. The user clicks on the Register button on the sign-in page. Within the indicated text input fields of the registration page the user has to fill the following personal details: 1. Mailing Address (to be used as username) 2. Account Password and Confirm Password 3. First name and Last name 4. Address Details 5. Phone and Mobile number 6. City 7. State 8. Countr y 9. Pin code and other details….
The user after filling all the required information he/she has to accept the Terms and Conditions of the website and then submit his registration form. If all the details are valid provided by the user, he/she becomes a registered user on our website and now can access the web based software facilities and information. •
Forget Password Introduction and Purpose If a registered user forgets the account password with which he signsin, he can click on the Forget Password button on the Sign-in page. The User is then directed to a new Forget Password Page where he is asked to fill certain details which are matched with the existing details of the user from the database. If these details match the user is allowed to change the account password. The same facility is also provided on the My Account Page.
•
Search Product Introduction and Purpose Any customer visiting our web based software is allowed to search according to his choice. The web based software is provided with three kinds of searches: 1. Simple Search 2. Company Search 3. Price Search
•
Shopping Cart Introduction and Purpose Only the registered users are allowed to access this facility. The user can add the products according to his/her choice in the shopping cart. For buying a product the users have to add the product in the shopping cart as it is the shopping procedure. To finalize his order the user clicks
on the order button. Even after adding a product in the cart he can remove it from the cart by clicking on the remove button. •
Place Order Introduction and Purpose When the user clicks on the order button from the shopping cart page, this page displays the final order of the user showing the total amount and the total number of products. Even at this stage the user is allowed to make changes in the shopping cart.
•
Payments Introduction and Purpose This web page tells the user the various modes of payment available. There are two modes of payment: 1. Through Cheque 2. Through Demand Draft
•
Billing Details Introduction and Purpose This page displays the shipping details of the user he filled at the time of registration. At this point if he wants to change the shipping details he can click on the change now button where he is directed to the edit page. After checking the details he can now place his order by clicking on the order now button.
•
Transaction Complete Introduction and Purpose This is the last step of the product buying cycle. Here the customer gets
the
final
correspondence. .
Order
ID
Number
which
he
can
use
for
future
•
My Account Introduction and Purpose Through this web page the registered users can access their personal account. Here users are provided with four functionalities: 1. Shopping Cart: If the user under some conditions left his shopping incomplete and has just added items to his shopping cart he can view his cart here at any point of time. 2. Password:
This
is
same
change
as
the
Forget
Password
functionality.
3. Edit Information: Here the user can make changes to the information he provided at the time of registration. 4. Order Details: Here the user can view the order by placing the Order ID Number provided to him. He can also look for the Payment and Delivery related details.
•
Contact Us Introduction and Purpose If the user wants to contact us for his queries, this page details our address.This page is also provided with Feedback: This is a function which provides feedback functionality to the user where he/she can quer y about the products, payment, or if he/she has faced any problem during the transaction process. He/She can even provide us with any suggestions related to the web based software
•
About us Introduction and Purpose It gives a brief introduction about what our website is all about, our
parent company Pantaloon and the different promises that our website makes with the customer and how it fulfills them. •
Shopping Dem o Introduction and Purpose This is a complete guide to the user for how he/she can buy a product from our web based software if he’s new to our website. The shopping consists of four stages: 1. Searching the product 2. Registering 3. Adding products to shopping cart 4. Payment and Delivery
•
Term s and Conditions Introduction and Purpose It tells about the terms and conditions governing the use of the site. The user is requested to not to use the site or transact on the site if he/she do not agree with any of the terms and conditions provided below.
Account and Registration Obligations Pricing Information Cancellations by the customer Electronic Communications Governing Law and Jurisdiction Cop yright & Trademark
Site Security Agreement •
Admin Introduction and Purpose The Admin is the main managing authority of the web based software. The Admin is the sole authority controlling the Database. He is provided with the following functionalities: 1. Add product Through this functionality the Admin add new products to the web based software. 2. Delete Product Through this functionality the Admin can delete the existing
product
from the database of web based software. 3. Reply Feedback From here the Admin replies to the different user queries. 4. Payment control Through this the Admin manages the entire information related to the payment (Cheque, DD) and deliver y details.
User characteristics :•
No pre knowledge of database management
•
Should be familiar with internet
•
Should know English.
•
Should be able to use and do according to the graphical user interface
Assumptions and Dependencies: •
User will know how to use mouse and keyboard
•
User will know how to use a web-browser.
The following is a list of occurrences that could change the requirements of the project in future: •
Large number of “hits” to the site.
•
Demand exceeding Product supply
•
More extensive product line
Performance Requirements :Performance requirements are : 1. Good working pc with all the requirements as stated in the hardware interfaces 2. Works for medium size information databases 3. Should not be overloaded
Future Developments :•
Banking Facilities
•
Support for large database
•
Oracle for database
TECHNOLOGIES USED
The Microsoft .NET Fram ework The .NET Framework is the infrastructure for the Microsoft .NET platform. The .NET Framework is an environment for building, deploying, and running Web applications and Web Services. Microsoft's first server technology ASP (Active Server Pages) was a powerful and flexible "programming language". But it was too much code oriented. It was not an application framework and not an enterprise development tool. The Microsoft .NET Framework was developed to solve this problem. .NET Frameworks keywords: •
Easier and quicker programming
•
Reduced amount of code
•
Declarative programming model
•
Richer server control hierarchy with events
•
Larger class library
•
Better support for development tools
The .NET Framework consists of 3 main parts: Programming languages: •
C# (Pronounced C sharp)
•
Visual Basic (VB .NET)
•
J# (Pronounced J sharp)
Server technologies and client technologies: •
ASP .NET (Active Server Pages)
•
Windows Forms (Windows desktop solutions)
•
Compact Framework (PDA / Mobile solutions)
Developm ent environm ents: •
Visual Studio .NET (VS .NET)
•
Visual Web Developer
ASP.NET What is ASP.NET? ASP.NET is a server side scripting technology that enables scripts (embedded in web pages) to be executed by an Internet server. •
ASP.NET is a Microsoft Technology
•
ASP stands for Active Server Pages
•
ASP.NET is a program that runs ins ide IIS
•
IIS (Internet Information Services) is Microsoft's Internet server
•
IIS comes as a free component with W indows servers
•
IIS is also a part of W indows 2000 and XP Professional
An ASP.NET file is just the same as an HT ML file . It can contain HT ML, XML, and scripts . Scripts in an ASP.NET file are exec uted on the server. An ASP.NET file has the file extens ion ".aspx"
How Does ASP.NET Work? •
When a browser requests an HTML file, the server returns the file
•
When a browser requests an ASP.NET file, IIS passes the request to the ASP.NET engine on the server
•
The ASP.NET engine reads the file, line by line, and executes the scripts in the file
•
Finally, the ASP.NET file is returned to the browser as plain HTML
ASP.NET has better language support, a large set of new controls and XML based components, and better user authentication. ASP.NET provides increased performance by running compiled code. ASP.NET code is not fully bac kw ard co mpatible with ASP.
New in ASP.NET
Better language support
Event-driven programming
XML-based components
Higher scalability
Increased performance - Compiled code
Easier configuration and deployment
Not fully ASP compatible
Language Support ASP.NET uses the new ADO.NET. ASP.NET supports full Visual Basic, not VBScript. ASP.NET supports C# (C sharp) and C++. ASP.NET supports JScript as before. Event Aw are Controls All ASP.NET objects on a Web page can expose events that can be processed b y ASP.NET code.Load, Click and Change events handled by
code makes coding much simpler and much better organized. ASP.NET Components ASP.NET components are heavily based on XML. Like the new AD Rotator, that uses XML to store advertisement information and configuration. User Authentication ASP.NET
supports
forms-based
user
authentication,
including
cookie
management and automatic redirecting of unauthorized logins.(You can still do your custom login page and custom user checking). High Scalability Much has been done with ASP.NET to provide greater scalability.Server to server communication has been greatly enhanced, making it possible to scale an application over several servers. One example of this is the ability to run XML parsers, XSL transformations and even resource hungry session objects on other servers. Compiled Code The first request for an ASP.NET page on the server will compile the ASP.NET code and keep a cached copy in memor y. The result of this is greatly increased performance. Easy Deployment No more server restart to deploy or replace compiled code. ASP.NET simply redirects all new requests to the new code.
Compatibility
ASP.NET is not fully compatible with earlier versions of ASP, so most of the old ASP code will need some changes to run under ASP.NET.
SQL SERVER 2005 SQL is a standard computer language for accessing and manipulating databases. SQL stands for Structured Query Language. SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database s ystems. SQL statements are used to retrieve and update data in the database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. SQL Database Tables most often contains one or more tables. Each table is identified by a name. With SQL, we can query a database and have a result set returned. SQL Data Manipulation Language (DML) SQL is syntax for executing queries. But the SQL language also includes syntax to update, insert, and delete records. These quer y and update commands together form the Data Manipulation Language (DML) part of SQL. The most important DML statements in SQL are: SELECT
extracts data from a database table
UPDATE
updates data in a database table
DELETE
deletes rows from a database table
INSERT INTO
inserts new data into a database table
TRUNCATE
deletes all the rows from a database table
SQL Data Definition Language (DDL) The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also
define
indexes
(keys),
specify
links
between
tables,
and
impose
constraints between database tables. The most important DDL statements in SQL are: CREATE TABLE
creates a new database table
ALTER TABLE
alters (changes) a database table
DROP TABLE
deletes a database table
CREATE INDEX
creates an index(search key)
DROP INDEX
deletes an index
The result from a SQL quer y is stored in a result–set. Most database software s ystems
the result-set with
programming
functions, like: Move–To–First-Record, Get–Record-Contents,
Move-To-
Next-Record, etc.
allow
navigation
of
REQUIREMENTS
INTERFACE REQUIRED PLATFORM USED: WIN 2000 OR HIGHER VERSION
LANGUAGE USED: ASP.NET
DATABASE USED: SQL SERVER 2005
HARDWARE REQUIREMENTS PROCESSOR: 456 MHZ OR ABOVE
RAM: 256 MB AND ABOVE
FEASIBILITY STUDY
1. PROBLEM STATEMENT: To develop a complete ONLINE SHOPPING which is a web based application which handles inquir y regarding the different product available on the website .This enhances the working ability and reduces the required resources and manpower; also give new and refreshing look to the interface.
2. TECHNICAL FEASIBILITY: A) The current system is built on user interface environment using SQL SERVER 2005 and ASP.NET, which will provide a good and enhanced working environment. B) Provides a user friendly environment. C) Windows OS and ASP.NET software are easily available and easy to interact. 3 . BEHAVIORAL FEASIBILITY: During the onsite review of the current system the client showed a positive approach towards the change over. Any further change in the current system will be accepted smoothly, as this new developing system is based on GUI interface.
4 . ALTERNATIVE SOLUTION: Right now we are implementing this s ystem using MS SQL SERVER2005 as backend. It can be structured using MS access or ORACLE8 or above.
5. RISK ANALYSIS: Risk identification: Technical risk: - In this project, the only risk can arise if some change occurs in the technical requirements of the management. As per the requirement, we have taken ASP.NET as technology for system development and if this changes then we have to change the design process.
DATABASE DESIGN
emaili
pwd
name
ADMIN replies
checks
update price
name emaili
PRODUCT
buys
add
cat
p
CUSTOMER
pid
VALUE
has name
PAYMENT
makes
pwd
orderi registe
provid
takes
REGISTRATION
FEEDBACK
fid
Entity Relationship Diagram
FIELD NAME
DATA TYPE
SIZE
EMAILID
NVARCHAR
50
PASSWORD
NVARCHAR
50
FNAME
NCHAR
20
LNAME
NCHAR
20
ADDRESS1
NVARCHAR
100
ADDRESS2
NVARCHAR
100
PHONE
NUMERIC
(18,0)
MOBILE
NUMERIC
(18,0)
CITY
NCHAR
20
STATE
NCHAR
20
COUNTRY
NCHAR
10
PINCODE
NUMERIC
(18,0)
DATE OF BIRTH
DATETIME
ABOUTUS
NCHAR
20
QUESTION
NCHAR
20
ANSWER
NVARCHAR
50
PERMISSION
NCHAR
10
FIELD NAME
DATA TYPE
SIZE
ITEMID
NVARCHAR
50
ITEMNAME
NVARCHAR
COMPANY
NVARCHAR
30
CATEGORY
NVARCHAR
50
DESCRIPTION
NVARCHAR
MAX
INR
NCHAR
10
OFFERPRICE
NUMERIC
(18,0)
BASEPRICE
NUMERIC
(18,0)
SAVEMONEY
NUMERIC
(18,0)
IMAGE1
NVARCHAR
50
IMAGE2
NVARCHAR
50
IMAGE3
NVARCHAR
50
501 : REGISTRATION TABLE TABLE
TABLE 2 : PRODUCT TABLE
FIELD NAME
DATA TYPE
SIZE
ITEMID
NVARCHAR
50
EMAILID
NVARCHAR
50
FIELD NAME QUANTITY
DATA TYPE NUMERIC
SIZE (18,0)
TRANSACTION ORDERID COMPLETE
NVARCHAR NCHAR
50 10
EMAILID
NVARCHAR
50
TABLE 3 : SHOP TABLE FNAME NCHAR
20
LNAME
NCHAR
20
ADDRESS1
NVARCHAR
100
ADDRESS2
NVARCHAR
100
QUANTITY
NUMERIC
(18,0)
PHONE
NUMERIC
(18,0)
AMOUNT
NUMERIC
(18,0)
DATE
DATETIME
TABLE 4 : ORDER TABLE FIELD NAME
DATA TYPE
SIZE
FEEDBACKID
NVARCHAR
50
SUBJECT
NCHAR
20
FNAME
NCHAR
20
LNAME
NCHAR
20
EMAILID
NVARCHAR
50
PHONE
NUMERIC
(18,0)
COMMENTS
NVARCHAR
100
ANSWER
NCHAR
10
TABLE 5 : FEEDBACK TABLE
FIELD NAME
DATA TYPE
SIZE
ORDERID
NVARCHAR
50
NVARCHAR
50
NCHAR
20
CHEQUE-ID/ DD-ID PAYMENT DETAILS PAYMENT DATE
DATETIME
DELIVERY DETAILS
NCHAR
DELIVERY DATE
DATETIME
20
TABLE 6 : PAYMENTDETAILS TABLE
FUTURE ENHANCEMENT I mprovements in design can be made using: •
F lash
•
Photoshop
New features can be added, like: •
Improved validation
•
Provision of discounts and offers
•
Generation of reports
•
P rovision of print-out(s) to buyer
•
Refund of the money if the order is cancelled within a specific time period
•
Larger collection of products.
CONCLUSION
ACHIEVEMENTS:
The program achieved the main requirement which was to develop a website meant for online shopping. Given the amount of time on hand, and given the basic knowledge of the front end & back end used, the site satisfies most of the basic requirements that it was supposed and planned to fulfill, like, providing facilities for authentication, registration, searching for products, using a shopping cart, placing orders, cancellation of orders,
calculation of total
payable amount, providing options for means of payment, addition of new products to the site, managing the deliver y of products, a ver y basic view of account details, and extraction of information from the database using queries, where the database is created in MS SQL & is connected to the design of site using SqlDataSource, and the web site has been designed using ASP.NET with all the coding done in Visual C#. During the development of the project, not only did we learn the basic concept behind online shopping, but we also learnt many basic features and concepts of ASP.NET & SQL and how the ASP.NET technology can enable one to develop web sites and applications with very little hassle. The development period did give me some confidence to put together some sites in my spare time! The entire project was like a challenge to me. The concept itself was interesting, and it was aggravated by the fact that it was my first-ever experience with Practical Training. Most of the time was consumed by the development of logic and its application in the correct manner. There were matters of concerns, and numerous new ideas coming up, time and again, but at the end of it all, the problems, their solutions & the new ideas played a major role in helping me develop a broad outlook towards how things work in the real world, and ever ything I gained in the 30-day period, will certainly help me with the projects in the real software world in the time to come.
LIMITATIONS:
The major limitation of the project is that the site is not connected to an y financial institution which almost all such sites are (unless they don’t provide for ‘credit card’ as a means of payment) because credit card is undoubtedly the dominant method of payment used to shop online. However, in the project, the credit card is taken as a mode of payment just to show how the credit card information is entered when online shopping is carried out. Once the user enters his credit card details on shopping bazaar, a message is displayed, that the details have been verified and his order has been registered if the details are entered in the correct format (an arbitrar y format is used with shopping bazaar). The actual sites are connected to a financial institution and follow the code format used by different credit card companies like, MasterCard, Visa etc. When a user enters a valid credit card type and corresponding number & CVV, then, a modem sends out these details to the institution. If funds are available, the transaction is approved almost instantaneously and the ordered goods are delivered within a specified time frame.
REFERENCES
•
www.onlineshop.org
•
www.google.com
•
www.yahoo.com
BIBLIOGRAPHY
VB.NET ASP.NET 2.0 (BLACK BOOK)
SQL EVAN BARROS
Subject
ONLINE SHOPPING DEGREE: Bachelor of Engineering In Computer Engineering
Submitted To:
Submitted By:
Ms. Neelam
Renuka Saini(91)
VIII Sem. MajorProject Coordinator
Richa Kumbhat(92)
(Lecturer CE)
Computer Engineering IV B.E. DEPARTMENT OF COMPUTER ENGINEERING
JAIPUR ENGINEERING COLLEGE & RESEARCH CENTER UNIVERSITY OF RAJASTHAN 2007-2008
CONTENTS
ACKNOWLEDGEMENT ABSTRACT REQUIREMENTS SOFTWARE REQUIREMENT SPECIFICATION(SRS) Note--- you have to add screenshorts in your project report by am rita sarasw at. TECHNOLOGIES USED FEASIBILITY STUDY PROJECT DESCRIPTION •
ERD
•
DATABASE DESIGN
•
SCREEN SHOTS
FUTURE ENHANCEMENTS CONCLUSION REFERENCES BIBLIOGRAPHY
ACKNOWLEDGEMENT It is our pleasure to present a dissertation which owes its existence to numerous people. At the ver y outset, we have a word of ardent appreciation for the faculty of COMPUTER SCIENCE, JECRC for their faith to undertake the training in project. We express deep sense of gratitude to Ms. Neelam, faculty guide at COMPUTER SCIENCE, JECRC for being our mentor and giving his valuable suggestions, guidance and encouragement without which the completion of this project would have been a dream. Lastly, I extend my hearty thanks to all those who have contributed in making this project a success.
RENUKA SAINI RICHA KUMBHAT
ABSTRACT Whether you're buying direct from a business or an individual, an online “retailer” or an Internet auction, shopping online can be fun, easy, practical, and economical. But, just as in the bricks and mortar world, the Internet shopping experience can be marred with unscrupulous dealers constantly devising new ways to deceive consumers out of their money. This site offers information to help you shop safely and wisely online. You can learn, for example, how to use online payment services, participate in an Internet auction or resolve a complaint with an online dealer. If you're a seller, you can learn about the rules for online advertising, timely deliveries and other business-related matters. All storefront solutions include a shopping cart; this is the component of our store that allows the customer to select the items they want to purchase. It’s the most important aspect of our online store. Another most important fact is that many customers on the internet will expect the customer service you offer online to match or exceed that which you offer in the real world. Through this site not only the consumers on the internet feel empowered in a way that has not existed offline, but they actually have been empowered. You can almost instantly compare your prices and services with that of the other organizations. You can quickly find out if your previous customer is satisfied with your company. You can also post your complaints online if at any time you are unsatisfied with our site. In short, we have shifted the power of the buyer-seller relationship in the hands of the buyer. You cannot afford to slip up when it comes to your online
store. Excellence in execution and deliver y is a must. That is why one of the most important that you can do is just visit our website and feel free and convenient to shop for anything you feel. This site allows you to surf through the complete site and then you can shop for any products under your range. The look of our store is vital when you are operating in an environment as competitive as the internet. Customers will often make a decision about whether to enter an online store based on the look of its front page. This ever ything else including the images you can only find on our website. These all features are supported by our website. We have included all the important aspects which one thinks of in an online shopping. It has been said that it is just as eas y to lose the customers on the web as is to attract them. This means that setting up a store on internet involves far more than just creating an attractive website to sell your products.
SOFTWARE REQUIREMENTS SPECIFICATIONS DOCUMENT GROUP MEMBERS: RENUKA SAINI (B1CS912008) RICHA KUMBHAT (B1CS922008)
Introduction :This document provides details about the entire software requirements specification for the software ONLINE-SHOPPING an Online Shopping Centre. This site offers information to help you shop safely and wisely online. You can learn, for example, how to use online payment services, participate in an Internet auction or resolve a complaint with an online dealer. All storefront solutions include a shopping cart; this is the component of our store that allows the customer to select the items they want to purchase. It’s the most important aspect of our online store. Another most important fact is that many customers on the internet will expect the customer service you offer online to match or exceed that which you offer in the real world. Through this site not only the consumers on the internet feel empowered in a way that has not existed offline, but they actually have been empowered. You can almost instantly compare your prices and services with that of the other organizations. You can quickly find out if your previous customer is satisfied with your company. You can also post your complaints online if at any time you are unsatisfied with our site.
Purpose :The purpose of this project is to provide eas y shopping facility online and getting the products to the doorsteps of provided categories. We have shifted the power of the buyer-seller relationship in the hands of the bu yer. You cannot afford to slip up when it comes to your online store. Excellence in execution and deliver y is a must. That is why one of the most important that you can do is just visit our website and feel free and convenient to shop for anything you feel. This site allows you to surf through the complete site and then you can shop for any products under your range.
Scope :The name of the project is ONLINE- SHOPPING The software provides the customer with his unique Order ID number. The software provides the following facilities to the customers: •
Facilitates eas y shopping online any where with minimal shipping (conditions apply)
•
Provides information about the products in categories
•
Can reserve or order if the particular product is not available
•
Customers are provided with up to date information on the products available
•
Provides feedback form facility for future correspondence
•
Provides backup facility
•
Reserve the product for the customer till the time he/she doesn’t completes his transaction.
The software will not provide the following facilities to the customers: •
No banking facility available.
•
Responsibility of damages.
•
The product cannot be changeable after 7 days from the date of payment.
The objective of this software is to provide eas y assistance both to the administrator and customer with proper database and information.
Definitions, Acronyms and Abbreviations :1. Customer
: The person who purchases the product
2. Admin
: The person/company manager who deals with the
database and products. 3. Order
ID
Number
:
The
unique
id
given
to
each
customer
who access the data in the site. 4. Product
: The products available on our website.
Overview :The following subsections provide the complete overview of the software specifications
requirements
documentation
for
the
product
ONLINE-
SHOPPING The entire SRS is documented in view of both customers and the administrator and the following sub sections are arranged to give a complete outlook of the software, its perspective, features, system requirements and users know how.
Product perspective:This software is totally self contained and works relatively as efficient as other packages related to the subject. It provides simple database rather than
complex ones for high requirements and it provides good and easy graphical user interface to both new, naïve as well as experienced users of the computers.
System Interfaces:Interface: The software provides good graphical interface for the front end of the database and a good informative interface for the rear end User Interface: The first interface the user will encounter is the Home page on the Online Shopping website. From here the user can search any product or sign in for bu ying a product by clicking on Sign-in. The user can move to the following web pages: 1. Sign-in 2. Registration 3. My Account 4. Forget Password 5. Shopping Cart 6. Final Order 7. Payment Details 8. About us 9. Terms and condition 10. Shopping Demo 11. Contact us Hardw are Interface:The system should have these hardware requirements:
•
The processor should be at least Pentium 4 or above.
•
The processor speed should be greater than 456 MHz.
•
RAM should be or greater than 256 MB.
Software Interfaces:The software requires the support of the following software’s for the database and other requirements •
IIS should be installed on the machine of the server.
•
ASP.Net for web interface.
•
SQL Server 2005 for database.
•
Server (windows 2000 or above…)
Operations :The operations required by the users are : Customers : 1. Window shopping 2. Creates accounts/ Register him 3. Shopping 4. Add products to their shopping cart 5. Buy products 6. Provide feedback Website Administrator : 1. Update information 2. Add Products 3. Delete Products 4. Honest transactions 5. Replies to the feedback
Product functions :The following use case diagram provides complete information regarding how the software works
register
business info
login with email customer
administrator search item
search by category
Update database create user preference
product database check order status
accounts regarding products Places order
calculate total
query
customer's data for correspondence
Complete use case diagram of the product functionality
•
Hom e page The home page works as the site map for the whole software.
•
Login Introduction and Purpose The login Function allows the users to access the web based facilities and information.
software
User types their username i.e. the email id and the password in the provided textboxes and then click on the sign in button and then is able to access the different the functionalities from the home page. If the details provided by the user do not match with the database, error message is displayed and he has to refill the information. •
Logout Introduction and Purpose The logout function allows the user to safely end the session on the web based software. The user has to click on the logout button active on the web pages which is visible after signing-in in their accounts.
•
Creating New Account Introduction and Purpose The login Function allows the users to gain membership to access the web based software facilities and information. The user clicks on the Register button on the sign-in page. Within the indicated text input fields of the registration page the user has to fill the following personal details: 1. Mailing Address (to be used as username) 2. Account Password and Confirm Password 3. First name and Last name 4. Address Details 5. Phone and Mobile number 6. City 7. State 8. Countr y 9. Pin code and other details….
The user after filling all the required information he/she has to accept the Terms and Conditions of the website and then submit his registration form. If all the details are valid provided by the user, he/she becomes a registered user on our website and now can access the web based software facilities and information. •
Forget Password Introduction and Purpose If a registered user forgets the account password with which he signsin, he can click on the Forget Password button on the Sign-in page. The User is then directed to a new Forget Password Page where he is asked to fill certain details which are matched with the existing details of the user from the database. If these details match the user is allowed to change the account password. The same facility is also provided on the My Account Page.
•
Search Product Introduction and Purpose Any customer visiting our web based software is allowed to search according to his choice. The web based software is provided with three kinds of searches: 1. Simple Search 2. Company Search 3. Price Search
•
Shopping Cart Introduction and Purpose Only the registered users are allowed to access this facility. The user can add the products according to his/her choice in the shopping cart. For buying a product the users have to add the product in the shopping cart as it is the shopping procedure. To finalize his order the user clicks
on the order button. Even after adding a product in the cart he can remove it from the cart by clicking on the remove button. •
Place Order Introduction and Purpose When the user clicks on the order button from the shopping cart page, this page displays the final order of the user showing the total amount and the total number of products. Even at this stage the user is allowed to make changes in the shopping cart.
•
Payments Introduction and Purpose This web page tells the user the various modes of payment available. There are two modes of payment: 1. Through Cheque 2. Through Demand Draft
•
Billing Details Introduction and Purpose This page displays the shipping details of the user he filled at the time of registration. At this point if he wants to change the shipping details he can click on the change now button where he is directed to the edit page. After checking the details he can now place his order by clicking on the order now button.
•
Transaction Complete Introduction and Purpose This is the last step of the product buying cycle. Here the customer gets
the
final
correspondence. .
Order
ID
Number
which
he
can
use
for
future
•
My Account Introduction and Purpose Through this web page the registered users can access their personal account. Here users are provided with four functionalities: 1. Shopping Cart: If the user under some conditions left his shopping incomplete and has just added items to his shopping cart he can view his cart here at any point of time. 2. Password:
This
is
same
change
as
the
Forget
Password
functionality.
3. Edit Information: Here the user can make changes to the information he provided at the time of registration. 4. Order Details: Here the user can view the order by placing the Order ID Number provided to him. He can also look for the Payment and Delivery related details.
•
Contact Us Introduction and Purpose If the user wants to contact us for his queries, this page details our address.This page is also provided with Feedback: This is a function which provides feedback functionality to the user where he/she can quer y about the products, payment, or if he/she has faced any problem during the transaction process. He/She can even provide us with any suggestions related to the web based software
•
About us Introduction and Purpose It gives a brief introduction about what our website is all about, our
parent company Pantaloon and the different promises that our website makes with the customer and how it fulfills them. •
Shopping Dem o Introduction and Purpose This is a complete guide to the user for how he/she can buy a product from our web based software if he’s new to our website. The shopping consists of four stages: 1. Searching the product 2. Registering 3. Adding products to shopping cart 4. Payment and Delivery
•
Term s and Conditions Introduction and Purpose It tells about the terms and conditions governing the use of the site. The user is requested to not to use the site or transact on the site if he/she do not agree with any of the terms and conditions provided below.
Account and Registration Obligations Pricing Information Cancellations by the customer Electronic Communications Governing Law and Jurisdiction Cop yright & Trademark
Site Security Agreement •
Admin Introduction and Purpose The Admin is the main managing authority of the web based software. The Admin is the sole authority controlling the Database. He is provided with the following functionalities: 1. Add product Through this functionality the Admin add new products to the web based software. 2. Delete Product Through this functionality the Admin can delete the existing
product
from the database of web based software. 3. Reply Feedback From here the Admin replies to the different user queries. 4. Payment control Through this the Admin manages the entire information related to the payment (Cheque, DD) and deliver y details.
User characteristics :•
No pre knowledge of database management
•
Should be familiar with internet
•
Should know English.
•
Should be able to use and do according to the graphical user interface
Assumptions and Dependencies: •
User will know how to use mouse and keyboard
•
User will know how to use a web-browser.
The following is a list of occurrences that could change the requirements of the project in future: •
Large number of “hits” to the site.
•
Demand exceeding Product supply
•
More extensive product line
Performance Requirements :Performance requirements are : 1. Good working pc with all the requirements as stated in the hardware interfaces 2. Works for medium size information databases 3. Should not be overloaded
Future Developments :•
Banking Facilities
•
Support for large database
•
Oracle for database
TECHNOLOGIES USED
The Microsoft .NET Fram ework The .NET Framework is the infrastructure for the Microsoft .NET platform. The .NET Framework is an environment for building, deploying, and running Web applications and Web Services. Microsoft's first server technology ASP (Active Server Pages) was a powerful and flexible "programming language". But it was too much code oriented. It was not an application framework and not an enterprise development tool. The Microsoft .NET Framework was developed to solve this problem. .NET Frameworks keywords: •
Easier and quicker programming
•
Reduced amount of code
•
Declarative programming model
•
Richer server control hierarchy with events
•
Larger class library
•
Better support for development tools
The .NET Framework consists of 3 main parts: Programming languages: •
C# (Pronounced C sharp)
•
Visual Basic (VB .NET)
•
J# (Pronounced J sharp)
Server technologies and client technologies: •
ASP .NET (Active Server Pages)
•
Windows Forms (Windows desktop solutions)
•
Compact Framework (PDA / Mobile solutions)
Developm ent environm ents: •
Visual Studio .NET (VS .NET)
•
Visual Web Developer
ASP.NET What is ASP.NET? ASP.NET is a server side scripting technology that enables scripts (embedded in web pages) to be executed by an Internet server. •
ASP.NET is a Microsoft Technology
•
ASP stands for Active Server Pages
•
ASP.NET is a program that runs ins ide IIS
•
IIS (Internet Information Services) is Microsoft's Internet server
•
IIS comes as a free component with W indows servers
•
IIS is also a part of W indows 2000 and XP Professional
An ASP.NET file is just the same as an HT ML file . It can contain HT ML, XML, and scripts . Scripts in an ASP.NET file are exec uted on the server. An ASP.NET file has the file extens ion ".aspx"
How Does ASP.NET Work? •
When a browser requests an HTML file, the server returns the file
•
When a browser requests an ASP.NET file, IIS passes the request to the ASP.NET engine on the server
•
The ASP.NET engine reads the file, line by line, and executes the scripts in the file
•
Finally, the ASP.NET file is returned to the browser as plain HTML
ASP.NET has better language support, a large set of new controls and XML based components, and better user authentication. ASP.NET provides increased performance by running compiled code. ASP.NET code is not fully bac kw ard co mpatible with ASP.
New in ASP.NET
Better language support
Event-driven programming
XML-based components
Higher scalability
Increased performance - Compiled code
Easier configuration and deployment
Not fully ASP compatible
Language Support ASP.NET uses the new ADO.NET. ASP.NET supports full Visual Basic, not VBScript. ASP.NET supports C# (C sharp) and C++. ASP.NET supports JScript as before. Event Aw are Controls All ASP.NET objects on a Web page can expose events that can be processed b y ASP.NET code.Load, Click and Change events handled by
code makes coding much simpler and much better organized. ASP.NET Components ASP.NET components are heavily based on XML. Like the new AD Rotator, that uses XML to store advertisement information and configuration. User Authentication ASP.NET
supports
forms-based
user
authentication,
including
cookie
management and automatic redirecting of unauthorized logins.(You can still do your custom login page and custom user checking). High Scalability Much has been done with ASP.NET to provide greater scalability.Server to server communication has been greatly enhanced, making it possible to scale an application over several servers. One example of this is the ability to run XML parsers, XSL transformations and even resource hungry session objects on other servers. Compiled Code The first request for an ASP.NET page on the server will compile the ASP.NET code and keep a cached copy in memor y. The result of this is greatly increased performance. Easy Deployment No more server restart to deploy or replace compiled code. ASP.NET simply redirects all new requests to the new code.
Compatibility
ASP.NET is not fully compatible with earlier versions of ASP, so most of the old ASP code will need some changes to run under ASP.NET.
SQL SERVER 2005 SQL is a standard computer language for accessing and manipulating databases. SQL stands for Structured Query Language. SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database s ystems. SQL statements are used to retrieve and update data in the database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. SQL Database Tables most often contains one or more tables. Each table is identified by a name. With SQL, we can query a database and have a result set returned. SQL Data Manipulation Language (DML) SQL is syntax for executing queries. But the SQL language also includes syntax to update, insert, and delete records. These quer y and update commands together form the Data Manipulation Language (DML) part of SQL. The most important DML statements in SQL are: SELECT
extracts data from a database table
UPDATE
updates data in a database table
DELETE
deletes rows from a database table
INSERT INTO
inserts new data into a database table
TRUNCATE
deletes all the rows from a database table
SQL Data Definition Language (DDL) The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also
define
indexes
(keys),
specify
links
between
tables,
and
impose
constraints between database tables. The most important DDL statements in SQL are: CREATE TABLE
creates a new database table
ALTER TABLE
alters (changes) a database table
DROP TABLE
deletes a database table
CREATE INDEX
creates an index(search key)
DROP INDEX
deletes an index
The result from a SQL quer y is stored in a result–set. Most database software s ystems
the result-set with
programming
functions, like: Move–To–First-Record, Get–Record-Contents,
Move-To-
Next-Record, etc.
allow
navigation
of
REQUIREMENTS
INTERFACE REQUIRED PLATFORM USED: WIN 2000 OR HIGHER VERSION
LANGUAGE USED: ASP.NET
DATABASE USED: SQL SERVER 2005
HARDWARE REQUIREMENTS PROCESSOR: 456 MHZ OR ABOVE
RAM: 256 MB AND ABOVE
FEASIBILITY STUDY
1. PROBLEM STATEMENT: To develop a complete ONLINE SHOPPING which is a web based application which handles inquir y regarding the different product available on the website .This enhances the working ability and reduces the required resources and manpower; also give new and refreshing look to the interface.
2. TECHNICAL FEASIBILITY: A) The current system is built on user interface environment using SQL SERVER 2005 and ASP.NET, which will provide a good and enhanced working environment. B) Provides a user friendly environment. C) Windows OS and ASP.NET software are easily available and easy to interact. 3 . BEHAVIORAL FEASIBILITY: During the onsite review of the current system the client showed a positive approach towards the change over. Any further change in the current system will be accepted smoothly, as this new developing system is based on GUI interface.
4 . ALTERNATIVE SOLUTION: Right now we are implementing this s ystem using MS SQL SERVER2005 as backend. It can be structured using MS access or ORACLE8 or above.
5. RISK ANALYSIS: Risk identification: Technical risk: - In this project, the only risk can arise if some change occurs in the technical requirements of the management. As per the requirement, we have taken ASP.NET as technology for system development and if this changes then we have to change the design process.
DATABASE DESIGN
emaili
pwd
name
ADMIN replies
checks
update price
name emaili
PRODUCT
buys
add
cat
p
CUSTOMER
pid
VALUE
has name
PAYMENT
makes
pwd
orderi registe
provid
takes
REGISTRATION
FEEDBACK
fid
Entity Relationship Diagram
FIELD NAME
DATA TYPE
SIZE
EMAILID
NVARCHAR
50
PASSWORD
NVARCHAR
50
FNAME
NCHAR
20
LNAME
NCHAR
20
ADDRESS1
NVARCHAR
100
ADDRESS2
NVARCHAR
100
PHONE
NUMERIC
(18,0)
MOBILE
NUMERIC
(18,0)
CITY
NCHAR
20
STATE
NCHAR
20
COUNTRY
NCHAR
10
PINCODE
NUMERIC
(18,0)
DATE OF BIRTH
DATETIME
ABOUTUS
NCHAR
20
QUESTION
NCHAR
20
ANSWER
NVARCHAR
50
PERMISSION
NCHAR
10
FIELD NAME
DATA TYPE
SIZE
ITEMID
NVARCHAR
50
ITEMNAME
NVARCHAR
COMPANY
NVARCHAR
30
CATEGORY
NVARCHAR
50
DESCRIPTION
NVARCHAR
MAX
INR
NCHAR
10
OFFERPRICE
NUMERIC
(18,0)
BASEPRICE
NUMERIC
(18,0)
SAVEMONEY
NUMERIC
(18,0)
IMAGE1
NVARCHAR
50
IMAGE2
NVARCHAR
50
IMAGE3
NVARCHAR
50
501 : REGISTRATION TABLE TABLE
TABLE 2 : PRODUCT TABLE
FIELD NAME
DATA TYPE
SIZE
ITEMID
NVARCHAR
50
EMAILID
NVARCHAR
50
FIELD NAME QUANTITY
DATA TYPE NUMERIC
SIZE (18,0)
TRANSACTION ORDERID COMPLETE
NVARCHAR NCHAR
50 10
EMAILID
NVARCHAR
50
TABLE 3 : SHOP TABLE FNAME NCHAR
20
LNAME
NCHAR
20
ADDRESS1
NVARCHAR
100
ADDRESS2
NVARCHAR
100
QUANTITY
NUMERIC
(18,0)
PHONE
NUMERIC
(18,0)
AMOUNT
NUMERIC
(18,0)
DATE
DATETIME
TABLE 4 : ORDER TABLE FIELD NAME
DATA TYPE
SIZE
FEEDBACKID
NVARCHAR
50
SUBJECT
NCHAR
20
FNAME
NCHAR
20
LNAME
NCHAR
20
EMAILID
NVARCHAR
50
PHONE
NUMERIC
(18,0)
COMMENTS
NVARCHAR
100
ANSWER
NCHAR
10
TABLE 5 : FEEDBACK TABLE
FIELD NAME
DATA TYPE
SIZE
ORDERID
NVARCHAR
50
NVARCHAR
50
NCHAR
20
CHEQUE-ID/ DD-ID PAYMENT DETAILS PAYMENT DATE
DATETIME
DELIVERY DETAILS
NCHAR
DELIVERY DATE
DATETIME
20
TABLE 6 : PAYMENTDETAILS TABLE
FUTURE ENHANCEMENT I mprovements in design can be made using: •
F lash
•
Photoshop
New features can be added, like: •
Improved validation
•
Provision of discounts and offers
•
Generation of reports
•
P rovision of print-out(s) to buyer
•
Refund of the money if the order is cancelled within a specific time period
•
Larger collection of products.
CONCLUSION
ACHIEVEMENTS:
The program achieved the main requirement which was to develop a website meant for online shopping. Given the amount of time on hand, and given the basic knowledge of the front end & back end used, the site satisfies most of the basic requirements that it was supposed and planned to fulfill, like, providing facilities for authentication, registration, searching for products, using a shopping cart, placing orders, cancellation of orders,
calculation of total
payable amount, providing options for means of payment, addition of new products to the site, managing the deliver y of products, a ver y basic view of account details, and extraction of information from the database using queries, where the database is created in MS SQL & is connected to the design of site using SqlDataSource, and the web site has been designed using ASP.NET with all the coding done in Visual C#. During the development of the project, not only did we learn the basic concept behind online shopping, but we also learnt many basic features and concepts of ASP.NET & SQL and how the ASP.NET technology can enable one to develop web sites and applications with very little hassle. The development period did give me some confidence to put together some sites in my spare time! The entire project was like a challenge to me. The concept itself was interesting, and it was aggravated by the fact that it was my first-ever experience with Practical Training. Most of the time was consumed by the development of logic and its application in the correct manner. There were matters of concerns, and numerous new ideas coming up, time and again, but at the end of it all, the problems, their solutions & the new ideas played a major role in helping me develop a broad outlook towards how things work in the real world, and ever ything I gained in the 30-day period, will certainly help me with the projects in the real software world in the time to come.
LIMITATIONS:
The major limitation of the project is that the site is not connected to an y financial institution which almost all such sites are (unless they don’t provide for ‘credit card’ as a means of payment) because credit card is undoubtedly the dominant method of payment used to shop online. However, in the project, the credit card is taken as a mode of payment just to show how the credit card information is entered when online shopping is carried out. Once the user enters his credit card details on shopping bazaar, a message is displayed, that the details have been verified and his order has been registered if the details are entered in the correct format (an arbitrar y format is used with shopping bazaar). The actual sites are connected to a financial institution and follow the code format used by different credit card companies like, MasterCard, Visa etc. When a user enters a valid credit card type and corresponding number & CVV, then, a modem sends out these details to the institution. If funds are available, the transaction is approved almost instantaneously and the ordered goods are delivered within a specified time frame.
REFERENCES
•
www.onlineshop.org
•
www.google.com
•
www.yahoo.com
BIBLIOGRAPHY
VB.NET ASP.NET 2.0 (BLACK BOOK)
SQL EVAN BARROS
