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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more