The project needs to be implemented in asp.net 2.0 C# or VB using sql server 2005 1. Project Title On-line Car Auction 2. Aim of the Project The aim of the project is to design and implement a database system for an on-line auction to sell luxury cars submitted by vendors to the site. The system needs to manage details of vendors, bidders and the cars to be sold at the auction as well as logging the current status and history of the bidding process. Background Information CarMart is a car auction company based in Letchworth. They wish to expand their current enterprise by starting a purely web-based division of the company, eCarMart, which will operate independently of the parent company. The directors are particularly concerned about the usability of the site from both the bidders’ and the vendors’ point of view and have identified, for example, that it may be important to enable some form of dialogue between bidder and vendor should any questions need to be asked regarding the sale of a car. They would like the bidding process to be as autonomous and as automated as possible, but would like a summary of the day’s activities to be emailed to them every evening so that they can keep a firm grip on the business. Neither vendors nor bidders can enter the auction process until they have registered with CarMart. Additionally, bidders cannot enter the auction without first placing a deposit (deposits can be laid and purchases can be paid for by either cash or cheque). Vendors can only be paid by cheque from the CarMart account.
## Deliverables
The prototype system should be implemented using a database tool that will adequately support all the functionality required. It should be provided with an administration interface suitable for use by eCarMart staff (the requirement here is that the staff can use the system with the help of the user manual and half a day’s training) and a public (web) interface allowing vendors to submit cars for sale at auction and buyers to bid for those cars. The system should allow for the varying levels of access to the data required by the administration staff and by the public web user. There are examples of on-line auction sites of various kinds (such as [login to view URL]) on the World Wide Web and it would be useful to investigate the functions these sites provide for users and to think about their reasons for doing so. The directors would like the developer to research other auction sites (both their competitors in the on-line car auction sector and other sites) to investigate what degree of functionality may be required, with reasons, to produce a good, solid working system within the timescale. They are particularly concerned about the suitability and robustness of the database and its interface, and are anxious that the public should find the site secure, easy and enjoyable to use. Examples of areas where the directors are undecided and need direction are how best for a user to search the data for cars, what information should be displayed on the site (for example the reserve price) or how, and if, buyer and vendor should communicate with each other (amongst a host of other undecided areas!). Additionally, they would like to see how the initial system proposed within the document could be developed in the future to produce a more sophisticated site. The directors have outlined their initial thoughts in sections 4.2 to 4.5 below. 4.2 Recording of Vendor/Buyer Details and updating of those records Vendors and Buyers need only register once - their details are kept on file and updated manually as required. 1)Design and implement a database for the eCarMart Auction site, with provision for its administration, having undertaken a requirements analysis. Enable a valid record to be input and be stored in the database (not images). Ensure that empty fields default,appropriate. Populate the database with appropriate sample data via a web interface (suggested 5 Vendors, 5 Buyers and 20 Cars). You should take care to ensure that data is appropriate for the project tasks. 2)Implement and test a simple model of the on-line bidding system. 3)Implement a simple password system to protect vendor and buyer information. 4)Create a database interface to allow eCarMart staff to retrieve financial and statistical information. 5)Upgrade the password system to allow for this access by eCarMart staff. 6) Upgrade the on-line bidding system to include embellishments such as bidding history, time left before bidding ceases etc. 7)Implement a search to a car that fits certain criteria entered by the user (such as make, model, price etc.) Allow the staff to have access to these extra statistics via the database interface. 8) Upgrade the password system to include initial authentication of users and a mechanism for retrieving forgotten passwords. •9)Research and implement protection of the integrity of the database in the face of concurrent user access to it, through the use of transaction management/transaction processing. 10)Implement a sophisticated model of the on-line bidding system that includes features such as automatic emailing of vendors every time a bid is received for their car and emailing of bidders once their bid has been surpassed.
## Platform
ASP.net 2.0 C# or VB using sql server 2005