Create using Visio if possible. Thanks!

Develop an extended ERD (EERD) for a typical college that has the following Business rules: List the entities with their attributes such as PK and FK plus other common attributes that should belong to the entities in your EERD.

• An employee could be staff or a professor or and administrator

• A professor may also be an administrator

• Staff employees have a work level classification, such as level I and level II

• Only professors can chair a department. A department is chaired by only one professor (each department has many professors who work for only and only one department).

• Only professors can serve as dean of a college. Each of the university's colleges is served by one dean.

• A professor can teach many classes

• Administrators have a position title