outputing JSON data into SQL table format

Question

link for the database and the JSON file:

https://www.transfernow.net/en/dltransfer?utm_source=20220406hCbu1XIk

download incoming_students.json and iroonwood database from the link above and review the data. We will use these files to dynamically add new students to the Ironwood database.

There are some challenges in this part of the lab to consider:

• You are given the advisor's name in this file, and you will have to derive the ID value (which can be looked up as the instructor ID in the instructor table)

• The same process will need to be followed for looking up the state abbreviation for the provided state name

• The address object will need to be parsed

• The user ID is derived as follows: lastNameFirstInit + number of occurrences in the database. For example, there is Clifford Wall in the database. His userID is wallc1 because there is only one wallc userid. But there is an incoming student in the JSON file that is Candy Wall, so her ID should dynamically come out to wallc2

• A successful import of the JSON file should result in the following student table: enter image description here

i created 2 seperate tables, one for the Address info, and one for the Student Info,

and i like to know, how can i do the above challenges, so that i can dynamically add the new students into the student table?