Mysql query and table design

En curso Publicado hace 5 años Pagado a la entrega
En curso Pagado a la entrega

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 Arquitectura de software

Nº del proyecto: #18705989

Sobre el proyecto

21 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

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 en 3 días
(1 comentario)
1.4

21 freelancers están ofertando un promedio de $159 por este trabajo

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. Más

$150 USD en 1 día
(363 comentarios)
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 Más

$155 USD en 3 días
(57 comentarios)
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 Más

$180 USD en 5 días
(64 comentarios)
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 en 8 días
(133 comentarios)
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 Más

$150 USD en 3 días
(34 comentarios)
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 Más

$133 USD en 3 días
(72 comentarios)
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 Más

$30 USD en 1 día
(38 comentarios)
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 en 3 días
(35 comentarios)
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 Más

$125 USD en 4 días
(21 comentarios)
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 en 3 días
(9 comentarios)
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 en 3 días
(13 comentarios)
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 Más

$277 USD en 3 días
(7 comentarios)
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 en 3 días
(4 comentarios)
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 en 2 días
(1 comentario)
0.0
marlboro112

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

$277 USD en 10 días
(0 comentarios)
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 Más

$166 USD en 3 días
(0 comentarios)
0.0