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.
7 freelancere byder i gennemsnit $26 for dette job
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