1. Identify each entity (indicate it if the entity is a weak entity) and its key(s). Identify its attributes. Indicate it if an attribute is composite or multivalued or derived.

(e.g. Employee is a (strong) entity, ssn is its key)

2. For each relationship, identify the cardinality ratio (one-to-one, one-to-Many, Many-to-one, or Many-to-Many), and describe the information it conveys considering both sides of relationship.

(e.g. Works-for relationship: Many-to-one from EMPLOYEE to DEPARTMENT. A department can have many employees working for the deparment, an employee can only work for one department.)

3. For each relationship, identify the participation constraints (total or partial participation) and describe the information it conveys considering both sides of relationship.

(e.g. Works-for relationship: Every employee must work for a department, and every department must have some employees working for the department.)

4. Indicate if the relationship is an identifying relationship (i.e., a relationship of a weak entity)
5. Indicate attribute(s) of a relationship, if any.

Fname Minit Lname Bdate Name Address Salary San Sex Locations N 1 WORKS_FOR Name Number EMPLOYEE Start_date Number_of_employees DEPARTMENT 1 MANAGES CONTROLS Hours N N Supervisor WORKS_ON PROJECT Supervisee 1 1 SUPERVISION Name Location DEPENDENTS OF Number N DEPENDENT Name Sex Birth_date Relationship