(Solved): LOGICAL DESIGN Entity Relationship Diagram EXAMPLE START: Entity name: Departments Attributes:&nbs ...

LOGICAL DESIGN
Entity Relationship Diagram

EXAMPLE START:
Entity name: Departments

Attributes: 

      Example: SSN, userid, Name
 

Functional dependencies: 
      Example: SSN ? userid, name; userid ? SSN, name

Attribute closures (if any): 
      SSN+ = SSN, name, userid (this is an example)
      userid+ = SSN, name, userid
      (SSN, userid) is a super key
 

Unique keys: the key for this table is/are
      SSN
      userid
 

EXAMPLE END

***********************************************************************

THE ACTUAL PROBLEM: 
Would you please identify the attribute functional dependencies for each of the relationships in the following ER model? The purpose is to identify all of the keys (e.g., surrogate, natural, composite, etc).