Give the relational calculus queries of players in sql, Database Management System

Assignment Help:

An orchestra database consists of the following relations:
CONDUCTS (conductor, composition)
REQUIRES (composition, Instrument)
PLAYS (Player, Instrument)
Give the relational calculus queries for the following:
(i) List the compositions and the players.
(ii) List the compositions which require the ‘violin' and the ‘congo'

Ans: (i) Tuple Calculus:
{r[Composition] || p[Player] | r ∈ REQUIRES ∧ p ∈ PLAYS
∧ r[Instrument] = p[Instrument]}
Domain Calculus:
{c || p | ∃i1, i2 ( ∈ REQUIRES ∧ ∈ PLAYS ∧ i1 = i2)}
(ii) Tuple Calculus:
{r[Composition] | r ∈ REQUIRES ∧ ∃u (u ∈ REQUIRES
∧ r[Composition] = u[Composition] ∧ r[Instrument] = ‘violin'
∧ u[Instrument] = ‘congo')}
Domain Calculus:
{c | ∃i1, c2, i2 ( ∈ REQUIRES ∧ ∈ REQUIRES
∧ c1 = c ∧ i1 = ‘violin' ∧ i2 = ‘congo')}


Related Discussions:- Give the relational calculus queries of players in sql

Determine object representation, Determine object representation As a ...

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

#title using the invoice, using the invoice table shown below,write the rel...

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Define the categories of sql statements, Define the categories of SQL State...

Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return

Implementing a data mining algorithm, i need to implememnt a treee based mi...

i need to implememnt a treee based mining algorithm. do you have an expert that can do that?

What is a recovery scheme, What is a recovery scheme? An integral part ...

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Access data using logical database, If one requires to access data using...

If one requires to access data using Logical Database , the use of events is unavoidable. Yes, if someone wants to access data using Logical database then the use of events

Organic compounds, #question.explain diversity and magnitude of organic com...

#question.explain diversity and magnitude of organic compounds and general properties?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd