This is one of many examples of database security having failed.
a) How would you embed database security at the following development stages in order to reduce the risk of security breaches?
i) Database requirements

ii) Database design.

b) Explain the following advanced Database Management System features and describe how they can be used to increase database security. Provide a simple code example for each of the two features showing its basic structure.
i) Database Triggers

ii) Stored Procedures.

c) Briefly explain the threats to online databases and detail how you would mitigate against the identified risks.