ebay unwired SQL project

Encerrado Postado Oct 24, 2006 Pago na entrega
Encerrado Pago na entrega

We are using MySQL 5.0 and need to have a site "unwired". The site that we are looking to have unwired is ebay. We want SQL scripts for every table, constraint, trigger, ID, artificial key, etc. to totally reproduce ebay.

In addition to this, we also want screen shots of every page of every process that you can possibly access on the site EXCLUSIVELY FOR AUCTIONS only.

We are not interested in the ebay express or chat rooms or the like. Just the entire sites auction functionality. This must be very thorough and the scrips execute without error.

About the very thorough part, you will have to register as an ebay user, post something, etc. in order to obtain the screenshots of course.

The screenshots should be how you dictate table structure and too how you develop your login in assigning the foreign keys, constraints, whether you use INNODB or MyISAM tables, etc.

The complete package will arrive as listed below:

One giant SQL script that creates every database object in the plan and one giant PDF or Word file that contains all the screen shots with text boxes which point out which tables you are referencing.

Again, this must be complete and thorough as we are looking to make a very similar site. This isn't an exact replica of the site that we are building, but more of a template and a starting point for us.

All text must be named using the conventions below:

Table and all other object shall be named with an intuitive design and EVERY word spelled correctly in ENGLISH.

Tables are all prefixed with a T_tablename, triggers with TR_triggername, all of which use no plurals.

Example: T_user is correct, which T_users is incorrect. Only the first "designation" is capitalized, nothing else. As in TR_user_trim - NOT TR_User_TRIM.

Nothing should have _1, _2, _3, etc for naming. If you have multiple columns for instance, Address, they should be named, as a table, T_address, but the columns which are redundant, would be: address_first_line, address_second_line, etc.

All columns should be "correct" in terms of datatype. That means, a date column should be just that, not a VARCHAR. You should not have a DECIMAL for an ID column or artificial key column. An index should increase performance, otherwise it is omitted.

We should never have a situation where we cannot identify what is being described by the name.

## 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

We are running MySQL 5.x and need to have that syntax present.

Processamento de Dados Engenharia MySQL PHP Arquitetura de software Teste de Software Hospedagem Web Gestão de Site Teste de Website

ID do Projeto: #3882709

Sobre o projeto

2 propostas Projeto remoto Ativo em Nov 14, 2006

2 freelancers estão ofertando em média $425 nesse trabalho

ylideal

See private message.

$425 USD in 65 dias
(1 Comentário)
3.3
kalyanchatterjee

See private message.

$425 USD in 65 dias
(1 Comentário)
0.0