Database Reference
In-Depth Information
2c.
State four (4) significant roles/functions of the DBMS.
{04}
2d.
What is the difference between a DBMS and a compiler?
{02}
Section B: You may do one question from this section.
3.
The following atomic data elements were taken from the data
dictionary of an inventory management system:
Figure 26-8a.
Excerpts from Inventory Management System
Put the elements into normalized relations, clearly stating
the basis for your decision. You may introduce data
elements as required. Clearly state any assumptions or
observations made.
{20}
4.
4a.
Complete the following triplets with the most appropriate
words or expressions to be taken from the list provided in
Figure
26-8b
.
{10}
4b.
Give a formal definition of a relation. Clarify any ambiguity
that may exist between an entity and a relation.
{04}
4c.
State three (3) kinds of relations that may be found in a
database; explain what each is with an example.
{06}
