Database Reference
In-Depth Information
16c.
Based on the Figure
26-10
, clearly identify all relationships
and foreign keys.
{06}
16d.
Based on Figure
26-10
, describe, how you could obtain a
list showing course names and the corresponding names of
lecturers who teach these courses.
{02}
16e.
Based on Figure
26-10
, describe, how you could obtain a
list showing program names and the corresponding course
names in appropriate order for the college bulletin.
{02}
17.
17a.
Define the following terms:
Functional Dependence
{02}
Transitive Dependence
{02}
Non-loss decomposition
{02}
Boyce-Codd Normal Form
{02}
Multi-valued Dependence
{02}
Fourth Normal Form
{02}
17b.
As Database Manager or Information Systems Manager
in a software engineering firm, what standards would
you set in respect of logical database design? Justify
your position.
{08}]
Section C: Answer one question from this section.
Figure
26-2
, which provides an excerpt from the specification of a music database,
is repeated here (as Figure
26-11
) for ease of reference. Carefully analyze the figure, and
answer the questions that follow.
Figure 26-11.
Basic Specifications of Music Database
