ONLY ER DIAGRAM WITH CROWFOOT NOTATION IS REQUIREWD.

The store from Task 3 now requires you to update and expand the previous database you designed for them, in order to record some additional information. You must update and expand your E-R models from Task 3 in order to incorporate these new requirements: Customers can now choose whether or not they wish to receive an email newsletter from the store. A new column in the customer entity is needed to store their choice. To receive more relevant newsletters, customers can specify which item categories they are interested in. Which customers are interested in which categories must be stored. The newsletter categories are the same as those which are linked to items. Customers can now define addresses which are stored in the database. A customer can define multiple addresses, and each address is associated with a single customer via their customer number. As well as specifying the address itself, customers can specify a name for the address, e.g. Home, and an address number is used to uniquely identify each address. Rather than storing addresses directly in the order details, the order details should now contain two foreign keys referencing the address entity one for the delivery address and one for the billing address. Create updated and expanded versions of your logical and physical E-R diagrams from Task 3 that incorporate these new requirements. You should not need to modify very much from your solution to Task 3 to complete this task; you mainly need to expand the diagrams by adding the new attributes, entities and relationships.