Question

The query which selects the Course_id ‘CS-101’ from the section relation is

(a) Select Course_id from section where Building = ‘Richard’;

(b) Select Course_id from section where Year = ‘2009’;

(c) Select Course_id from teaches where Building = ‘Packyard’;

(d) Select Course_id from section where Sec_id = ‘3’;

This question was posed to me by my school teacher while I was bunking the class.

This interesting question is from Reduction to Relational Schemas in division Database Systems Design and Implementation of Database Management

Answer 1

Right choice is (b) Select Course_id from section where Year = ‘2009’;

The best I can explain: The year ‘2009’ should be selected from the section relation.