Project: MySQL Database Development- SynthWorld

Design and develop an MySQL database to manage data related to modular analog synthesizer modules.


Existing data resides in an Excel spreadsheet

Tables and Fields: Include the time necessary to work with client to identify and define database tables and fields

• Modules Table (approximately 1500 modules)

o Name

o Number from Manufacturer

o Master Module Number (Synthcube Master)

• Manufacturers Table (approximately 150 manufacturers)

o Name

o Contact Fields (web link, address etc)

• Formats Table (9 formats)

o Name

o Panel Dimensions

 Height

 Width

 Thickness

 Mounting Screw Hole Diameter

 Mounting Screw Size

 Mounting Screw Center- Distance from Sides

 Mounting Screw Center- Distance from Top/Bottom

o Power

 Voltages

 Connectors

 Pin Assignments (inc diagrams)

• Designers Table (approximately 50 designers)

o Name

• Types Table (approximately 30 types)

o Type Name

o Description

• Information Assets Table

o Panel images (.jpgs)- approx. 800 .jpg files

o Sketched panel images (.jpgs)- approx. 800 .jpg files

o FPE panel files (.fpds) – approx. 500 .fpd files

o Schematics (.pdfs)- approx.. 500 files

o Parts Lists/BOMS (.xls, .pdf files) approx.. 500 files

Relational Links Between Tables and Fields: Include time to build the necessary relationship definitions amongst tables and fields. Include the necessary time to consult with client to define, document and develop these links.

Reports (web templates): Produce a minimum of five reports and the supporting queries to generate web template page. Include sufficient time to design template reports with input from client.

Manufacturer Profile

Module Profile

Format Profile

System Profile


Queries: Include time to define and develop ten queries with input from client.

Revisions: Include two rounds of edits and refinements to table and field structure, relationships, reports etc

Conversion: Convert existing data from excel .xls file to new database fields

Ongoing Maintenance and Updates: Include up to 10 hours per month for ad-hoc requests, edits and changes, for a period of twelve months after delivery

Kemahiran: MySQL

Lihat lagi: web templates pdf, web panel templates, web master develop, web development & design templates, web development contact number, web development assignments, web design and development pdf, web database development, web consult, types of development web, types data structure, top 10 web design templates, project in web development, profile formats, profile designers, power design inc, name and address template excel, modules in web development, master in web system development, maintenance excel template, lists data structure, inc top, hoc web design, hoc design web, format web page designers

Tentang Majikan:
( 7 ulasan ) Concord, United States

ID Projek: #1570811

7 pekerja bebas membida secara purata $582 untuk pekerjaan ini


I look forward to discuss more about the project

$620 USD dalam 12 hari
(16 Ulasan)

Please check private message .

$750 USD dalam 15 hari
(24 Ulasan)

Please check your PMB for more info.

$500 USD dalam 15 hari
(38 Ulasan)

hello sir, check more details.

$750 USD dalam 25 hari
(6 Ulasan)

hello, i am ready to take this job

$250 USD dalam 2 hari
(7 Ulasan)

Dear Sirs , please check the PM.

$610 USD dalam 20 hari
(1 Ulasan)

did this types of works earlier

$595 USD dalam 15 hari
(0 Ulasan)