August
1999 QUESTION 1 (Compulsory) Total Marks: 20 Marks |
Click here to access other
questions
Click to access |
| (a) | (i) What is multi-valued attribute? (ii) Give an example of a simple E-R diagram to show how a multi-valued attribute would be represented. Explain how this representation would be changed by normalization.
|
[1] [3] |
| (b) | Give four reasons why normalization
is carried out.
|
[4] |
| (c) | Identify four models used in database
modelling.
|
[4] |
| (d) | What is meant by concurrency control?
|
[2] |
| (e) | State the Entity Integrity Rule.
|
[2] |
| (f) | List four operations that can be executed by
the Data Definition Language (DDL) component of the Structured Query Language
(SQL).
|
[4] |