Database design involves a number of key steps,


such as identification of entities, identification of relationships, identifying attributes, representing the design as, for example, an ERD diagram and identifying keys and normalisation. Answer the following in this context.

a) Define the following concepts and provide an example for each:

i) Attribute

ii) Derived Data

iii) One-to-many relationship

iv) Recursive relationship

v) Foreign key.

b) Using an example, explain what a many-to-many relationship is and show how you would resolve this in your design.

c) Today, databases often support systems with web-based front ends. The architectural style used in this context is a three-tier architecture.

i) Give THREE reasons why a three-tier architecture is more desirable for web systems than a traditional client-server setup.
ii) Using a clearly labelled diagram show a typical three-tier architecture and explain the role of each tier.

Leave an answer

Sorry, you do not have permission to answer to this question .