University ER exercise: Answers to Query questions
  1. Print: Course.name. Tables: Dept, offered, Course. Constraints: Dept.id=25.
  2. Print: Student.name. Tables: Student, Enroll, Section, Course. Constraints: Course.name=“E-commerce”.
  3. Print: Course.name. Tables: Prof, qual, Course. Constraints: Prof.name=“Lindsey”.
  4. Print: Course.name. Tables: Prof, position, Dept, College, qual, Course. Constraints: College.name=“LS&A”.
  5. Print: Course.name. Tables: Prof, Dept, College. Constraints: none.
  6. Print: Course.name. Tables: Prof, position, Dept, College. Constraints: none.
  7. Print: Student.name. Tables: Student, advisor, Prof. Constraints: Prof.name.
  8. Print: Student.name. Tables: Student, enroll, Section, teach, Prof. Constraints: Prof.name=“Lindsey”.
  9. Print: Student.name. Tables: Student, advisor, Prof, enroll, Section, teach, Prof. Constraints: Prof.name=“Lindsey”.
  10. 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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License