CHAPTER 2 6. Now suppose that certain courses ca be taught by a teara of professors jointly, but it is possible that no one proissor in a team can teach the course. Model this situation, introducing additional entity sets aad relatioeship sets if necessary. Answer 2.2 Answer omitted. Exercise 2.3 Consider the following information about a university database: Professors have an SSN, a name, an age, a raak, and a research specialty. Projects have a project number, a sponsor name (eg NSF) a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age and a degree program (eg. M.S. or Ph.D). Each project is managed by ore professor (kaown as the project's principal inves- tigator) Each project is worked oca by one or more peoissors (kaown as the project's co-investigators). Professors can manage and/or work on multiple projects. Each project is worked ou by one or more graduate students (known as the project's research assistaats) When graduate students on a project, a professor wast supervise their work work on the project. Graduate studerats can work on multiple projects, in which case they will have a (potentially diferent) supervisor for each Departments have a department number, a department name, and a main ofsoe. Departments have a professor (known as the chairmaa) who ruas the department. Professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job. Graduate students have one major department in which they are working on their degree. Each graduate student has another, more senior graduate student (lamowa as a student advisor) who advises him or her ca what courses to take. Design and draw an ER diagram that captures the informatioa about the university. Use only the basic ER model here: that is, entities, relationships, and attributes. Be sure to indicate auy key and participation coastraints. CHAPTER 2 6. Now suppose that certain courses ca be taught by a teara of professors jointly, but it is possible that no one proissor in a team can teach the course. Model this situation, introducing additional entity sets aad relatioeship sets if necessary. Answer 2.2 Answer omitted. Exercise 2.3 Consider the following information about a university database: Professors have an SSN, a name, an age, a raak, and a research specialty. Projects have a project number, a sponsor name (eg NSF) a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age and a degree program (eg. M.S. or Ph.D). Each project is managed by ore professor (kaown as the project's principal inves- tigator) Each project is worked oca by one or more peoissors (kaown as the project's co-investigators). Professors can manage and/or work on multiple projects. Each project is worked ou by one or more graduate students (known as the project's research assistaats) When graduate students on a project, a professor wast supervise their work work on the project. Graduate studerats can work on multiple projects, in which case they will have a (potentially diferent) supervisor for each Departments have a department number, a department name, and a main ofsoe. Departments have a professor (known as the chairmaa) who ruas the department. Professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job. Graduate students have one major department in which they are working on their degree. Each graduate student has another, more senior graduate student (lamowa as a student advisor) who advises him or her ca what courses to take. Design and draw an ER diagram that captures the informatioa about the university. Use only the basic ER model here: that is, entities, relationships, and attributes. Be sure to indicate auy key and participation coastraints