Database Reference
In-Depth Information
14.
In database systems, a surrogate:
{02}
a.
Is a relational table that is not related to other tables in
the database
b.
Is a system-controlled primary key, introduced by the
designer
c.
Is sometimes introduced to avoid using a cumbersome
composite primary key.
d.
Is a database designer that gets no credit for his/her work
15.
An ERD is useful to:
{01}
a.
Show the interrelationships among application programs
of a system
b.
Represent the relationships among application programs
and database tables
c.
Illustrate the various external view that users of a database
might have
d.
Illustrate the main entities and relationships of a
database system
Section B: Answer one question from this section.
16.
16a.
Give a formal definition of a relation. Clarify any ambiguity
that may exist between an entityand a relation.
{04}
16b.
State three (3) kinds of relations which may be found in
a database; for each type, explain what it is and give an
appropriate example.
{06}
16c - 16e.
The following is an excerpt from a college
database design proposal (Figure
26-10
):
Figure 26-10.
Except From a College Database
