1. Draw a database dimensional diagram using the scenario provided below:

Dept(DEPTNO, DNAME, LOC)

• pk = {DEPTNO}

Emp(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

• pk = {EMPNO}
• fk = {DEPTNO} references Dept(DEPTNO)

TASKS:

-Track the minimal salary of the employees who were hired in each year in each department

-Draw the diagram

-Use surrogate keys for the primary keys