Consider the relation examinee (regno, name, score), where regno is the…

PYQ GATE 2001

Consider the relation examinee (regno, name, score), where regno is the primary key to score is a real number.

(a) Write a relational algebra using (∏,σ,ρ,×) to find the list of names which appear more than once in examinee.

(b) Write an SQL query to list the regno of examinees who have a score greater than the average score.

(c) Suppose the relation appears (regno, centr_code) specifies the center where an examinee appears. Write an SQL query to list the centr_code having an examinee of score greater than 80.

Attempted by 1 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…