NOTE ( ONLY USE DROW.IO TO DO IT )

1. Given the following business scenario, create a Crows Foot ERD using a specialization hierarchy if appropriate.

[Business scenario]

Tiny College keeps the data about their employees such as employee ID, name, date of birth, salary, and date of hire. An employee could be staff, a professor, or an administrator. A professor may also be an administrator. Staff employees have a work level classification, such as Level I or Level II. Administrators have a position title. Professors have a degree certificate. Some Tiny College staff employees are information technology (IT) personnel. Some IT personnel provide technology support for academic programs, some provide technology infrastructure support, and some provide support for both. IT personnel are not professors; they are required to take periodic training by date, type, and results (completed versus not completed).