Draw the Entity-relationship diagram of a hypothetical database used by Kmart New Zealand. Consider the following requirements: (15 marks)

• at least 4 entities/tables;
• at least 4 attributes/fields for each entity;
• the primary key and foreign key (if applicable) for each entity/table;
• the types of relationships in the diagram (if applicable: try to avoid many-to-many

relationship and replace it with a join-table). Provide a short explanation for each designed relationship.