$A=$ E$-$R model is a high$-$level conceptual model for COMPANY database design $(15$ points$)$

a COMPANY has departments.

b$.$ Department has name, number, manager.

Manager is an employee

Manager has starting date

Department has several locations

c$.$ Department controls projects.

Project has name, number, location

d$.$ Employee has name, social security, number, address, salary, sex, birthdate.

c$.$ Employee is in one department but may work on several projects.

f$.$ Hours each employee works on each project for a given number of hours.

g$.$ Employee has supervisor.

h$.$ Employee has dependents with name, sex, birthdate, and relationship to employee.

Consider the following Database Schema

$(15$ points$)$ give the relational algebra and SQL queries and draw the table for the output of the query.

a$.$ Display the names of all users over the age of $25$

b$.$ Display all information of users who have occupation id greater than or equal to $2$ and whose are is not $31$

c$.$ Perform the natural join of user and occupation

d$.$ Perform the natural join of user, occupation and city

c$.$ Display the name and gender of all users who live in Boston

$\backslash$table$[[$ald$,$Name,$A,$Gensiet,Cceuputionily,coyin$],[1,$Jotn,$25,$Male,$1,3],[2,$Sere,$20,$Femate,$3,4],[3,$victor,$31,$Wate,$2,5],[4,$Jore,$27,$Femalt,$1,3]]$

a$.$

$\backslash$table$[[$Occupationls$,$Occupationsiatie$],[1,$Software Engineer$],[2,$Accountant$],[35,$Pharmaciat$],[4,$Lbrary Assistant$]]$

City

$\backslash$table$[[$Ciyld$,$Cryame$],[1,$Maltax$],[2,$Calgary$],[3,$Boston$],[4,$New York$],[5,$Torontd$]]$

Which of the following functional dependencies hold in relation $S$

$(10$ points$)$

a$.xY$

b$.ZY$

c$.YZ$

d$.xY-Z$

e$.YZx$

f$.xZY$

$\backslash$table$[[x,Y,Z$

PLEASE SHOW DRAWN ER SCHEMA ECT