1. Produce an Entity-Relationship Model for the scenario2.Design a set of relations conforming to Boyce-Codd Normal Form
3.Implement your final database design
4.Query your database
5.Optimize your Database
6.Secure your Database

The coursework does not necessarily need to be perfect or excellent. It supposes to have more schematic diagrams rather than plenty of words. Essentially I just want to see how you would structure and write this coursework. The last task #7 Building a Web Interface of Assessment Brief may be omitted.

You may check the module units here
http://www.derbyonlinelearning.co.uk/content1.asp?MenuID=6814&courseId=Adv2299