This application will read roster data in JSON format, parse the file, and then produce an SQLite database that contains a User, Course, and Member table and populate the tables from the data file.

You can base your solution on this code:http://www.py4e.com/code3/roster/roster.py- this code is i as you need to modify the program to store therolecolumn in theMembertable to complete the program

Move the downloaded file into the same folder as yourroster.pyprogram.

Once you have made the necessary changes to the program and it has been run successfully reading the above JSON data, run the following SQL command:

SELECT hex(User.name || Course.title || Member.role ) AS X FROM User JOIN Member JOIN Course ON User.id = Member.user_id AND Member.course_id = Course.id ORDER BY X 

Find thefirstrow in the resulting record set and enter the long string that looks like53656C696E613333.