Question 1: Relational algebra A national ICT conference has a database that records information about the various workshops that are available for...

Question 1: Relational algebra

A national ICT conference has a database that records information about the various workshops that are available for attendees at the conference. Each workshop is on one of several possible themes, is run by a presenter and has a limited number of places available for participants. Information on all conference attendees and presenters is also recorded. 

The schema for this database is as follows: (note that primary keys are shown underlined, foreign keys in bold).

ATTENDEE (AttendeeNo, AttendeeName, InstitutionName)

INSTITUTION (InstitutionName, State)

PRESENTER (PresenterName, Biography, InstitutionName)

WORKSHOP (WorkshopNo,WorkshopName, Theme, Description, Capacity, DateAndTime,

PresenterName)

PARTICIPANT (AttendeeNo, WorkshopNo)

Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks. 

NOTE:

•      You can use the symbols 'π','α','×' etc