I gang

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)

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.

Færdigheder: MySQL, SQL

Se mere: mysql database application, sql create database, mysql city state database, inactive email account, phone holder, create balance, sql parents, mysql help table, mysql parents, create store name, create database tables application, create sql database, create database zip, city state zip database, budget mobile application project, project hour registration, database student, sql student, rush hour, sql web api, balance test database, project database sql student, web api mobile application, mobile application project budget, mobile email address database

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

Projekt-ID: #5988436

Tildelt til:

thecn

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)
4.4

7 freelancere byder i gennemsnit $26 for dette job

Creativeartbd

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)
4.1
cijagani

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 Mere

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

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)
0.0
toxicman

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)
0.0
jingguoquan

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 Mere

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

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 Mere

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

Hi.. I am expert in MySQL database I create this database for you. for more information you can visit www.appstechno.com so lets starts...

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

A proposal has not yet been provided

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