Find Jobs
Hire Freelancers

Create MySQL Database

$10-30 USD

Completed
Posted almost 10 years ago

$10-30 USD

Paid on delivery
I need to create a MySQL database for a web api that will serve a mobile application. The mobile application allows students to register for martial arts classes, sign in at the classes, keeps track of their account balance (including payments and debits), and keeps track of the classes and locations. The database will have several tables. The structure is to be determined, but it will store information about: Account (Account ID, First Name, Last Name, Phone, Phone 2, Address, City, State, Zip, Email, Spouse, Spouse Email, Spouse Phone, Balance, Notes) Student (Student ID, First name, Last Name, Birthdate, Gender, Rank, Active/Inactive, Notes) Class (Class ID, Name, description, Time, Start Date, End Date, Registration Fee, Class Fee, Prepay Fee, Test Fee) Location (Location ID, Name, Address, City, State, Zip, Notes) Registration Payment (Payment ID, Amount, Date, Notes) Debit (Debit Id, Amount, Date, Notes) So, each class will have 1 location, although a location may have several classes at it. Each account can have one or many students. Students register for a particular class which is tracked by the registration table. A student can be in multiple classes, and a class will have many students. Credits and debits are applied to accounts, and track class fees and payments. (Usually the account holder will be the parents of the student, but there are adult students as well and the account and student will be the same). I need to create a MySQL database. I have a general idea of how it needs to be set up, but I am looking for expert help. This project is a rush, and I would like to complete it as soon as possible. I don't think it should take more than an hour or two, so that is my budget.
Project ID: 5988436

About the project

7 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
Hello, I will help you to setup this database, feel free to ask if you have any question. As you are online, lets chat to discuss more. thanks.
$24 USD in 1 day
5.0 (6 reviews)
4.4
4.4
7 freelancers are bidding on average $26 USD for this job
User Avatar
Well, Let's build your Mysql Database Table aright away. I'm available to discuss with you for this project. Thank You.
$34 USD in 1 day
4.9 (11 reviews)
4.1
4.1
User Avatar
I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, e-commerce websites and portals, payment gateways and customized web based applications. my aim to deliver quality products to our customers within specified deadline. i strongly believe in Quality work. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs.
$24 USD in 1 day
5.0 (9 reviews)
3.7
3.7
User Avatar
Hello, Let me complete the job for you. I will create the database and those tables for your. I will take care of future addition if you need. Thanks Mizan
$15 USD in 0 day
5.0 (1 review)
0.0
0.0
User Avatar
Hello I'm a software engineer with good knowledge in sql database design. I can help you to do your job. best regards hossein
$88 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Good Day! Hi, This is Mark from Philippines a Web & Mobile Developer since 2009, with solid background on PHP, Laravel, and Python. Reading your requirements I am very much confident that I can deliver your requested project, I am hoping for a work relation with you in the future. Thank for reading this ... {{ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - }} {{ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - }} My Skillsets are: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - HTML(5), CSS(3), Javascript, PHP (OOP), jQuery, ASP, C, C++ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - My Expertise are: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Web Development, Mobile Application Development, Systems Development
$34 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Frederick, United States
5.0
1
Payment method verified
Member since Feb 28, 2014

Client Verification

Other jobs from this client

Penny Auction Site
$1500-3000 USD
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.