Relationships and schema design assignment

gistfile1.txt

--asignment 1
select 
    e.emp_name, 
    d.dept_name 
from 
    employee e 
join 
    department d
on 
    e.department = d.id 
where 
    d.dept_name = 'Sales';

--asignment 2
select 
    e.emp_name, 
    p.project_name 
from 
    employee_project ep 
join 
    employee e
on 
    e.id = ep.emp_id
join 
    project p 
on 
    ep.project_id = p.id
where   
    p.project_name = 'Plan christmas party';

--asignment 3
select 
    e.emp_name,
    d.dept_name,
    p.project_name
from 
    employee e
join 
    department d
on 
    e.department = d.id
join 
    employee_project ep
on 
    ep.emp_id = e.id
join 
    project p
on 
    p.id = ep.project_id
where 
    d.dept_name ='Warehouse' 
    AND
    p.project_name = 'Watch paint dry';

--assignment 4
select 
    e.emp_name,
    d.dept_name,
    p.project_name
from 
    employee e
join 
    department d
on 
    e.department = d.id
join 
    employee_project ep
on 
    ep.emp_id = e.id
join 
    project p
on 
    p.id = ep.project_id
where 
    d.dept_name = 'Sales';

--asignment 5
select 
    e.emp_name,
    p.project_name
from
    department d
join    
     employee e
on 
    e.id = d.manager
join
    employee_project ep
on  
    e.id = ep.emp_id
join 
    project p
on 
    p.id = ep.project_id
where 
    p.project_name = 'Watch paint dry';