Answer to Question #174836 in Databases | SQL | Oracle | MS Access for Prisy

Question

1. Consider the relations

Lecturer (firstName, lastName, email,course)

i. Print all the information about lecturers who handles DBMS

ii. Print the names and emails of those lecturers who take HCI

iii. Find the lecturer with the surname “feel free “and also handles “DBMS”

b) Use the schema below to express the following queries using Relational Algebra Research_Student(Name, Grad_Univ, CGPA, Age, Email) 

i. Find all research students who have their CGPA is greater than 3.5 and their ages of greater than 25 years.

ii. Find the names and emails of research students who have their CGPA less than 2.5

Answer 1

1.
SELECT * FROM collegemanagement.lecturer where course='dbms';

2.
SELECT * FROM collegemanagement.lecturer where course='HCL';

3.

SELECT * FROM collegemanagement.lecturer as l where course='dbms' and l_name='feel free';

b) i) 
select * from research_student where CGPA>3.5 and age>25;

ii) select name,Email from research_student where CGPA<2.5;