Find Jobs
Hire Freelancers

SQL Table Editor/Calculation

$30-250 USD

Cancelled
Posted over 7 years ago

$30-250 USD

Paid on delivery
Attached is a mock-up of the UI. The aim is to create a GUI for creating new fields in an SQL database based off existing ones through mathematical calculations. These calculations would be scheduled to run regularly so that new data entered would have this calculation applied. Two main functions: - Find and replace. Create a set of rules to recode into a new field. o This should support four kinds of rules ♣ Simple numeric swap (eg. 2=3) ♣ Through to lowest (eg. If less then 1 = 2) ♣ Through to highest (eg. If greater than 1 = 3) ♣ All other values (eg. any value not changed by an existing rule = 4) - Calculations. Create a set of rules that mathematically alters an existing field and inserts into a new field. This may pull use multiple existing fields and multiple mathematical operations (eg. Var1+Var2/2) o These calculations should include: ♣ Add, subtract, divide, multiply, minimum, maximum, mean, frequency, mode, variance, standard deviation, range, absolute value & log10 Features: - Each rule should be run at scheduled intervals - Each rule should be capable of being re-loaded - GUI to connect to multiple SQL databases - Can add new tables & save newly generated fields to a table of the users choice. - The ability to save them and reload rules for editing - Lists recent fields used for quick selection - Autocomplete & suggest variable names in search boxes - A preview window to see the active table, with the ability to search in any field
Project ID: 12021390

About the project

7 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $196 USD for this job
User Avatar
Hello Good Day I am a graduate of Mathematics and Computer Science. I just went through your requirements and it is pretty clear for me. I had a look at the mockup too. I can do this project for you . Looking forward to work with you in this project. Thanks Rinsad
$250 USD in 5 days
4.9 (1089 reviews)
8.9
8.9
User Avatar
Hello.. I have seen the details and I understand most of the detials/rules you have defined. However, I am not sure if you are referring to SQL SERVER or MYSQL. I think you have chosen PHP and MYSQL, so the database will be in MYSQL. Please confirm. I think we can provide an interface wtih HTML/PHP on top of MYSQL database. I am interested to see if we can discuss and move forward. Tx
$200 USD in 3 days
4.9 (638 reviews)
8.8
8.8
User Avatar
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$237 USD in 10 days
4.9 (468 reviews)
8.2
8.2
User Avatar
Hello, I am so glad to bid your project. I fully understood your requirement and all features are well known for me I have full experiences of developing php apps for sql. I would like to discuss about more details with you. Best regards.
$255 USD in 3 days
5.0 (13 reviews)
7.2
7.2
User Avatar
sir, I provide you exact things what you actually need with minimum cost.
$30 USD in 1 day
5.0 (1 review)
1.8
1.8

About the client

Flag of AUSTRALIA
Sydney, Australia
4.5
22
Payment method verified
Member since Dec 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.