Instructions: Need 3000+ words. This is a group assignment carrying 50% of the total marks available for the module. The group should not contain more than three (3) students or with at least a minimum of 2 students. Submission of coursework should only be through Turn-it-in and no submission in the form of hard copies will be accepted. Format of the report: Font size: 14 point for title/heading, 12 point for contents and 8-9 point for headers/footers. Font face: Arial. Line spacing: 1.5. Proper alignment of your paragraphs, and necessary page set-up.

Deliverables - This coursework forms 50% of your Assessment on this module. The other 50% is examination. Must be between 2, 000 to 3,000 words in length. Must make sufficient use of data/examples for the reader to understand the both the scale and reality of your chosen topic. Must be written is standard academic format with title, abstract, introduction, conclusion and a small number of section and reference details etc. Must make recommendation for future enhancements. You may include any number of appendices.

Marking Rubric: Database concept (10%) - Full list of attributes completed, attribute def., PK meaningful, all FKs correctly derived from the EERD, data values defined for each attribute meaningful, and clear evidence of M: N relations data included. Design and implementation (30%) - One NF has few anomalies but all normal forms, rules correctly applied. Pro-forma used. Excellent execution of all the queries with appropriate query logic. Database Security features (5%) - Excellent execution of all the queries with appropriate query logic which demonstrates the DB security. Presentation (5%) - Excellent group presentation which shows evidence of good design & implementation using Oracle.