1. Design using Microsoft word -an ERD that can be implemented for a College System, using the following requirements

The College database keeps track of colleges professors, Students, Classes, Rooms, and Courses. Suppose that, after the requirements collection and analysis phase, the database designers stated the following description of the "Tiny College", the part of the company to be represented in the database: Professors are identified by SSN, and their names, specialty, years of experience and also their permanent addresses. We should be able to search about the city, state, and zip code of the Professor's permanent address and by the professor's last or first name. Some Professors manage other Professors. A professor may teach classes, but each class is taught by one professor. We need to store a class code, time, and day. Student has a unique number, name, major, birth date, and hobbies. A class may contain many students, and each student may take many classes. Each course has a code, name, credit hours. Course may generate many classes, but each class references a single course. A class requires one room, each has a room number, single location, max capacity, and each room may also be scheduled for many classes.