Question

I need help with the following - Just some guidance and pointers as to how to get the most marks for these.

This question requires you to describe a specific database application to illustrate each of its parts.

a) Explain why more than one table may be necessary to implement a database for a particular application. Illustrate your answer with a specific example.

b) Explain the following terms using your example to illustrate them: i. Field ii. Record

c) Uniqueness is a common constraint on data.

Describe how this is ensured in a relational database and illustrate the concept using your example.

d) A second common constraint on data is that specific values are only permissible if they appear elsewhere in the database. Describe how this is ensured in a relational database and illustrate the concept using your example.