Q2: Consider the following relational database:
STUDENT (SID, SName, GPA )
ENROLL (SID, CNo, Date )
COURSE (CNo, CTitle, Credits)
REQUIRE (CNo, Prerequisite)
Based on this relational database; give an expression in the relational algebra to
express each of the following queries:
a. Find the names of all students who have GPA greater than 3.
b. Find the ID of all students who did not enroll in course IT222.
c. Find the name of all students who enroll in both IT222 and IT221 courses.
d. Find the names and GPAs of all students who enrolled in Course IT222.
e. List the students ID, name, GPA, and course Number such that all students have GPA
greater than 3 . 5 and enrolled in a course in Jan 1, 2011.
f. List all students’ names with the title of courses they registered in.
g. List the details of all students and their course enrollment; along with the courses
prerequisites if they have one.
h. Find the details of all students who enrolled in all courses
Recently Asked Questions
- if AB =58, find the value of x 3x-6 2x+4 I don't really understand this question.
- Would you expect to find more crabs during a full moon/new moon or during a quarter moon stage and why?
- Please refer to the attachment to answer this question. This question was created from Week+6+-+Assignment+6+Revised.docx.