s: Q1: Data Management: Entity Relationship Diagram & MS Access (50 Marks) a. Draw the ERD of the database that could be used to support the operations of the business described in the case (20 marks). The ERD should identify: Primary keys and Foreign keys; Entities and at least three Attributes for each entity; Relationships and Cardinalities (e.g., one-to-one, one-to-many). Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the above case does not provide the information necessary to know which design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions