You are hired by a chain of online retail stores“Fastkart”. They have provided you with “Fastkart” database and seek answers to the following queries as the results from these queries will help the...

You are hired by a chain of online retail stores“Fastkart”. They have provided you with “Fastkart” database and seek answers to the following queries as the results from these queries will help the company in making data-driven decisions that will impact the overall growth of the online retail stores.

All the questions





comes under MYSQL and the queries should be executed in MYSQL. (SQL Script -





Fastkart.sql






































)

All Questions carry 8 marks. Total Marks (8 x 10) = 80

Note:





In case the file gets open in the browser, Please copy the entire text(including comment) and paste it on MySQL workbench. Execute all the commands to create a database schema. In case, if you are able to download the file, please use MySQL Workbench, File>open SQL Script>FastKart.SQL and then execute all the statements to create a database schema.

All Questions carry 8 marks. Total Marks (8 x 10) = 80

Please refer to this link to download the Extended Project with all the queries and instructions -








Extended Project Instructions.pdf