Database Change

Proposed Database Schema

Justification

I feel there is no need for department_task intermediate table as at the end of the day we will still end up querying task table, so doing it from an intermediate table feels redundant.

REMARKS
I still think that the relationship between departments and projects is not one-to-many but should be many-to-many instead so it's still subject to major changes.