Database

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.