Answer those using the following information using adobe Access

. Deliverables from previous two project assignments (Project Scope & ERD): 1pt Create the tables (5 minimum) with constraints: 2pts o Primary Key. Not Null, Foreign Key, Etc. . Populatethtables (at least 3 entries per table): 1pt . Create the relationships defined in your ERD: 1pt . You need to come up with five queries meeting the requirements below, and explain why the queries are important to the organization: 5pts o 1st Query: Basic WHERE clause o 2nd Query: Use the AND, OR, or IN operator o 3rd Query: Computed/ Calculated Columns with Alias o 4th Query: Use the INNER jOIN command for two or three tables o 5th Query: Use a math function (COUNT, AVG, SUM, MIN, MAX, etc.)