Question

Using the relational schema for the College Applications database, write relational algebra expressions
that perform the following problems. Complete 5 out of 6 for full credit.

Apply(sID, cName, major, decision)
Student(sID, sName, GPA, sizeHS)
College(cName, state, enrollment)

1. List the ids and names of the students that applied to the CS Dept at MIT.

2. For students that have applied to a college, list the student’s id, name and number of different
colleges the students has applied to.

3. List the ids of all students who were accepted to a CS major at a college with an enrollment over
25,000.

4. List the names and ids of the students that applied to both OSU and U of O.

5. List the names and ids of the students that applied to OSU but did not apply to U of O.

6. List the ids of students who applied to all of the colleges.

Answer 1

Answer is as follows :

As defined we answer the 5 queries :

if there is any query please ask in comments..