Relational Databases 2 Exercise Sheet 7: Transaction Processing 2 (until Friday 18.07.2014)

CREW(movie, person not null , type not null , creditpos) REMARK(movie, person not null , remark not null ) GENRE(movie, genre not null ).. COUNTRY(movie, country not

c) A query for creating a list of aliases and the according first names and last names. Assume the relations given in Appendix A. a) Rewrite query c) from exercise 1 using

Assume the relations given below. Draw an canonical operator tree for the following query:. SELECT

Exercises have to be turned in until Thursday before the lecture either in the lecture hall or into our mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2 nd floor). Please do

Exercises have to be turned in until Thursday before the lecture either in the lecture hall or into our mailbox at the IFIS floor (Mühlenpfordtstraße 23, 2 nd floor)..

Exercises have to be turned in until Thursday before the lecture either in the lecture hall or into our mailbox (Informatikzentrum 2 nd floor). Please do not forget

Given a database schema based on the CREATE TABLE statements from Exercise 0 and using the SQL syntax introduced in the lecture, provide INSERT, UPDATE, and DELETE statements for the

If the scheduler can choose which operation to execute, it chooses the operation that has been occurred earlier in