Question: Write SQL statements to realize the following: 3e. List all performances (PNO CNO MNO & PCOUNTRY) of compositions in the country of origin. [06] 3f.

Write SQL statements to realize the following: 3e. List all performances

Write SQL statements to realize the following:

3e. List all performances (PNO CNO MNO & PCOUNTRY) of compositions in the country of origin. [06]

3f. Give the ENO of every ensemble that includes a SAXAPHONE or CLARINET player, but not both. [06]

3g. Find CNO for compositions which have been performed in USA. [03]

3h. List countries in which MOZART's compositions have been performed. [03]

3i. Give ENAME of ensembles whose manager is AMERICAN, JAMAICAN, or RUSSIAN. [03]

Music Database Relations Musicians (Mog. MName, MDOB MCountry} PK (Mnol Compositions (Co. CTitle CMno. CDate} PK [Cng]: FK [CMng references Musicians) Ensembles {Eno, EName ECountry, EMnoMor} PK [Eno]; FK [EMnoMar references Musicians) Performances (Png. PDate. Pone PCity. PCountry Peno_CKs (PDate. Penol. Prel; FK [PCno references Compositions); FK [PEno references Ensembles] Ensemble Members (EmEng. EmMno, Emlostrument) PK [EmEng. Emunol: FK [EmEng references Ensembles); FK EmMno references Musicians)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Prepare a database specification (either a RAL or an ESG showing database-related details only) for the database. This database specification may be refined by introducing a sixth relational...

3. Write SQL statements to realize the following: 3a. List all registered musicians from USA or JAM (where "USA" and "JAM" are abbreviations for United States and Jamaica). [03] 3b. Give the ENO of...

Tasks: Write a SQL statement to select the database with your last name to store the data. If it does not exist in your MySQL server, use "CREATE DATABASE" command to create one. WRITE SQL statements...

* * * * Please write an sql script with the table provide * * * Objectives: Write SQL statements to define a database, to define tables, to view the table structures, to upload data into the tables...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Lab 2 Relational Database defining tables, viewing the structure of the defined tables, and adding records into tables. The outline of the script file lists as follows: Task 1 : Write a SQL statement...

Database schemas: Structured Query Language Purpose: To demonstrate the ability to write basic SQL statements for creating database structures and constraints, processing single and multiple tables,...

James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased form jewelry vendors, including such items as rings, necklaces, earrings, and watches, it...

have the value Junior. Write SQL statements to insert the data into each of the five Garden Glory Database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in...

Use the ER diagram below and perform following SQL statements: 1. Write SQL statements to create tables: EMPLOYEE, DEPARTMENT, JOB. Add primary and foreign keys (dept_no & mgr_code in table creation...

Explain the features of a futures contract that make it have less credit risk than a forward contract.

A sample of 300 adults is selected. The contingency table below shows their registration status and their preferred source of information on current events. Referring to Scenario 4-11, if an adult is...

Which of the following is NOT an example of a "derivative" as that term is used in GAAP?A corporate bond maturing in 1 0 yearsA forward contract to buy grainAn option to buy foreign currency at a...

A bench - scale bioreactor with a working volume of approximately 1 0 liter was used to facilitate an animal culture fermentation process. The bioreactor was operated at 4 0 0 r p m ( in which...

What is the default Aggregation Method in SQL Server Analysis Services in Cube Processing? What are the other options?

What is the default Aggregation Method in SQL Server Analysis Services in Cube Processing? What are the other standard optional methods?

Before starting an SQL Server Analysis Services Multidimensional Modeling Project, why is identification of a Data Source important?