Study the following E-R diagram representing a company database and then answer the questions that follow. (Assume no other entities or relationships exist)

1. Give ONE example EACH of a multi-valued attribute, an attribute of a relationship and a derived attribute.
    
2. What is the minimum number of projects that an employee can work on? What is the maximum? How do you know?
    

3. How would this diagram change if there were some employees who didn't work in any department.

4.  While converting this to a relational model, which attribute(s) will become a relation (table)? Explain briefly.

5.  While converting to a relational model, if we create a primary-key foreign-key relationship to show WORKS_FOR between the two relations for DEPARTMENT and EMPLOYEE, which relation will get the foreign key field? Explain briefly.
    

Sex FName SSN DOB LName Name EMPLOYEE Salary M WORKS ON N Hours Number of Employee WORKS FOR Location 1 PNum PROJECT Name DNum Name DEPARTMENT CONTROLS N Location