Consider the COMPANY database that keeps track of a companys employees, departments and projects: The company is organized into departments. Each department has a unique name, a unique number and a particular employee that manages the department. A department controls a number of projects, each of which has a unique name and unique number. We store each employees name, a national card ID, address, salary, and birth date. An employee is assigned to one department but may work on several projects, which are not controlled by the same department. We keep track of the number of hours per week that the employee works on each project. A project may involve more than one employee.

Create a 3rd Normal Form Relational Model expressed in a flat relational schema.

This schema must include, primary keys, foreign keys, non-key attributes, and appropriate directional links for each relationship set.

Foreign Keys that are not part of a composite primary key, will have "dashed" underline. Primary keys will have the solid underline.

State clearly other than primary keys if the other keys are Null or Not Null

Use an appropriate drawing tool to complete