October 8, 2023
October 9, 2023
October 8, 2023
###### Nielit Scientist-B CS 22-07-2017
October 9, 2023
 Question 46

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.

 A Theory Explanation is given below.
Article Rating
Subscribe
Notify of
Inline Feedbacks
October 8, 2023
###### Nielit Scientist-B CS 22-07-2017
October 9, 2023
 Question 46

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.

 A Theory Explanation is given below.