Please provide a relational model for this database. I$\text{'}$m struggling with connecting the relationships within the tables $($primary keys$/$foreign keys$)$

DEPARTMENT $($DepartmentName$,$ BudgetCode, OfficeNumber,

DepartmentPhone$)$

EMPLOYEE $($EmployeeNumber$,$ FirstName, LastName, Department,

Position, Supervisor, OfficePhone, EmailAddress$)$

PROJECT $($ProjectID$,$ ProjectName, Department, MaxHours,

StartDate, EndDate$)$

ASSIGNMENT $($ProjectID$,$ EmployeeNumber, HoursWorked$)$