PROFESSOR STUDENT STU NUNM STU LNAME STU INIT STU_DOB STU HRS STU CLASS STU GPA STU_TRANSFER DEPT CODE STUD PHONE PROF_NUM CLASS EMP NUM DEPTCODE PROF OFFICE PROF_EXTENSION PROF HIGH DEGREE CLASS_CODE CRS_CODE CLASS_SECTION CLASS_TIME ROOM_CODE PROF NUM EMPLOYEE EMP NUM EMP LNAM EMP FNAME EMPINITIAL EMP_JOBCODE EMP HIREDATE EMP DOB ENROLL CLASS CODE STU_NUM ENROLL_GRADE COURSE CRS CODE DEPT CODE CRS_DESCRIPTION CRS CREDIT DEPARTMENT DEPT_CODE DEPT_NAME SCHOOL CODE EMP-NUM DEPT_ADDRESS DEPT EXTENSION PREREQ CRS_CODE PRE TAKE An employee could be staff or a professor or an administrator A professor may also be an administrator. Staff employees have a work level classification, such a Level I and Level II Only professors can chair a department. A department is chaired by only one professor Only professors can serve as the 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 Complete ERD point out all PK, FK, main attributes. Use Subtypes for Employees