Please add the SQL tables to if you can. Thanks!

Attached please find an Access database that contains inforamtion an artilces published by accounting scholars. Use this database to complete items 1 through 4 below. 1. Create and paste a well-fromatted entity realtionship diagram ERD for the datbase. [5 points] 2. Create a query that lists the Scholar, ID, Gender, [Scholars table] the ID, University and Tier s/he got their PhD from [Schoos_1]and the ID, University and Tier where s/he Pcurrently works [Schools]. Report the results in scholar ID sequence. Paste the SQL and the results [25 points] 3. Create a query that lists the ID, University and Tier and counts the number women and men who who got their PhD from each University [Schools]. Report the results in school ID sequence. Paste the SQL and the results. [ 10 points] 4. Create a query that shows how many arrilces were published on each topic. Paste the SQL and the results. [10 points] Attached please find an Access database that contains inforamtion an artilces published by accounting scholars. Use this database to complete items 1 through 4 below. 1. Create and paste a well-fromatted entity realtionship diagram ERD for the datbase. [5 points] 2. Create a query that lists the Scholar, ID, Gender, [Scholars table] the ID, University and Tier s/he got their PhD from [Schoos_1]and the ID, University and Tier where s/he Pcurrently works [Schools]. Report the results in scholar ID sequence. Paste the SQL and the results [25 points] 3. Create a query that lists the ID, University and Tier and counts the number women and men who who got their PhD from each University [Schools]. Report the results in school ID sequence. Paste the SQL and the results. [ 10 points] 4. Create a query that shows how many arrilces were published on each topic. Paste the SQL and the results. [10 points]