Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TASK 4 You are given the following set of relations. COMPANY (name, city, country) DANCER (did, name, birthyear, country) SHOW (sid, title, choreographer, composer, year)
TASK 4 You are given the following set of relations. COMPANY (name, city, country) DANCER (did, name, birthyear, country) SHOW (sid, title, choreographer, composer, year) ROLE (did(FK: dancer.did), sid FK: show.sid), role, companv(FK: company.name)) Write the following queries as Relational Algebra Expressions. 1) Find all dancers who worked with at least 3 choreographers in companies that are originated in Russia. 2) Find all shows whose choreographer is also choreographer of the show that Maria who is a German dancer performed in 2016 for Martha Graham Dance Company. 3) Find all companies that has exactly 9 shows in 1999 and dancers of the shows are Italian
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started