The application should let a user maintain a list of customers. After selecting a customer the user
should be able to specify in what states the customer does business in. By clicking the "Save all
changes"-button all the changes made by the user should be stored in a MySQL database.
List of clients must contain the following information:
- Name of the customer
- State where the headquarters of the customer is
- Contact e-mail
All fields are required.
List of clients should be fully loaded at startup, paging'a not necessary. Information on the states in
which the customer does business in should be loaded from the database only when necessary using
Ajax (jQuery).
It should be possible to add, edit and delete customers.
Task:
1. Create a MySQL database & all table that you need
Make sure to create indexes for optimal performance
2. Insert some test data into the database
3