In an E-R diagram, there are two entity sets, students and courses, and one relationship set, take. Students entity set has attributes SID and SN, while courses entity set has attributes CID and CN....

In an E-R diagram, there are two entity sets, students and courses, and one relationship set, take. Students entity set has attributes SID and SN, while courses entity set has attributes CID and CN. Please draw the E-R diagram. Suppose that students pursue PhD, MS, and BS degrees. Further, MS students can have ‘Thesis option’ or ‘Non-Thesis option’; and PhD students can be ‘Candidates’ or ‘Non-Candidates’. Extend the E-R diagram to show these facts as a generalization-specialization hierarchy.