What would the ERD diagram be for numbers 5 and 6? Assignment 2 ER Diagrams (Protected View)

What would the ERD diagram be for numbers 5 and 6?

  

Transcribed Image Text:

Assignment 2 ER Diagrams (Protected View) - Word (Unlicensed Product) File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing NOTICE Most features are disabled because your Office product is inactive. To use for free, sign in and use the Web version. Activate Use free at Office.com Tasks: A university database contains information about professors (identified by social security number or SSN) and courses (identified by courseid). Professors teach courses. Each of the following situations concerns the Teaches relationship set. Hint: For case 1, semester will be an entity while from case 2 onwards, semester will be an attribute. 1. Professors can teach the same course in several semesters, and each offering must be recorded. 2. Orofessors can teach the same course in several semesters, and only the most recent such offering needs to be recorded (Assume that this condition applies to all subsequent situations below) 3. Every Professor must teach some course 4. Every professor teaches exactly one course (no more, no less) 5. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor 6. Suppose certain courses can be taught by a team of Professors jointly, but it is possible that no one Professor in a team can teach the course. Model this situation introducing additional entity sets and relationship sets if necessary. DSA 5100 DBMS&DW Page 1 of 1 Page 1 of 1 16 of 282 words Type here to search E ' 8 * W A Bailey 51F > 0 1:37 PM 12/7/2022 x 100% 5 Assignment 2 ER Diagrams (Protected View) - Word (Unlicensed Product) File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing NOTICE Most features are disabled because your Office product is inactive. To use for free, sign in and use the Web version. Activate Use free at Office.com Tasks: A university database contains information about professors (identified by social security number or SSN) and courses (identified by courseid). Professors teach courses. Each of the following situations concerns the Teaches relationship set. Hint: For case 1, semester will be an entity while from case 2 onwards, semester will be an attribute. 1. Professors can teach the same course in several semesters, and each offering must be recorded. 2. Orofessors can teach the same course in several semesters, and only the most recent such offering needs to be recorded (Assume that this condition applies to all subsequent situations below) 3. Every Professor must teach some course 4. Every professor teaches exactly one course (no more, no less) 5. Every professor teaches exactly one course (no more, no less), and every course must be taught by some professor 6. Suppose certain courses can be taught by a team of Professors jointly, but it is possible that no one Professor in a team can teach the course. Model this situation introducing additional entity sets and relationship sets if necessary. DSA 5100 DBMS&DW Page 1 of 1 Page 1 of 1 16 of 282 words Type here to search E ' 8 * W A Bailey 51F > 0 1:37 PM 12/7/2022 x 100% 5