University ER exercise: Answers to Query questions
- Print: Course.name. Tables: Dept, offered, Course. Constraints: Dept.id=25.
- Print: Student.name. Tables: Student, Enroll, Section, Course. Constraints: Course.name=“E-commerce”.
- Print: Course.name. Tables: Prof, qual, Course. Constraints: Prof.name=“Lindsey”.
- Print: Course.name. Tables: Prof, position, Dept, College, qual, Course. Constraints: College.name=“LS&A”.
- Print: Course.name. Tables: Prof, Dept, College. Constraints: none.
- Print: Course.name. Tables: Prof, position, Dept, College. Constraints: none.
- Print: Student.name. Tables: Student, advisor, Prof. Constraints: Prof.name.
- Print: Student.name. Tables: Student, enroll, Section, teach, Prof. Constraints: Prof.name=“Lindsey”.
- Print: Student.name. Tables: Student, advisor, Prof, enroll, Section, teach, Prof. Constraints: Prof.name=“Lindsey”.
- Print: Student.name. Tables: Student, advisor, Prof, enroll, Section, teach, Prof, Course, offered, Dept, College. Constraints: Prof.name=“Lindsey” and College.name=“LS&A”.
Back to the university problem.
page revision: 3, last edited: 20 Aug 2008 13:33