Database Reference
In-Depth Information
2.4.
Discuss two challenges to distributed databases, and alternate
approaches for addressing each challenge.
{08}
3.1.
Describe two challenges to OO database management
systems.
{06}
3.2.
Describe one hybrid approach that facilitates the
peaceful coexistence of relational databases and
object technology.
{04}
26.10 Sample Interim Examination A
Instruction: Answer all four questions.
1a.
What are the main components of a Database System? With
the aid of a diagram, show how they are related.
{10}
1b.
State six objectives of a database system.
{06}
1c.
What is meant by data independence? Using example(s)
explain its importance.
{04}
2a.
Clarify the terms external schema, conceptual schema and
internal schema.
{06}
2b.
Clarify the terms data sub language (DSL), data definition
language (DDL) and data manipulation language (DML).
Relate SQL to these terms.
{08}
3a.
What are the main functions of the DBMS?
{06}
3b.
Give two examples of a DBMS.
{02}
3c.
What are the functional components of the DBMS? By use of a
diagram, show how they are related.
{12}
4a.
Define the following terms:
Primary key
{02}
Foreign key
{02}
Attributes
{02}
Relation
{02}
Domain
{03}
