advisor(s_id, i_id) connects students and instructors. takes(id, course_id, …) connects students and courses.
- Which instructors advise more than one student? Return
i_id, then the number of students. - At most how many advisors can one student have? The key icon tells you.
- What is the cardinality of
advisor, from student to instructor? - Which students have no advisor? Return their
id. - Is the participation of student in
advisortotal or partial? - What is the cardinality of
takesbetween student and course?