Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Relational Algebra Queries for Conference Lecture Database

List of Lecturers and Their Universities

Question 1: Relational algebra

You have been asked to work with a database that records information about various lectures that are available for students at a conference. Each lecture addresses a topic, is presented by a lecturer. There are a limited number of seats in each of the venues, and this is reflected in the maximum number of students who can attend a lecture (capacity).The schema for this database is as follows: (note that primary keys are shown underlined, foreign keys in bold).
Provide relational algebra (NOT SQL) queries to find the following information.

NOTE:

You can use the symbols  s, P, 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 university of all lecturers.

b. List the lecture name and description for all lectures on the topic of ‘Biological Diversity’. 

c. List the names of students who attended a lecture on the topic of ‘Biological Diversity’, ‘Bugs and Bubs’, or both.

d. List the names of all students who attended a lecture by a lecturer from a university in Malaysia.

e. List the names of students from Murdoch University who went to a lecture on the theme of ‘Biological Diversity’ run by a lecturer from a university in Italy.

f. List the lecture number, name and topic of all lectures, and the names of the students that attended, if any.

g. List the name of any students who went to both the lecture named ‘Introduction to Biology’ and the lecture ‘Darwin 101’.

h. List the name, biography and university of all lecturers from a university in Greece.

i. List the names of the students who did NOT attend the lecture named ‘Grassland Cultivation Masterclass’.

j. List the names of any students who went to all lectures.


support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close