Mysql query and table design

In Progress Posted 5 years ago Paid on delivery
In Progress 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.

HTML JavaScript MySQL PHP Software Architecture

Project ID: #18705989

About the project

21 proposals Remote project Active 5 years ago

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
(1 Review)
1.4

21 freelancers are bidding on average $159 for this job

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. More

$150 USD in 1 day
(363 Reviews)
8.1
liveexperts123

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 More

$155 USD in 3 days
(57 Reviews)
7.0
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 More

$180 USD in 5 days
(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
(133 Reviews)
6.2
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 More

$150 USD in 3 days
(34 Reviews)
6.2
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 hel More

$133 USD in 3 days
(72 Reviews)
6.4
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 More

$30 USD in 1 day
(38 Reviews)
5.7
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
(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 c More

$125 USD in 4 days
(21 Reviews)
4.9
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
(9 Reviews)
4.6
mikenru1

Hi! actually, normal approach is to put such logic in your backend, not in database. But this can be done on database for sure. Let's discuss details in chat

$100 USD in 3 days
(13 Reviews)
3.9
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 More

$277 USD in 3 days
(7 Reviews)
2.8
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 Reviews)
2.8
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
(1 Review)
0.0
marlboro112

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

$277 USD in 10 days
(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 ch More

$166 USD in 3 days
(0 Reviews)
0.0