Question 5 (Covers LO 5)

Describe and explain how the following database application techniques may be employed to enhance and extend the performance of your database:

• Indexes
• Triggers
• Stored Procedures

Ideally, you should attempt to implement (and evidence via screenshots) these coding techniques but if that is not possible, then at least explain what they do and what benefits they bring PLUS supplying the SQL code you would have executed.

(10 Marks)

NOTES

Thanks for helping me out on my Assignment - Database Implementation (Design Specification)

Please the Assignment should include:

Table of contents Introduction for:

Task 1 a and b (ERD Diagram, Assumption, Constraints, Identifier)

Task 2 (a, b, and c)

Task 3 Task

4 (a, b, and c)

Task 5

References (AU HARVARD SYSTEM(S)

Screenshot which shows my student's number in it (STU77923)

Recommendation

Conclusion

Appendix(es)

And all necessary things needed