Must be created with ERD Plus.

Problem 1 (5 points): Create an ERD following the following specifications: A college wishes to store information about its faculty members, departments, and schools. Every department is identified by its unique department ID number, and name. For every department the college wishes to store the list of majors issued by this department. Every school has a unique name, and a contact email address. For every faculty member the college wishes to maintain the information about her/his unique employee ID, name (first, optionally middle, and last), unique work email; and any other (if any) email(s) associated with this faculty member. A department has many faculty members assigned to it, but each faculty member can be assigned to only one department. At the same time there are faculty members who are not assigned to any department. When a new department is created it must have at least one faculty member associated with this department. All the college departments are divided into schools. Every school operates at least one department; each department is operated by exactly school