ebay unwired SQL project
$495-500 USD
Pagado a la 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.
Nº del proyecto: #3882709
Sobre el proyecto
2 freelancers están ofertando un promedio de $425 por este trabajo
