Having this requirement I need to create a database using MySQL.

In this project, you will create a Web Application that may be used by Patients who are looking to make an appointment to see a Chiropractor. Patients will be able to search available times/dates and make an appointment.

A Customer/Patient Should be able to:

1. Create a patient account to be used to make appointments
2. Make changes to their account information at any time
3. Login, search available appointments, based on time/day and or doctor.
4. Schedule an appointment using their Patient Account
5. View a list of all their previous appointments as well as their future appointments

A Chiropractor/Doctor Should be able to:

1. Log in, change any of their information at any time
2. View a list of appointments for a particular day
3. View a list of all their patients
4. View a single patients recent appointments

An Admin User Should be able to:

1. Login
2. Create the weekly schedule for the office(which chiro works when)
3. Add new Chiropractors to the database as they are hired