Database Reference
In-Depth Information
18.
Provide sample data of the above relations. {bonus 04}
Write relational calculus statements to realize the following:
18a.
List registered musicians from CUB or CAN (where “CUB”
and “CAN” are abbreviated codes for Cuba and Canada
respectively).
{03}
18b.
Give the ENO of every ensemble that includes a Violin or
Violin player.
{03}
18c.
Give the ENO of every ensemble that includes a Violin
player but not a Guitar player.
{04}
18d.
List all compositions (CNO and TITLE) by
David Foster.
{04}
18e.
List all performances (PNO CNO MNO & PCOUNTRY)
of compositions that have been performed in the
country of origin.
{06}
19.
Provide sample data of the above relations. {bonus 04}
Write relational algebra statements corresponding to
specifications of 18a - 18e above.
{20}
Section D: Answer one question from this section.
20.
20a.
How important are logical views in a database?
{04}
20a - 20f.
The college database of question 16 is repeated
here for ease of reference.
Based on the schema provided in Figure
26-12
, write SQL statements
to do the following:
20b.
Create a view which will allow three of the above tables to
be joined as one, so as to provide information for the college
bulletin. The information required should include Program
Code, Program Name, Course Sequence, Course Number,
and Course Name.
{04}
20c.
Assuming the existence of a program with code “P01” and
name “BS. in Mathematics,” extract from the system, the
program structure for this program with courses listed
in order of sequence number. The data fields required
are outlined in 20b above.
{04}
