download the schema mentioned in the link below
http://www.mysqltutorial.org/mysql-sample-database.aspx
Once you have loaded the data write the following API’s
Customer_Product API : how many products was bought by a given customer ( join customer , order, product)
Product Api : how many products was bought by a given product line ( join product line , product )
evaluate API based on efficiency w.r.t time , storage , CPU usage and consistency