BIDMALL ONLINE AUCTIONS
INTRODUCTION
B P C COLLEGE
1
BIDMALL ONLINE AUCTIONS
1. INTRODUCTION
ABOUT THE ORGANISATION
Founded in 1981, with the mission of "Bringing People and Computers Together…Successfully", NIIT, Asia's No. 1 trainer and leading Global Talent Development Corporation, offers learning and knowledge solutions to 5 million students across 32 countries. The NIIT Group is also positioned strongly in the software and services space through NIIT Technologies. NIIT has Pioneering innovative classroom, e-learning and advanced solutions for career seekers, professionals, corporations and higher education institutions. NIIT Technologies is gaining the trust of global organizations by providing innovative IT Solutions and Business Process Management Services in key verticals such as Insurance, Banking, Retail, Transport, and Manufacturing.
ABOUT THE PROJECT
The project entitled ‘Bid Mall Online Auctions’ is the public sales for the highest bid amount. The main goal is to provide easy way for buying and selling products over the web. Any person can register in the web site and after that can to present his own products for tenders, to take part in another tenders (add bids), to manage user account, to resell unsold products. Unregistered person may only see common pages with all tenders, products and seller's information. The project contains modules such as entering details of auctioneer&bidder, entering details of product to be put into auction, bidding, transactions&payments.The auctioneer can enter the details of his own product for auction and the bidder can select the product from the list and make the auction. The auctioneer and bidder can see the details of the item. The auctioneer can also
B P C COLLEGE
2
BIDMALL ONLINE AUCTIONS
take part in the auction of other products. But an auctioneer can’t bid for his own product. Also the bidder can put products for auction. i.e, the auctioneer may act also as a bidder and that the bidder can also act as an auctioneer. This will be a highly user-friendly web enabled application which can be used over any popular browsers available in the market. The bidder who bid the maximum amount for the product within the particular date assigned by the auctioneer will be the winner of the auction.The auctioneer will send a mail to the winner conveying that he is the winner with a confirmation. The bidder in reply sends the confirmation. The transactions will be then done and at last go to payments. Payment is done using credit cards. It opens up new sales channels for new products and offers buyers favorable purchasing conditions. We make it easy for individuals and businesses to buy and sell their products, all without expensive marketing costs. Each user has a unique identification. A separate auction will be held for each item. No bid below the start bid amount is registered. In the auction the product will be fixed to the person who has bided the maximum amount within the particular date assigned by the auctioneer. We facilitate the process of displaying products, bidding on items and paying for them. It acts as a market place for individuals and businesses that use the site to auction off goods.
B P C COLLEGE
3
BIDMALL ONLINE AUCTIONS
SYSTEM STUDY
B P C COLLEGE
4
BIDMALL ONLINE AUCTIONS
2. SYSTEM STUDY 2.1 Existing System In the existing system, anyone interested to participate in auction has to visit the office where the auction is being held. A participant needs to first register himself before participating in an auction. The employees working in the office maintains records of all registered participants in Excel Worksheets. Auction’s tokens are issued to registered auction participants, using which they can participate in auction bids. Details of the products to be auctioned are also stored in Excel Worksheets. Before an auction starts, employees needs to first search product details stored in Excel Worksheets to finalize lowest bidding price & no.of products to be auctioned. In the present system, the company doesn’t store details of every auction bid. Only details of ten highest bids are stored. Again, the bid details are stored in Excel Worksheets
Drawbacks • Time Consuming •
Retrieval of particular & records are difficult.
• Low Accuracy. •
Can’t store details of all Auctions.
2.2 Proposed System As is evident from the existing system, to maintain details in Excel Worksheets a lot of time is required. Moreover, anyone interested to participate in auctions needs to be present at the auction site. Many times this limitation discourages prospective buyers from participating in auctions.As a result a new system is developed, which will remove all the workload of maintaining Excel Worksheets & make the whole auction process more dynamic so that anyone
B P C COLLEGE
5
BIDMALL ONLINE AUCTIONS
interested in participating in auctions will not be required to present at the auction office at the time of auction. The proposed system developed will change the entire auction process to a web-based system. Customers will be able to participate auctions online without traveling to the office. The new system will have a global approach where people from different countries will be able to participate in auctions. Auctions payments will be made online using credit cards. The system will store details about every single bid for a product.
Advantages • Less Time Consuming • Data & Records can be easily retrieved. • All auction details will be stored. • Avoid Manual Work.
2.3 Feasibility Study Feasibility analysis is the procedure for identifying the candidate system, evaluating and electing the most feasible system. This is done by investigating the existing system in the area under investigation or generally ideas about a new system. It is a test of a system proposal according to its workability, impact on the organization, ability to meet user needs, and effective use of resources. The objective of feasibility study is not to solve the problem but to acquire a sense of its scope. Feasibility analysis involves 8 steps: 1. Form a project team and appoint a project leader. 2. Prepare system flow charts. 3. Enumerate potential candidate system. 4. Describe and identify characteristics of candidate systems.
B P C COLLEGE
6
BIDMALL ONLINE AUCTIONS
5. Determine and evaluate performance and cost effectiveness of each candidate system. 6. Weigh system performance and cost data. 7. Select the best candidate system. 8. Repair and report final project directive to management. Three key considerations are involved in the feasibility analysis: economic, technical and behavioral.
2.3.1 Economic Feasibility Economic analysis is the most frequently used method for evaluating the effectiveness of a candidate system. It is more commonly known as cost benefit analysis, the procedure to determine the benefits and saving that are expected from a candidate system and compare them with costs. If the benefits outweigh costs then a decision is made to design and implement the system. Otherwise make alterations in the proposed system.
2.3.2 Technical feasibility The assessments of technical feasibility centers on the existing system and to what extent it can support the proposed addition. This was based on an outline design of system requirements in turns of inputs, files, programs, procedures, and staff. It involves financial considerations to accommodate technical enhancement.
B P C COLLEGE
7
BIDMALL ONLINE AUCTIONS
2.3.3 Behavioral feasibility People are inherently resistant to change, and computers have been known to facilitate change. An estimate should be made about the reaction of the user staff towards the development of a computerized system. Computer installations have something to do with turnover, transfers and changes in job status. The introduction of a candidate system requires special effort to educate, sell and train the staff for conducting the business. The candidate system was found to be technically, economically, and behaviorally feasible. The system was developed user friendly, needless training and improves the working environment. Justification for any capital outlay is that it will increase profit, reduce expenditure or improve the quality of service or goods, which in turn may be expected to provide increased profits. Disregarding the initial expenses, the candidate system was assessed to be feasible in all ways.
B P C COLLEGE
8
BIDMALL ONLINE AUCTIONS
REQUIREMENT ANALYSIS
B P C COLLEGE
9
BIDMALL ONLINE AUCTIONS
3. REQUIREMENT ANALYSIS Requirement analysis is a software engineering task that bridges the gap between the system level engineering and software design. The first step understands the users requirements within the framework and the environment in which the system is being installed. Consideration is given to the user’s resources as well as to finances. In selecting the software, the user must decide whether to develop it in-house, hire a service company or a contract programmer to create it. Or simply acquire it from a software house. The choice is logically made after the user has clearly defined the requirement expected of the software. Therefore, requirement analysis sets the tone for software selection. The software analysis builds models of the data, functional and behavioral domains that will be treated by the software. The software requirement analysis may be divided into three area of effort. • Problem Recognition • Problem Evaluation • System Modeling
3.1 PROBLEM RECOGNITION First the communication for analysis must be established so that problem recognition is ensured. The goal is recognition of the basis problem elements as perceived by the customer or users. In the existing system the activities like entering products details for auction, entering users details searching the products that are to be put into auction &
maintaining auction details are done manually, which is time
consuming. Also it doesn’t store all auctions details .Instead it stores only highest
B P C COLLEGE
10
BIDMALL ONLINE AUCTIONS
10 auction details. In such a system searching and retrieving information’s mentioned are causes much effort. Problems of the existing system and its limitations are: • Delay in retrieval of Information • Time consuming • Lot of human effort • We spend more money to travel 3.2 PROBLEM EVALUATION AND SYNTHESIS
Problem evaluation and solution is the next major are of effort for analysis. The analyst must define all externally observable objectives evaluate the flow and content of information, define and elaborate all software function, understand software behavior in the context of events that affect the system, establish system interface characteristics, and uncover additional design constrains. Each of these tasks serves to describe the problem so that an overall approach or solution may be synthesized. The proposed system is a scalable, user-friendly application and is developed using the latest technology which handles all the above issues in a consistent and powerful way. Since the application is web-based, it supports data exchange over different service centers and thus gives an overall and accurate service analysis. It overcomes the limitations of existing system. • Fast retrieval of information. • Human effort can be reduced. • Less Time Consuming.
• No need to spend money to travel.
B P C COLLEGE
11
BIDMALL ONLINE AUCTIONS
3.3 MODELING During requirement analysis,we create models to be built to gain better understanding of the actual logical entities(functions and sub functions)to be built. The following are the roles of models in requirement anlysis. • The models help the analyst to understand information, functions, and behaviors of the system. • The model becomes the main reference for the review to determine completeness, consistency & accuracy of the specification. • The model becomes the foundation for designs.
B P C COLLEGE
12
BIDMALL ONLINE AUCTIONS
DEVELOPMENT ENVIRONMENT
4. SYSTEM SPECIFICATION B P C COLLEGE
13
BIDMALL ONLINE AUCTIONS
4.1 Operating System Windows 2000 server Windows 2000 server includes improved network, application, and web services. It provides increased reliability and scalability, lowers your cost of computing with powerful, flexible management services and provides the best foundation for running business applications.
4.2 Language And Software package MICROSOFT.NET Microsoft.net is software that connects information, people, systems, and services. It spans clients, servers, and developer tools, and consists of: The .NET framework 1.1,used for building and running all kinds of software including Web-based applications, smart client applications ,XML web services-components that facilitate integration by sharing data and functionality over a network through standard ,platform-independent protocols such as XML(Extensible Markup Language),SOAP and HTTP. Developer tools, such as Microsoft Visual Studio.NET 2003 which provides an integrated development environment (IDE) for maximizing developer productivity with the .NET framework. A set of servers, including Microsoft Windows Server 2000, Microsoft SQL Server, that integrates, runs, operates and manages web services and web applications.
B P C COLLEGE
14
BIDMALL ONLINE AUCTIONS
Client software such as Windows XP, Windows CE and Microsoft Office XP ,that helps developers deliver a deep and compelling user experience across a family of devices and existing products.
What Is .NET Framework? The .NET Framework is an integral Windows component for building and running the next generation of software application and web services. The .NET Framework: Supports over 20 different programming languages. Manages much of the plumbning involved in developing software, enabling developers to focus on the core business logic code. Makes it easier than ever before to build, to deploy, and to administer secure robust, and high performing applications. The .NET Framework is composed of the common language runtime and a unified set of class libraries.
Common Language Runtime (CLR) Class Libraries Base classes provide standard functionality such as input or output ,string manipulation, security management ,network communications, thread management, text management and user interface design features. The ADO.NET classes enable developers to interact with data accessed in the form of XML through the OLEDB,ODBC,ORACLE and SQL Server interfaces . XML classes enable XML manipulation, searching, and translations. The ASP.NET classes support the development of web-based applications and web services. The Windows Forms classes support the development of desktop-based smart client applications. Together the class
B P C COLLEGE
15
BIDMALL ONLINE AUCTIONS
libraries provide a common, consistent development interface across all languages supported by the .NET Framework.
ASP.NET ASP.NET is a programming framework built on the common language runtime that can be used on a server to build powerful web applications. ASP.NET offers several important advantages over previous Web development models:
Enhanced Performance ASP.NET is compiled common language runtime code running on the server. Unlike its interpreted predecessors, ASP.NET can take the advantage of early binding,just-in-time compilation,native optimization, and caching services right out of the box. The amounts to dramatically better performance before you ever write a line of code.
World Class Tool Support The ASP.NET framework is complemented by a rich tool box and designer in the visual studio integrated development environment. WYSIWYG editing, drag-and-drop server controls , and automatic deployment are just a few of the features this powerful tool provides.
Power And Flexibility Because ASP.NET is based on the common language runtime, the power and flexibility of that entire platform is available to Web application developers. The .NET Framework class library, messaging, and data accessed solutions are all seamlessly accessible from the web. ASP.NET is also language independent, so you can choose the language that best applies to your application or partition your application among many languages. Further, the common
B P C COLLEGE
16
BIDMALL ONLINE AUCTIONS
language runtime interoperability guarantees that your existing investment in COM- based development is preserved when migrating to ASP.NET .
Simplicity ASP.NET makes it easy to perform common tasks, from simple form submission and client authentication to deployment and site configuration. For example, the ASP.NET page framework allows you to build user interfaces that cleanly separate application logic from presentation code and to handle events in a simple, Visual Basic- like forms processing model. Additionally, the common language runtime simplifies development, with managed code services such as automatic reference counting and garbage collection.
Manageability ASP.NET employs a text-based , hierarchical configuration system ,which simplifies applying settings to your server environment and web applications. Because configuration information is stored as plain text, new settings may be applied without the aid of ,local administration tools. This “zero local administration”
philosophy
extends
to
deploying
ASP.NET
Framework
applications as well. An ASP.NET Framework application is deployed to a server simply by copying the necessary files to the server. No server restart is required, even to deploy or replace running compiled code.
Scalability and Availability ASP.NET has been designed with scalability in mind, with features specifically tailored to improve performance in clustered and multiprocessor environments. Further, processes are closely monitored and managed by the ASP.NET runtime, so that if one misbehaves(leaks, deadlocks), a new process can
B P C COLLEGE
17
BIDMALL ONLINE AUCTIONS
be created in its place, which helps keep your applications constantly available to handle requests.
Customizability and Extensibilty ASP.NET delivers a well- factored architecture that allows developers to “plug-in” their code at the appropriate level. In fact, it is possible to extend or replace any subcomponent of the ASP.NET runtime with your own custom-written component. Implementing custom authentication or state services has never been easier.
Security With built in windows authentication and per-application configuration , you can be assured that your application are secure.
Language Support The Microsoft .NET Platform currently offers built in support for three languages: C#,Visual Basic, and Jscript to build .NET applications.
Language Compatibility The differences between the vbscript used in ASP and Visual Basic >NET language used in ASP.NET are by far the most extensive of all the potential migration issus. Not only has ASP.NET departed from the VBScript language to “true“ VisualBasic, but the VisualBasic language itself has undergone significant changes in this release. The changes are designed to: Make the language more consistent by bringing together features of the language with similar purposes. Simplify the language by redesigning the features that made VisualBasic less than”basic”.
B P C COLLEGE
18
BIDMALL ONLINE AUCTIONS
Improve readability and maintainability bu redesigning features that hid too many important details from the programmer. Improve robustness by enforcing better practices, such as type –safe programming.
C# Microsoft Visual C# 2005 is the comprehensive toolset for creating XML Web services and Microsoft.NET- connected applications for Microsoft Windows and the web. This robust development package, which uses the component – oriented C# development language, offers beginning and intermediate developers with C++ or Java experience a modern language and environment for creating next-generation software. Visual C# 2005 delivers superior functionality for streamlining business processes, including: •
Rapid design,development and dployment support for creating and consuming Web services.
•
Form designers and visual controls for creating rich Windows- based Applications.
•
Authoring tools and services for building powerful Microsoft .NET serverbased solutions.
•
Migration tools for converting Java-based projects to the Microsoft.NET development environment. With Visual C# 2005 , developers can built solutions for the
broadest range of clients, including Windows, the web and the mobile or embedded devices. Using this elegant programming language and tool, developers can leverage their existing programming language and tool , developers can leverage their existing C++ and Java- language skills and knowledge to be successful in the .NET environment.
B P C COLLEGE
19
BIDMALL ONLINE AUCTIONS
HTML A web browser is a program that is used to visit web pages. Browsers use HTML files to generate Web pages. Physically the World Wide Web is a repository of HTML files stored on hard drives of computers spread across the world. These files are transferred from one computer to another by a common transport protocol called HTTP (Hyper Text Transfer Protocol). HTML files are simple text files and as such they can be easily read and understood by humans.
Java Script Java Script is a scripting language developed by Netscape. Java script is object oriented cross-platform scripting language. Since java script is interpreted at the browser level it maintains platform independence. You can use java script as a client side and server side programming language.
SQL Server 2005 SQL Server 2005, released in November 2005, is the successor to SQL Server 2000. It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries. XML columns can be associated with XSD schemas; XML data being stored is verified against the schema. XML is converted to an internal binary data type before being stored in the database. Specialized indexing methods were made available for XML data. XML data is queried for using XQuery; SQL Server 2005 added some extensions to the T-SQL language to allow embedding XQuery queries in T-SQL. In addition, it also defines a new extension to XQuery, called XML DML, that allows querybased modifications to XML data. SQL Server 2005 also allows a database server
B P C COLLEGE
20
BIDMALL ONLINE AUCTIONS
to be exposed over web services using TDS packets encapsulated within SOAP request; when the data is access over web services, results are returned as XML. For relational data, T-SQL has been augmented with error handling features and support for recursive queries. SQL Server 2005 has also been enhanced with new indexing algorithms and better error recovery systems. Permissions and access control have been made more granular and the query processor handles concurrent execution of queries in a more efficient way. Partitions on tables and indexes are supported natively, so scaling out a database onto a cluster is easier. SQL CLR was introduced with SQL Server 2005 to let it integrate with .NET Framework.
Hardware Requirements PROCESSOR
:
PENTIUM III
CLOCK SPEED
:
500 MHZ
SYSTEM BUS
:
32 BIT
RAM
:
128 MB
HDD
:
1.2 GB
MONITOR
:
SVGA COLOR
KEY BOARD
:
108 KEYS
MOUSE
:
LOGITECH
FDD
:
1.44 MB
PRINTER
:
HP
B P C COLLEGE
21
BIDMALL ONLINE AUCTIONS
Software Requirements OPERATING SYSTEM
:
WINDOWS SERVER’00
WEB SERVER
:
IIS
ENVIRONMENT
:
MICROSOFT .NET MICROSOFT .NET FRAME WORK [.NET assemblies, XML,Web Services, WindowsServices, Web User Controls, ADO.NET, Mobile Applications]
FRONT END
:
ASP .NET
SCRIPTING
:
VB.NET
BACKEND
:
MICROSOFT SQL SERVER 2005
BROWSER
:
INTERNET EXPLORER 6.0
B P C COLLEGE
22
BIDMALL ONLINE AUCTIONS
SYSTEM DESIGN
B P C COLLEGE
23
BIDMALL ONLINE AUCTIONS
5. SYSTEM DESIGN DESIGN is the process of applying various techniques and principles for the purposes of defining a device ,a process on a system in sufficient detail to permit its physical realization. It is a process through which requirements are translated into a representation of the software. Software design is the technical kernel of the software engineering process and is applied regardless of the development paradigm that is used. From a project management point of view software design is conducted in two steps. Preliminary design is concerned with the transformation of requirements in to data and software architecture. Detail design focuses on refinement to the architectural representation that lead to detail data structure and algorithmic representations for software. System design involves translating information requirements and conceptual design into technical specification and general flow of processing. After considering the requirements of the firm, needs are identified, related information is gathered to verify the problem and after evaluating the existing system, a new system is proposed. The proposed system consists of various modules , their maintenance works and finally report generation. For the Replicated data processing environment using the .Net framework in WindowsXP, developing an efficient system , which is user friendly as well as high in performance , is the main aim. It has been assured that the system will have the functions and promises of the proposed system. In the design phase , various techniques are used to present a simple but efficient environment.
B P C COLLEGE
24
BIDMALL ONLINE AUCTIONS
5.1 DATA FLOW DIAGRAMS Data flow diagram (DFD) is used to show how data flows through the system and the processes that transform the input data into output. Data flow diagrams are a way of expressing system requirements in a graphical manner. DFD represents one of the most ingenious tools used for structured analysis. It is also known as a bubble chart. In the normal convention, logical DFD can be completed using only four notations.
: Represents source or destination of data
: Represents data flow
: Represents a process that transforms
Incoming data into outgoing data
: Represents data source
B P C COLLEGE
25
BIDMALL ONLINE AUCTIONS
The DFD at the simplest level is referred to as the ‘CONTEXT ANALYSIS DIAGRAM’. These are expanded by level, each explaining its process in detail. Processes are numbered for easy identification and are normally labeled in block letters. Each data flow is labeled for easy understanding.
CONTEXT LEVEL Entering Products Details
Auctioneer/Bidder
Auctioneer/Bidder
Bidding the Product
B P C COLLEGE
BidMall Auctions
26
BidMall Auctions
BIDMALL ONLINE AUCTIONS
LEVEL ONE UserInfo
LogIn
ProductInfo
Eddsdsd
BidInfo
User/Auctioneer
User/Auctioneer
Eddsdsd
BidInfo Eddsdsd UserInfo
PaymentInfo Eddsdsd BidInfo ProductInfo Eddsdsd
B P C COLLEGE
27
BIDMALL ONLINE AUCTIONS
LEVEL TWO
UserInfo Log In UserInfo View Product Details
ProductInfo ProductInfo
Bidding
Receiving Mail From Owner
PaymentInfo BidInfo
Payment
B P C COLLEGE
28
BIDMALL ONLINE AUCTIONS
5.2DATABASE DESIGN The database is a collection of stored data organized in such a way that all the data requirements are satisfied by the database.. How data are organized depends on the data and response requirements that determine hardware configurations. An integrated approach to file design is the database. The general theme behind a database is to handle information as an integrated whole. Database is a collection of inter-related data store together data with controlled redundancy to serve one or more application. In a database environment common data are available to the users. A program now requests the data through database management system (DBMS), which determines the data sharing. General objectives are to make information access easy, quick, efficient, inexperience and flexible for the user. Several specific objectives are ease of learning, data independence, integrity and recovery from failure, privacy and security, performance. In a database environment, Database Management System (DBMS) is the software that provides the interface between the data file on disk and the program that requires processing. Although all DBMSs have a common approach to data management, they differ in the way they structure data. The three types of data structure are hierarchical, network and relational. Here we use relational structuring in which all data and relationships are represented in a flat, two-
B P C COLLEGE
29
BIDMALL ONLINE AUCTIONS
dimensional table called a relation. A relation equivalent to a file, where each line represents a record. Data structuring is refined through a process called normalization. Data are grouped in the simplest way possible so that later changes can be made with a minimum of impact on the data structure. The following is a listing of tables used in BidMall OnlineAuction Site:
1. UserInfo The information of the users who are registered is stored in this table. An entry is made during registration. Each user has a unique entry. Field Names
Data Types
Size
Description
UserId FirstName
int nvarchar
16 50
Id of user First Name of
50
user Last Name of
LastName
nvarchar
Password
nvarchar
50
user Password of
phone
nvarchar
50
user Phone number
Email
nvarchar
50
of user Email Id of
Address
nvarchar
200
user Address Of User
2. CategoryInfo CategoryInfo table stores different types of categories. It includes category name & category id.
B P C COLLEGE
30
BIDMALL ONLINE AUCTIONS
Field Names
Data Types
Size
Description
CategoryId CategoryName
int nvarchar
8 50
Id of category CategoryName of Product
3. BidInfo BidInfo table stores the details of all the bidding. An entry is made during an item bid by any registered user.
B P C COLLEGE
31
BIDMALL ONLINE AUCTIONS
Field Names BidInfoId
Data Types int
Size 8
Description Id Of each Bid
Productid ProductName Bidvalue BidderId UserId ExitDt
int nvarchar money int int datetime
8 50 8 8 8 8
Id of product Name of Product Bid Amount Id of bidder Id of User Date & time when auction of
despatchdate
datetime
8
product ends Date & Time when Product is
Receiveddate
datetime
8
send to Winner Date & Time when Product is received by
Confirmation
bit
1
Winner Confirming whether productis
Paid
bit
1
received Checks whether
4. ProductInfo Product table stores the details of all the products that are kept for auction. An entry is made during an item place for an auction. Field Names ProductId ProductName CategoryId
B P C COLLEGE
Data Types int nvarchar int
Size 8 50 20
32
Description Id of product Name of product Company of
BIDMALL ONLINE AUCTIONS
StartindBidvalue money Bidvalue AuctionInterval
money int
8
product Starting Bid
8 8
Amount Bid Amount No.of days the product is kept for
EntryDt
datetime
8
auction Date&Time the product kept for
UserId BidderId Description Image
int Int nvarchar nvarchar
8 8 500
auction Id of User Id of Bidder Details About
50
Product Image url of product
5. PaymentInfo In PaymentInfo all the payments will be stored. Field Names
Data Types
Size
Description
IssueNumber BidId UserId CreditCardNumber CreditCardType TotalAmount
int int int varchar varchar int
8 8 8 20 50 8
IssueNumber Id of each bid Id of User Number of Creditcard Type of Creditcard Highest Bid Amount
5.3 INPUT & OUTPUT DESIGN INPUT DESIGN
B P C COLLEGE
33
BIDMALL ONLINE AUCTIONS
Input design is a part of overall design, which requires careful attribute. Inaccurate input data are the most common cause of errors in data processing. Errors entered by data entry operators can be controlled by input design. Input design is the process of converting user-originated inputs to a computer- based format. This input to the system is provided through ASP.Net. The goal of designing input data is to make data entry as easy, logical and free from errors. In the system design phase input data are collected and organized in to groups of similar data. The expanded data flow diagram logical data flows, data sources, data stores and destination. Input design input data and source documents. Source data are captured initially. A source document should be logical and easy to understand. It should be clearly identified and should specify for the user what to write and where to write it. Source data are input into the system using input media and devices.
OUTPUT DESIGN Computer output is the most important and direct source of information to the user. Efficient, Intelligible output design improves the system’s relationship with the user and helps in decision-making. Output design is very important phase because the output will be in an interactive manner. The output will be in such a way that the user can see it from the screen and can take a hard copy from the printer. To make a user- friendly output and for better communication the programmer can use the features of a window. Efficient, Intelligence output design improves the system’s relationship with the user and help in decision-making. A major form of the output is a hard copy from the printer. Printouts should be designed around the output requirements of the user.
B P C COLLEGE
34
BIDMALL ONLINE AUCTIONS
1. MainPage
B P C COLLEGE
35
BIDMALL ONLINE AUCTIONS
2.LogIn
B P C COLLEGE
36
BIDMALL ONLINE AUCTIONS
B P C COLLEGE
37
BIDMALL ONLINE AUCTIONS
3. UserEntry
B P C COLLEGE
38
BIDMALL ONLINE AUCTIONS
4.UserEntry
B P C COLLEGE
39
BIDMALL ONLINE AUCTIONS
5.ProductEntry
B P C COLLEGE
40
BIDMALL ONLINE AUCTIONS
6. ImageUpload
B P C COLLEGE
41
BIDMALL ONLINE AUCTIONS
7. ImageUpload
B P C COLLEGE
42
BIDMALL ONLINE AUCTIONS
9. Bidding Page
B P C COLLEGE
43
BIDMALL ONLINE AUCTIONS
9. Product Details
B P C COLLEGE
44
BIDMALL ONLINE AUCTIONS
10. Bidding Page
B P C COLLEGE
45
BIDMALL ONLINE AUCTIONS
11. Bidding Page
B P C COLLEGE
46
BIDMALL ONLINE AUCTIONS
12. Bidding Page
B P C COLLEGE
47
BIDMALL ONLINE AUCTIONS
13. Contact Information
B P C COLLEGE
48
BIDMALL ONLINE AUCTIONS
14. Contact Information
B P C COLLEGE
49
BIDMALL ONLINE AUCTIONS
15.Transaction Page
B P C COLLEGE
50
BIDMALL ONLINE AUCTIONS
16.Transaction Page
B P C COLLEGE
51
BIDMALL ONLINE AUCTIONS
17. Payment Page
B P C COLLEGE
52
BIDMALL ONLINE AUCTIONS
SYSTEM TESTING
B P C COLLEGE
53
BIDMALL ONLINE AUCTIONS
6. System Testing System testing is defined as the process by which one detects the defects in the software. Any software development organization or team has to perform several processes. Software testing is one among them. It is the final opportunity of any programmer to detect and rectify any defects that may have appeared during the software development stage. Testing is a process of testing a program with the explicit intention of finding errors that make the program fail. In short system testing and quality assurance is a review in software products and related documentation for completion, correctness, reliability and maintainability. System testing is the first stage of implementation, which is aimed at ensuring that the system works accurately and efficiently before live operation commences. Testing is vital to the success of the system. System testing makes a logical assumption that if all the parts of the system are correct the goal will be successfully achieved. A series of testing are performed for the proposed system before the system is ready for user acceptance testing. The testing steps are: Unit testing Integration testing Validation Output testing User acceptance testing
B P C COLLEGE
54
BIDMALL ONLINE AUCTIONS
Unit Testing This is the first level of testing. In this different modules are tested against the specification produces during the design of the modules. Unit testing is done during the coding phase and to test the internal logic of the modules. It refers to the modules. It refers to the verification of single program module in an isolated environment. Unit testing first focuses on the modules independently of one another to locate errors. After coding each dialogue is tested and run individually. All necessary coding where removed and it was ensured that all the modules are worked, as the programmer would expect. Logical errors found where corrected. So, by working all the modules independently and verifying the outputs of each module in the presence of staff we conducted that the programs was functioning as expected.
Integration Testing Data can be lost across an interface: one module can be adverse effort on another; sub functions when combined may not produce the desired major functions. Integration testing is a systematic testing for constructing the program structure. Conducting the tests is to uncover errors associated within the interface. The objective is to take unit tested to modules and build a program structure. All the modules are combined and tested as a whole. Here correction is difficult because the vast expenses of the entire program complicate the isolation of causes. Thus in the integration testing step, all the errors uncovered are corrected for the next testing steps.
B P C COLLEGE
55
BIDMALL ONLINE AUCTIONS
Validation Testing This provides the final assurance that the software meets the all the functional, behavioral and performance requirements. The software is completely assembled as a package. Validation succeeds when the software functions in a manner in which user wishes. Validation refers to the process of using software in live environment in order to find errors. During the course of validation the system failure may occur and sometime the coding has to be hanged according to the requirement. Thus the feedback from the validation phase generally produces changes in the software. Once the application was made of all logical and interface errors, inputting dummy data ensured that the software developed satisfied all the requirements of the user. This dummy data is known as test case.
Output Testing After performing the validation testing, the next step is output testing of the proposed system since no system could be useful if it does not produce the required output in the specific format. Asking the users about the format the required by them, tests the output generated or considered into 2 ways. One is on screen and another is printed format. The output format on the screen found to be correct as the format was designed in the system design phase according to the user needs. For the hard copy also, the output comes out as the specified requirement by the user. Hence output testing does not result in any correction in the system.
B P C COLLEGE
56
BIDMALL ONLINE AUCTIONS
User Acceptance Testing Acceptance test refers to the acceptance of data into the system for processing. The acceptance test contributes to the consistency and smooth working of the system. The system under consideration is tested for users at a time of developing and making changes whenever required. This is done with regard to the following points: Input screen design Output screen design On-line message to guide the user Format of ad-hoc report and other outputs. Taking the various kinds of test data does the above testing. Preparation of test data plays a vital role in the system testing. After preparing the test data the system under study is tested using that test data. While testing the system by using test data errors are again uncovered and corrected by using above testing steps and correction are also noted
for future use.
Test Results The knowledge about the test results is necessary to make further modifications. The following are the test results.
Program testing revealed that the program is free from syntax and logical
errors. The output where found correct.
String testing revealed that all the modules of the system works properly
under peak loads and the system is capable of handling as many records.
Acceptance test refers to the acceptance of data into the system for processing.
This acceptance test contributes to the consistency and smooth working of the system.
B P C COLLEGE
57
BIDMALL ONLINE AUCTIONS
IMPLEMENTATION
7. IMPLEMENTATION
B P C COLLEGE
58
BIDMALL ONLINE AUCTIONS
Implementation is the stage in the project where the theoretical design is turned into working system and is giving confidence on the new system for the users that it will work efficiently and effectively. It involves careful planning,
investigation
of
the
current
system
and
its
constraints
on
implementation, design of methods to achieve the change over, an evaluation of change over methods. Apart from planning major task of preparing the implementation are education and training of users. The more complex system is being implemented, the more involved will be the system analysis and design effort required just for implementation. An implementation co-ordination committee based on politics of individual organization has been appointed. The implementation process begins with preparing a plan for the implementation of the system. According to this plan, the activities are to be carried out, discussions made regarding the equipment and resources and the additional equipment has to be acquired to implement the new system. Implementation is the final and important phase. The most critical stage in achieving a successful new system and in giving the user’s confidence that the new will work be effective. The system can be implemented only after through testing is done and if it found to working according to the specification. This method also offers the greatest security since the old system can take over if the errors are found or inability to handle certain type of transactions while using the new system.
B P C COLLEGE
59
BIDMALL ONLINE AUCTIONS
SECURITIES & MAINTENANCE
8. SECURITIES AND MAINTENANCE
B P C COLLEGE
60
BIDMALL ONLINE AUCTIONS
Maintenance involves the software industry captive, typing up the system resources. It means restoring something to its original condition. Maintenance involves a wide range of activities including correcting, coding, and design errors, updating documentation and test data and upgrading user support. Maintenance is continued till the product is re-engineered or deployed to another platform. Maintenance is also done based on fixing the problems reported, changing the interface with other software or hardware enhancing the software. Any system developed should be secured and protected against possible hazards. Security measures are provided to prevent unauthorized access of the database at various levels. An uninterrupted power supply should be so that the power failure or voltage fluctuations will not erase the data in the files.
Threats to System’s Security The lists of potential threats are Disgruntled and dishonest users Fire Errors and omissions Natural disasters External attacks
System Security Measurements
B P C COLLEGE
61
BIDMALL ONLINE AUCTIONS
Identification It is scheme for identifying persons to the system based on ‘something you know’ such as password. In the Auction Site, both the auctioneer and the bidder are given passwords for identification purpose during registration process. Access Control Controlling access to computer databases is essential. In the Auction Site only the administrator has given the access to the tables. Audit Control Auditing must be supported at all levels of management. Audit controls protect system from external security breaches and internal fraud or embezzle men. Various software programs are available to help in the audit function. System Integrity This line of defense safeguards the functioning of the hardware, software, physical security and operating procedures. Proper backup of hardware and software are extremely important. Password protection and simple procedures to change the unauthorized access are provided to the users. The system allows the user to enter the system only through login.
B P C COLLEGE
62
BIDMALL ONLINE AUCTIONS
FUTURE ENHANCEMENT
B P C COLLEGE
63
BIDMALL ONLINE AUCTIONS
9. FUTURE ENHANCEMENT Today internet has become part of human life. It bridges the gap between people and brings the world within the range of mouse click. Purchasing different items online, giving advertisements, assessing updated new are some of the attractions of the internet. Auction Site is a sincere effort to develop an online purchasing center for individuals and businesses for the items of their choice. In this system is has been tried to solve the problems of the existing systems. Also since it has been developed on ASP.Net, it is platform independent. We make it quick and easy for individuals and businesses to buy and sell their products, all without expensive marketing costs.
B P C COLLEGE
64
BIDMALL ONLINE AUCTIONS
CONCLUSION
B P C COLLEGE
65
BIDMALL ONLINE AUCTIONS
10. CONCLUSION This project was successfully completed within the time span allotted. All the modules are tested separately and put together to form the main system. Finally the system is tested with real data and everything worked successfully. Thus the system has fulfilled the entire objective identified. The system had been developed in an attractive dialog fashion. So user with minimum knowledge about computers can also operate the system easily to conclude this, we thank all people who help us to complete this project successfully.
B P C COLLEGE
66
BIDMALL ONLINE AUCTIONS
BIBLIOGRAPHY
B P C COLLEGE
67
BIDMALL ONLINE AUCTIONS
11. BIBILIOGRAPHY BOOKS ASP.NET
Chris Hart, John Kauffman, David Sussman, Chris Ullman: Beginning ASP.NET 2.0
SQL SERVSER
Inside Microsoft SQL Server 2000 (With CD-ROM) by Kalen Delaney.
Professional SQL Server 2000 Programming by Rob Vieira.
Microsoft SQL Server High Availability. By Paul Bertucci; ISBN:
0672326256; Nov 5, 2004 ... URLs www.ebay.com www.microsoft.com
B P C COLLEGE
68