Database Reference
In-Depth Information
c.
Different users of a database will have different external
perspectives of its data
d.
All of the above
10. Which of the following statements regarding the results of
normalization are false?
{02}
a.
Redundancy and data anomalies are reduced
b.
Redundancy and data anomalies are exacerbated
c.
Data integrity and data independence are enhanced
d.
Data integrity and data independence are compromised
11. Let R1[A,B,C] and R2[C,D,E] be two relations with R1.C being
defined on the same domain as R2.C. Assume further that
the primary key of R1 is A and the primary key of R2 is C. R2
consists of N2 tuples each of which is referenced by at least
one of the N1 tuples of R1. Which of the following assertions
are plausible/true?
{02}
a.
N1 > N2
b.
N1 < N2
c.
In order to purge (empty) both relations, one must purge
in the order {R1, R2}
d.
In order to purge (empty) both relations, one must purge
in the order {R2, R1}
12. How many standard normal forms are there?
{01}
a.
Three
b.
Four
c.
Five
d.
Six
13. A relation that is in BCNF is automatically in:
{02}
a.
3NF, 2NF and 1NF
b.
3NF and 2NF
c.
4NF and 5NF
d.
None of the above
Search WWH ::




Custom Search