1
1
Department.id
Department.name
Department.location
City.city_id
City.city_name
City.province
=
ONTARIO)
1
2
1
1000
Employee.id
Employee.name
Employee.address
Employee.salary
Employee.name
Employee.id
Employee.name
Employee.address
Employee.salary
800)
>
Employee.name
Employee.salary
800)
>
ITJob
1
1
Manager.time_assigned
COUNT
all
Manager.id
Manager.entry_date
Manager.project
Manager.time_assigned
Outsourceproject.project_id
Outsourceproject.contract_id
Outsourceproject.phase
3
2
1
3
2
Project.name
Project.name
3000)
>
4
1
2
Worksfor.employee_id
Worksfor.department_id
2)
=