Create Db Schema From Spec (MySQL, SQL)

	Home \| How it works \| Projects archive \| Contact Us Air Compressor Bot
	The Career Path of Freelance Programming Jobs

Create Db Schema From Spec

Bidding Time:	03/04/2008 23:52 - 07/04/2008 00:52
Budget:	Maximum $100
Status:	Closed

Job Type:	MySQL, SQL
Description:	Please see the attached specification which describes in detail what each table and column should be. I need you to create a db schema in db designer from fabforce, or some other database modeling tool, as long as it doesn't cost a lot of money to buy. I want to see a schema from a visual perspective, which is why I need the schema instead of simply the create table statements (db designer will generate that for me). Here are the design/naming conventions for the database tables: 1. primary keys are named: id 2. the "name" or "title" column should always be named: name 3. table names are plural (judges) 4. foreign keys are singular with underscore and id: judge.contest_id (judges table and contests table - a judge belongs to one contest) 5. there should always be "created" and "modified" DATETIME fields at the end of the table 6. long text fields should have the datatype: text 7. all foreign keys must be indexed. hopefully the modeling software does this automatically when you create the relationships Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now. Related Projects: ProxyVent.com Redesign Relist Convert Psd Into Css Drupal Real Estate Website Javascript dynamic content scroll box New Website Developer-Candy Press Cart This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:	N/A
Database System:	N/A

<<< back

Recent Projects Archive:

Saturday - Friday - Thursday - Wednesday - Tuesday - Monday - Sunday

View all freelance web projects

Home | Projects archive | RSS | Resources | Links | Contact Us

© 2004-2008 ProjectsList.biz /0.443