Consider the diagram from your previous assignment:

Generate SQL script $($i$.$e$.$ create the necessary tables, including primary$/$foreign keys$)$ that represents the diagram from your previous assignment. Once you have generated SQL tables, come up with INSERT statements that load the following data into the database:

John Smith, $111$ N$.$ Wabash Avenue, who worked as a plumber and a bouncer

Jane Doe, $243$ S$.$ Wabash Avenue, who worked as a waitress and an accountant

Mike Jackson, $1$ Michigan Avenue, with no record of previous jobs held

Mary Who, $($no address available$),$ who worked as an accountant and risk analyst

Jane Doe has two loans out: #$1,5\%$ interest, $$10000$ and #$2,12\%,$ $$7000$

Mike Jackson has three loans out: #$2,10\%$ interest, $$1000$ and #$3,20\%,$ $$25000,$ #$4,3\%$ interest, $$100000.$

You may make any reasonable assumptions about data domains. Remember that in SQL strings $($CHAR and VARCHAR$/$VARCHAR$2)$ are represented with single quotes. So$,$ for example, $$Plumber$$ is the way to represent a job $($not Plumber$).$ Also remember that all tables must have a primary key.