Create MySQL Database

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)


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.

Evner: MySQL, SQL

Se mere: this account is inactive, mysql database application, my sql create database, mysql city state database, inactive email account, how to create a account, student database, phone holder, create balance, sql parents, project student registration project, mysql help table, address name last name, mysql parents, create store name, description adult store, create database tables application, project class register, Create sql database, name last name, create database zip, city state zip database, budget mobile application project, project hour registration, database student

Om arbejdsgiveren:
( 1 bedømmelse ) Frederick, United States

Projekt ID: #5988436

Tildelt til:


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 på 1 dag
(6 bedømmelser)

7 freelancere byder i gennemsnit $26 på dette job


Well, Let's build your Mysql Database Table aright away. I'm available to discuss with you for this project. Thank You.

$34 USD på 1 dag
(11 bedømmelser)

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 spe Flere

$24 USD på 1 dag
(9 bedømmelser)

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 dage
(1 bedømmelse)

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 på 1 dag
(0 bedømmelser)

1 hour!! Hi sir! i have checked your job description.. So i think that this job will be finished in a hour. No problem for me. i have rich experiences in database design via several website development a Flere

$35 USD in 0 dage
(0 bedømmelser)

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 requ Flere

$34 USD in 0 dage
(0 bedømmelser)

Hi.. I am expert in MySQL database I create this database for you. for more information you can visit [url removed, login to view] so lets starts...

$28 USD på 1 dag
(0 bedømmelser)

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)