Course : Fundamentals of Databases ( IT403)

Consider the following relations:

Student(ssn, name, address, major)

Course(code, title)

Registered(ssn,code)

Use relational algebra language to answer the following queries:

Query 1: List the codes of courses in which at least one student is registered (registered courses).

Query 2: List the titles of registered courses (of those in query 1).

Query 3: List the codes of courses for which no student is registered.

Query 4: The titles of courses for which no student is registered.

Query 5: The number of courses, which are registered for each ssn.