Q13

MCQMarks unknown

Consider the following relational schema: COURSES (cno, cname) STUDENTS (rollno, sname, age, year) REGISTERED_FOR (cno, rollno) The underlined attributes indicate the primary keys for the relations. The ‘year’ attribute for the STUDENTS relation indicates the year in which the student is currently studying (First year, Second year 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.

Loading…