TITLE - ONLINE AUCTION AUCTION
TITLE OF THE PROJECT ON LINE AUCTION
1
TITLE - ONLINE AUCTION AUCTION
INTRODUCTION Online Auction Auction is known by several names, including ‘electronic reverse bid Auctions’, ‘reverse auctions’ or simply ‘e-Auctions’. Online auction is a group which is based for auction. If you want to something sell by auction then you post that on website. It ust a selling of products in this proect user can do a bid on particular !roducts. "he main obective of the e-Auction process must be to obtain best value and the highest price. It cannot be possible to achieve best value outcomes whilst the focus remains on price. "here are two categories of users one is customers and second one is vendor. #e #endor can sell his products on this website and customer will purchase it. !roduct will be given to those customer who put a high bid price on product to purchace.one user can do a more than one bid on product. "here are two categories of users one is customers and second one is vendor $oth have their own registration form ."here is a common login page for vendors and for users but when both login in, it would be easily find out that %ither it is a vendor or abuser because of their registration details because their registration forms are different. "here are two home page i.e. one page behave different if vendor login then show the vendor’s menu or if customer will login then customer menu will show. &ustomers should have an appropriate knowledge
2
TITLE - ONLINE AUCTION of the online- Auction subect, its market, its market price. In this website anyone wants to sell products will have to register first then a uni'ue id is given to the registered users. After registered user have to give details of their products like (price of product ,at what price he)she wants to start the bid, image of the product* if he)she wants to sell his)her product .
3
TITLE - ONLINE AUCTION OBJECTIVE OF THE PROJECT
"he main obective of this proect is as follows +. "his portal gives selling)purchasing of product online. . Any user have both type i.e. vendor and customer. If he)she sells the product then he)she is vendor and if he)she purchases the product then he)she is the customer. . "his website has bid history. . "he user can see the bid history. /. In this, there is a feedback from. If the user wants to give some feedback, he)she fill this form.
4
TITLE - ONLINE AUCTION PROJECT CATEGORY RDBMS s t andsf orRel at i onDat abaseManage mentSys t em.TheRDBMS i sr e spons i bl ef or : 1. )Mai nt ai ni ngt her el at i onshi psbet weendat ai nt hedat abase. 2. )Ensur i ngt hatdat ai sst or ed corr ect l y-t hatt her ul esdefini ng t her e l at i o ns hi psbe t we e ndat aar eno tv i o l at e d. 3. )Recover i ngal ldat at oapoi ntofknownconsi st encyi nt heevent ofas y s t e mf ai l ur e 4. )RDBMS al so pr ovi des r ef er ent i al i nt egr i t yi . e. Pr i mary Key For ei gnKeyandUni queKey For ei gnKey . SQLServ eri sdesi gnedt obeacl i entserversyst em.Cl i entserv ersys t ems ar econst r uct ed sot hatt hedat abasecan r esi deon a cont r olcomput er knownasaServerandbeshar edamongse v er aluse r s.
SQL Ser v er can wor k wi t h t housands of cl i ent appl i cat i ons si mul t aneousl y .
5
TITLE - ONLINE AUCTION
Tr ans act SQL: -
SQL Ser v eruserTr ansac t SQL asi t sdat abasequer yand pr ogr ammi ng l anguageSQL i sa se tofcommandst hatal l owst heuse rt ospeci f yt he i nf or mat i ont ober et r i ev edormodi fiedwi t hTr ansactSQL.Wecanacces s dat aandquer y ,updat eandmanager el at i onaldat abasesy st em.
6
TITLE - ONLINE AUCTION
DATA FLOW DIAGRAM A 0ata flow diagram (010* is used to e2press system re'uirements in a graphical form. It is also known as a bubble chart. A 010 depicts information flow and transform that are applied as data moves from input. 3se of 010 helps to clarify the system re'uirements. 010 are drawn surging analysis and are the starting point for the design phase. A 010 could be used represent a physical system, at the beginning of analysis, or a logical system at alter point in the system development life cycle. $eing graphical, it is easy to understand.
A 010 is used to describe what data flows rather how if flows. "he concern is understanding the transforms that are re'uired that are re'uired to convert the input to output. It is independent of hardware, software, data structure and file organi4ation.
7
TITLE - ONLINE AUCTION
&O5"67" 1866 0IA98A:
Online Auction
Bid Mn!e"ent
User Auction Mn!e"ent
#
TITLE - ONLINE AUCTION ;6#6; --+ 010 3ser :anagement
#endor
3sername master
3ser details
3ser
Auction master
Auction master Auction :anagement
Auction 0etails
Auction "ype
$id master
$id
$id :aster
:anagement $id 0etails
&hat :anagement
$
TITLE - ONLINE AUCTION ;6#6; -- 010 3sername master Accept
3ser 0etails
&hecks
&hecks Access
3ser :anagement
&heck 5ew 3ser 62istence
Is It #endor or &ustomer
#endor
3ser
&ustomer
5ew 3ser
%tore
Usern"e Mster User 'etils
1(
&
TITLE - ONLINE AUCTION
3ser
)isi*le
Auction Mster
Access Interct
Auction T+,e etrie.e
Auction :anagement
Auction "ype
&reate Auction
Auction Mster & Auction 'etils
11
TITLE - ONLINE AUCTION
Bid Mster
&ustomer
)I%IBLE
INTEACT
$id :anagement
&reate $id
/u t
Bid Mster & 'etils
12