Database Reference
In-Depth Information
26.5 Sample Assignment 4A
Figure 26-2 provides basic specifications for a music database. Carefully analyze the
figure, and answer the questions that follow.
Figure 26-2. Basic Specifications Music Database
1.
Write relational calculus statements to realize the following:
1a.
Registered musicians (MNO and MNAME) from USA or JAM
(where “USA” and “JAM” are abbreviated codes for United
States and Jamaica respectively).
{03}
1b.
List every ensemble (ENO) that includes a SAXAPHONE or
CLARINET player.
{03}
1c.
Give the ENO of every ensemble that includes a SAXAPHONE
but not a CLARINET player.
{04}
1d. List all compositions (CNO and TITLE) by MOZART. {04}
1e.
List all performances (PNO, CNO, MNO, and PCOUNTRY) of
compositions in the country of origin.
{06}
1f.
Give the ENO of every ensemble that includes a SAXAPHONE
or CLARINET player, but not both.
{06}
1g.
Find CNO for compositions all of which have been
performed in USA.
{03}
1h. List countries in which MOZART's compositions have
been performed.
{03}
1i.
Give ENAME of ensembles whose manager is
RUSSIAN.
{03}
2.
Write relational algebra statements corresponding
to each of the relational calculus statements
of question #1.
{35}
 
Search WWH ::




Custom Search