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

Explain the term- collation, What is Collation Collation is a kind of ...

What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

Draw an e-r diagram and convert it to a relational schema, In an organisati...

In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on

Compare three clustering algorithms in weka, Compare three clustering algor...

Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Define specialisation and generalization in brief, Define Specialisation an...

Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element

Database problem in wordpress, Project Description: I am having a random...

Project Description: I am having a random problem with my Wordpress site. If I click on "Publish" and "Add new", it takes me to a 404 page not found of /wp-admin/post.php (th

Illustrate the view of software architecture, Illustrate the view of softwa...

Illustrate the view of software architecture A model is a semantically closed abstraction of system composes of elements. It can be visualized using any of the following five v

Text mining, Text Processing: Use readLines to read SOU.txt into R. Cr...

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin

ERD, online eductional management system ke diagram

online eductional management system ke diagram

What are the comparison operator in sql, What are the comparison operator i...

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

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