Mysql query and table design

$30-250 USD

In Progress

Posted

over 5 years ago

$30-250 USD

Paid on delivery

Hi, I am looking to create a table in MySQL that calculates the balance (with fixed interest rate) for each user. there are expected to be more than 1 million customers and they will be allowed to withdraw and deposit continuously. 1. Users will have to keep the deposit untouched (no withdrawer) for 90 days (balance_nowithdraw) - interest rate (say 10%) and days (90 days)fixed so the final number here will be known 2. Some users will be want to with draw before 90 days is over (balance_withdraw) - interest rate (say 5%) is fixed but day is not fixed (this interest will accumulate daily) and then there will be a penalty for early withdrawer 3. There is also an option where there is no interest, just add deposit and subtract withdrawer. let me know if you can help design a table or tables that can do this.

Software Architecture

Project ID: 18705989

About the project

20 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@AGholaminezhad

Hello. I have excellent knowledge of MySql and Table design for businesses. I have Mysql db with almost 300,000,000 records working right now. it would be my great pleasure to work with you.

$111 USD in 3 days

5.0

(1 review)

1.4

20 freelancers are bidding on average $162 USD for this job

@sergioeliot3

Hi there. Thanks for using freelancer com. My name is Sergio and I am dedicated 100% on the website. I help help you create a design for the tables required to handle de data that you specified. I also can help creating a computing procedure in the database that can do this calculation, if this isn't already in place. I am seasoned in database development including MySQL, SQL Server, Oracle PL/SQL, and Postgrest. When can you ping me to get started? Best regards, Sergio Eliot Rodríguez Wong Software developer

$133 USD in 3 days

4.8

(77 reviews)

10.0

@liangjongai

Hello, sir I am Mysql query developer. I have a detail look to your project, I have a great skill in database design. My motto is to provide high quality work and client satisfaction delivered before your deadline. Thanks.

$150 USD in 1 day

4.9

(366 reviews)

8.1

@LiveExperts

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .

$155 USD in 3 days

4.8

(89 reviews)

7.9

@sodiqa32

I have gone through your project details "create a table in MySQL that calculates the balance (with fixed interest rate) for each user. there are expected to be more than 1 million customers and they will be allowed to withdraw and deposit continuously"Looking for a candidate that is extremely familiar with the responsibilities associated with the role and can perform them confidently? Experience in the full skills

$30 USD in 1 day

4.8

(65 reviews)

6.6

@ludwig333

Hi. I am a full stack developer and have been working for over 5 years on the freelancer.com. I have read your description in detail and have interests in your project. I have some experiences that have ever done what is similar to your project. As a solution, I have a good idea to build your project perfectly I would like to have a discussion with chat to get more about your project. Thanks.

$180 USD in 5 days

4.8

(64 reviews)

6.3

@softcarve

Hi, I would like to design the table structure to store the withdraw and deposit by each user. Available for discussion and ready to start now. Regards, Manish

$150 USD in 8 days

4.9

(133 reviews)

6.3

@fleedsteed

Hello I read your job description carefully and understand what you want. As you can see in my portfolio, I am an experienced MySQL/SQL Query expert. I have built databases and tables similar to yours before. I can surely help you. Please INITIATE chat. Regards.

$150 USD in 3 days

4.7

(34 reviews)

6.3

@Valuesolutions

I believe that my experience and skill in this background will prove to be of great help to you. Contact me to discuss more on the details

$150 USD in 3 days

4.2

(18 reviews)

5.6

@MichealSMoreno

Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting for your reply. Regards.

$150 USD in 3 days

4.6

(35 reviews)

5.0

@nbeslie

Hello, I am interested in your project. I can design and create your database tables plus custom db functions to calculate and check the values in accordance to all your requirements. If you are interested please contact me for the details. Here is my relevant skill set: -Undergraduate degree in computer science and engineering -Experience in C++/Java/C# -5 years of experience in web development -3 years of experience as DB admin (Oracle,PostgreSQL,MySQL) cheers.

$125 USD in 4 days

4.9

(21 reviews)

4.9

@sreenivas2903

Hi i am expertise i. Sql querying .i would like to work on this please let us have fee more inputs so that we would freeze specs and strt working i will do what u need ping me for more information

$200 USD in 3 days

4.4

(4 reviews)

3.1

@gmsltn1

Hi, I have read your job post very carefully. Thank you for this wonderful opportunity. I am very interested to this project. I believe my abilities would be perfect for your venture. I can finish this job within the necessary time frame. I am professional full stack website web developer in WordPress & PHP raw coding, PHP Framework. I have 4+ years of experience in this field. I have also expert in HTML5,Bootstrap,React.js, node.js, React Native, codeigniter,CSS3,Java Script, Jquery. Regards, Golam M

$277 USD in 3 days

3.7

(9 reviews)

3.3

@NimainG

Hello, I can make table and functions in mysql 8 or mysql 5.x . I can make logic and dependencies with the keys. For details we can discuss and proceed. Thanks

$200 USD in 2 days

0.0

(1 review)

2.6

@marlboro112

We will need creat database table design together. Relevant Skills and Experience Mysql, mssql

$277 USD in 10 days

0.0

(0 reviews)

0.0

@Kawi9027

Hello Sir, I have gone through your project details, I will develop the database as per your requirements. *Please consider me for this project, I will give you quality work.* For further discussion lets talk in chat. looking forward to hear from you. Regards Kawish

$166 USD in 3 days