2. List three of your database foreign keys. For each key, indicate the table it belongs to the and the table and key that it references. 3. Write the query that shows how many dependents does each employee have? 4 Valid abbedilabd a En 3. Write the query that shows how many dependents does each employee have? 4. Write the query that displays the names and vacation time for each employee. 5. Write the query that displays a table containing the room number of each restricted room along with the employees that have access to that room. If multiple employees have access to the same room, that room's number will appear on multiple rows. 6. Write the query that shows the names of the dependents of one of your employees (you pick the employee). 7. Write a query that displays the names and phone numbers of all of the emergency contacts. Do not show duplicates. 8. Write a query that displays the oldest employee's name. You can use the Postgres age() function on your employee's birthdates to get the employee's age: if birthdate is the age column of an employee table, then "select age(birthdate) from employee" returns the ages of the employees. 2. List three of your database foreign keys. For each key, indicate the table it belongs to the and the table and key that it references. 3. Write the query that shows how many dependents does each employee have? 4 Valid abbedilabd a En 3. Write the query that shows how many dependents does each employee have? 4. Write the query that displays the names and vacation time for each employee. 5. Write the query that displays a table containing the room number of each restricted room along with the employees that have access to that room. If multiple employees have access to the same room, that room's number will appear on multiple rows. 6. Write the query that shows the names of the dependents of one of your employees (you pick the employee). 7. Write a query that displays the names and phone numbers of all of the emergency contacts. Do not show duplicates. 8. Write a query that displays the oldest employee's name. You can use the Postgres age() function on your employee's birthdates to get the employee's age: if birthdate is the age column of an employee table, then "select age(birthdate) from employee" returns the ages of the employees