CASE STUDY
Budget: ₹100 – ₹400 INR
The detailed steps are explained below,
1. Read the data extraction tab of the BIGC model
2. Perform ETL on the file to convert the model to a long format like the Output.csv file
3. The model should be inserted into the database
a. Create a table structure like the Output.csv file in the SQL database
b. Create a primary/composite key for the database
c. In case any changes are made in the model, and the file is uploaded again, then the
database should reflect the change (Create an update query)
4. Send a notification mail to the model author which confirms the model upload to the user (user
mail id can be extracted from the mail-id field in the model)
1. Read the data extraction tab of the BIGC model
2. Perform ETL on the file to convert the model to a long format like the Output.csv file
3. The model should be inserted into the database
a. Create a table structure like the Output.csv file in the SQL database
b. Create a primary/composite key for the database
c. In case any changes are made in the model, and the file is uploaded again, then the
database should reflect the change (Create an update query)
4. Send a notification mail to the model author which confirms the model upload to the user (user
mail id can be extracted from the mail-id field in the model)