Question $1$

$25$ Points

Given the following business scenario, create a Crow$$s Foot ERD using a specialization hierarchy if appropriate.

Unilever keeps information on employees and their insurance dependents. Each employee has an employee number, name, address, date of hire, and title. If an employee is an engineer, then the date of license certification and the renewal date for that certification should also be recorded in the system. For all employees, their Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.

Make sure to include the attributes stated in the problem and indicate the PKs$,$ and FKs$,$ if applicable. Add attributes that will be logical to add to your identified entities. Check the instructions for the submission to this question.