Download Adventureworks 2016 database from the below link and answer below questions:

https://www.microsoft.com/en-us/download/details.aspx?id=49502

1. Show employees names and phone numbers

2. Show employees name and job title where there is an 'e' in their last name

3. Show employee name and where vacation hours are greater than sick leave hours

4. Show employee name where department is Document Control, Quality Assurance, or Facilities and Maintenance

5. Show a Sales Person name and total sales where bonus is between $3000 and $4000 and sales improved between this year and last.

6. Create an ER diagram for the pubs database. List the foreign keys for each table.

7. Describe the cardinality for each relationship shown in the ER diagram.