database design

_Database design_ _Brief introduction about the website:_ An online community website for my town where people can advertise their cars for sale, property for rent or sale, house share or rooms to let advertisements it should also include adds for services being offered in the area and also jobs in the area and one section for stuff for sale and dating in the area. _Database function required: _1. A search menu: I require a search feature which function within the database and will search within the data base with the relevant category for example if some one comes and write the name of the make of the car and then presses the search button and then it will display all the results it has found with required name and will show all the adds that are posted with this name in a list format. 2. Form Function: It should include a form function where a user can come and if he or she wants to place an advert on the website he can do so just by filling in the form for the category and then pressing the submit button and the information will be sent to database and will also be displayed with in the list format if anybody searches with in the category of that item for which the advert is placed. 3. Remembering the visitors: It should include a special function where it provide a unique reference number for every advert placed on the website and if the user want to edit or delete the advert of if he just want to view the advert he can do so by simply putting in the unique reference number. All three functions will be connected to buttons or links on the main page for place an advert, manage my adverts and my saved adverts. I will also require some dynamic design features on the place and adverts page where the categories are automatically shown to sub-categories when placing the advert. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform the website should be accessible on all major platforms