Entity Relationship

Build an E-R diagram for Tiny College given the following information: Tiny College is divided into several schools: school of business, school of arts & science: school of education and a school of applied science. Each college is administered by a dean who is a professor (each dean can only administer one school). Each school is composed of several departments (i.e. the school of business has an accounting department, a management/marketing department, an economics/finance department and a computer information systems department). Each department belongs to only one school. Each department may offer courses (i.e. the management/marketing department offers courses such as Introduction to Management, Principles of Management and Production Management). Each course may offer several sections (classes) of the same course. Each of those courses is taught by a professor at a given time, in a given classroom. Not all courses are offered each semester. Each department may have many professors assigned to it. One professor chairs the department. Each professor may teach up to 4 classes. A student may enroll in up to 6 classes and each class may have up to 35 students. A student may not enroll in the same class during the same semester. Each student has a single major (associated with only one department) but may not need to declare a major immediately. Each student has an advisor in his/her department and each advisor may counsel more than 1 student