Marking Criteria/Rubric

Assessment Criteria and Marking Overview Tasks Marks
1. Presentation
Cover page indicating student name and number and tutor name. 2
Page numbers included in report 2
Index giving page numbers of various sections 2
Overall presentation of the report 2
Full APA referencing of all materials used and full disclosure of assistance from all sources including tutors and other students. 2 10
2. E-R diagram
Completeness of diagram 12
Correct notation and convention used 8
All assumptions clearly noted 8
Primary and foreign keys 10
Resolution of many to many relationships 12 50

3. Normalization
All entities and relationship in appropriate normal form 10
Discussion of normalisation for all entities and relationships 5
Appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal. 5 20
4. Conversion of E-R diagram to relational schema
Correct standards, conventions and notation used 2
Primary keys used 2
Foreign keys correctly identified including parent entity 6
Schema is a correct translation of the E-R diagram submitted with appropriate tables, columns, primary keys, and foreign keys. 6
Types and restrictions on attributes given 4 20
Total 100
Feedback
Feedback will be provided via the marked rubric with comments handed out in the tutorial 2 weeks after the submission date. The marks will also be available on FDL Marks at this time.
Plagiarism:
Plagiarism is the presentation of the expressed thought or work of another person as though it is ones own without properly acknowledging that person. You must not allow other students to copy your work and must take care to safeguard against this happening. More information about the plagiarism policy and procedure for the university can be found