CSIS 615 Database Management Entity Relationship Diagram Assignment 2 Draw an entity-relationship diagram for the following case. Use WorkBench or hand draw your diagram. You would need to make reasonable assumptions. You would need to identify and include all of the: 1. Entities 2. Attributes 3. Primary Keys 4. Relationships 5. Resolve all many-to-many relationships University of Tatooine wants to maintain data on its colleges, departments, professors and students. UT has several colleges, such as College of Business, College of Art and Science and College of Technology, etc. For these colleges, UT wants to know its location (such Stark Hall), phone number, budget amount. Each college would have at least one department. For each department, UT wants to track its name, phone number, location. Professors usually belong to one department, but they could belong to more than one department. For professors, UT wants to know their name, date of birth, office building name and room number. All departments have a chairperson. The chair is also a professor. For students, UT wants to know their name, address (street, city, state, zip code), phone number and major. For each major, we need to know the name of the major, a brief description of the major and number of credit hours required. Students would need to make advising appointments with their professors. Timing information such as start time, end time, would need to be kept for each appointment