Assessment details for ALL students Assessment item 2—Assignment 2
Due date: Week 10 time) SMENT Weighting:
30%
Length:
Typically10-20 hours 2
Fridayof (Midnight AEST ASSES
Objectives This assessment itemrelates to all course learning outcomes in the course profile. Introduction This is a highlyindustryrelevant assignment. It consists of multiple parts:
Part A — Entity-Relationship Diagram(ERD)(40marks)
Part B — Table design (30marks)
Part C — Data Model Transformation (30marks) Students are expected to complete all parts.
Part A — Entity-Relationship Diagram (ERD)
(40 marks)
Draw an Entity-Relationship Diagram(ERD) for the data storage requirements of a business described in the case studybelow.
Notes:
It is recommended that you follow the modelling standard used in the text book and lecture slides.
Use onlyattributes that uniquelyidentifyinstances of an entitythat are mentioned inside the case study. Any other attributes that also could uniquelyidentifyentityinstances beyond the case studyshould notbe introduced.
Some information in the case studyis ambiguous, vague, and/or m This is intentional to encourage students to think, explore, and search for answers. There are two options: