Advanced Database Development Part 3

Why do we normalise?

• Make it easier for other systems to use the database

• Because the industry recommends it

• Stop data anomalies

• Remove data redundancy

The ANSI-SPARC model is recommended because

• It allows data independence

• It provides better error handling

Database Security is protecting data against

• Unauthorised disclosure

• Authorised Alteration

• Unauthorised Alteration

• Unauthorised Destruction

Integrity is

• The accuracy of the data

• The lifespan of the data

• The validity of the data

• The protection of the data

A functional dependency determines the relation of one attribute to another attribute.

• True

• False

For normalisation, up to BCNF, we use Functional Dependencies

• True

• False

When we consider nulls, the common meanings of them are:

• Not known

• Not applicable

• Not calculated

What are the types of column overloading?

• Overlapping Attributes

• Null Attributes

• Concatenated Attributes

• Encoded Attributes