A national ICT conference has a database that records information about the various workshops that are available for attendees at the conference.

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 or the words ‘PROJECT’, ‘RESTRICT’ etc as you prefer.  You do not need to try to make efficient queries – just correct ones.  Where you use a join, always show the join condition.

a. List the name and institution of all presenters.

b. List the workshop name and capacity for all workshops on the theme of ‘Virtual Reality’.

c. List the names of attendees who attended a workshop on the theme of ‘Virtual Reality’, ‘Big Data’, or both.

d. List the names of all attendees who attended a workshop run by a presenter from an institution in Queensland.

e. List the names of attendees from Murdoch University who went to a workshop on the theme of ‘Green IT’ run by a presenter from an institution in Tasmania.

f. List the workshop number, name and theme of all workshops, and the names of their attendees, if any.

g. List the name of any attendees who went to both the workshop named ‘Introduction to Oracle’ and the workshop ‘Normalisation 101’.

h. List the name, biography and institution of all presenters from an institution in South Australia.

i. List the names of the conference attendees who did NOT participate in the workshop named ‘Relational Algebra Masterclass’.

j. List the names of attendees who went to all workshops.