Question 10317 – SQL

Consider the following relational schema:

 COURSES (cno, cname)
 STUDENTS (rollno, sname, age, year)
 REGISTERED FOR (cno, rollno) 

<p align="Justify" the="" underlined="" attributes="" indicate="" primary="" keys="" for="" relations.="" ‘year’="" attribute="" students="" relation="" indicates="" year="" in="" which="" student="" is="" currently="" studying="" (first="" year,="" second="" etc.)=""
(a) Write a relational algebra query to
Print the roll number of students who have registered for cno 322.
(b) Write a SQL query to
Print the age and year of the youngest student in each year.

Correct Answer: A