I could not complete the challenge as I have not had practice with sql in python. I had decided to use flask to create apis in python. I was able to create a script to migrate the data. My schema for database with normalisation is seen in the image
Lumel-db.jpg
. I have assumed that the csv would be in the same format assample.csv
.
For core challenges, I would create specific sql queries to fetch the data directly from the database to output the api.