Assessable Tasks
a) Group Submission
From the BigM business requirements specified above, prepare a document according to the followings:
1. Use the supplied template for your Assignment submission.
2. An appropriate title page that includes the signatures of all students in the group and an acknowledgement of all students and staff you have spoken to about the assignment.
3. A table of contents and page numbers.
4. A logical ERD using the Crow’s Foot notation only. The diagram should include:
a) all entities, attributes, and relationships (including names);
b) primary keys (underlined) and foreign keys (italic) identified;
c) cardinality and modality symbols; and
d) assumptions you have made, e.g., how you arrived at the cardinality and/or participation for those not mentioned or clear in the business description, etc.
5. Normalisation of the relations which identifies:
a) covert each table to a relation schema;
b) dependency diagram or functional dependencies for each relation;
c) the level of Normalisation achieved for each relation; and
d) the reasons for any relation that is NOT maintained in 3NF.
6. A bibliography, containing all resources used to complete the assignment. If no resources have been used please indicate this appropriately.
b) Individual Presentation / Viva
In the week of the submission due date, students in each group will be required to attend the workshop/lab in-person/online. The tutor will assess each student via a brief presentation / viva.
Assessment Criteria and Marking Overview
Task a: The Group Submission Marks
Presentation
How clear and well-presented your submission is.
10
ERD
Adherence to the standard of the course, assumptions made, inclusion of correct primary and foreign keys, appropriate entities, relationships, and attributes. 60
Normalisation
Appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal. 30
Total 100
Out of 7% of the total assessment 7
Task b: Individual Presentation / Viva Marks
Correct answers to questions related to the assignment / submission.
3
Sub-total 3
Out of 3% of the total as