This assessment item relates to all learning outcomes in the unit profile. Introduction This is a highly industry relevant assignment. It consists of two parts: • Part A — Entity-Relationship Diagrams...

This assessment item relates to all learning outcomes in the unit profile. Introduction This is a highly industry relevant assignment.  It consists of two parts:  • Part A — Entity-Relationship Diagrams (ERD) (50 marks) • Part B — Data Model Transformation Part A — Entity-Relationship Diagrams       Draw an Entity-Relationship Diagram (ERD) for the data storage requirements described in the case study below.   Some information in the case study will be conflicting, ambiguous, vague, and/or missing.  This should encourage you to think, explore, and search for answers.  Seek clarification and/or make reasonable assumptions to complete the requirements: your assumptions and clarifications need to support all details of the ERD that are not already provided by the case study. Document any assumptions you make and clarifications you obtain in an appendix named ‘Assumptions and Clarifications’.  There are two options: 1. Seek clarification about the case study by searching the forums.   If your question has not already been discussed, please post your question.   2. Make reasonable assumptions about missing or ambiguous information in the case study. However, marks may be lost for unreasonable assumptions.  For example, it is unreasonable to assume that people only ever buy one item or one type of item at a time